Linux平台下MySQL命令操作
Linux平台下MySQL命令操作
Linux shell 批量创建数据库/表
Shell 脚本如下:
- # create database and table
- HOST='localhost'
- PORT='3306'
- USER='root'
- PWD=''
- DBNAME='top123'
- TABLENAME='gametop800'
- mysql_login=''
- mysql_create_db=''
- mysql_create_table=''
- function mysql_create(){
- echo "login mysql $HOST:$PORT ..."
- mysql_login="sudo mysql -h $HOST -P $PORT -u $USER" # mysql -h host -P port -u root -p pwd
- echo | ${mysql_login}
- if [ $? -ne 0 ]; then
- echo "login mysql ${HOST}:${PORT} failed.."
- exit 1
- fi
- echo "create database $DBNAME ..."
- mysql_create_db="create database if not exists $DBNAME"
- echo ${mysql_create_db} | ${mysql_login}
- if [ $? -ne 0 ]; then
- echo "create db ${DBNAME} failed.."
- exit 1
- fi
- echo "create table $TABLENAME ..."
- mysql_create_table="create table $TABLENAME(
- id char(50) not null,
- top int,
- name char(100),
- category char(50),
- rating float,
- ratingcount char(20),
- download char(30),
- price char(20),
- publishdate char(20),
- version char(40),
- filesize char(40),
- requireAndroid char(40),
- contentrating char(40),
- country char(10),
- dtime datetime not null,
- primary key(id, dtime)
- )"
- echo ${mysql_create_table} | ${mysql_login} ${DBNAME}
- if [ $? -ne 0 ]; then
- echo "create table ${TABLENAME} fail..."
- exit 1
- fi
- echo "create table ${TABLENAME} success!"
- }
执行脚本后,结果如下:
MySQL 从常用操作命令:
显示数据库
show databases;
切换数据库
use top123;
显示数据库表
show tables;
修改主键
alter table gametop800 add primary key(id);
删除主键
alter table gametop800 drop primary key;
添加组合主键
alter table gametop800 add primary key(id, dtime);
如果感兴趣的话,可以深入综合运用awk,cut,paste,正则表达式,数据库操作等较为复杂的语法,完成MySQL数据库操作
下面是实现了一个抓取网页,提取特征,抽取信息,结果汇总,批量插入数据库永久保存
示例:
评论暂时关闭