linux(mysql(二))

如果要改变整个mysql的编码格式：启动mysql的时候，mysqld_safe命令行加入 --default-character-set=gbk 
alter database db_name default character set gbk; #改变某个库的编码格式
select fname ,"age is:",age from [table]; #添加说明列
select * from [table] into outfile "[文本路径]" lines terminated by "\r\n"; #把数据库中[table]表里的数据导出到txt文件中,其中lines terminated by "\r\n" 表示每一行（即每一条记录）用\r\n分隔，\r\n是window系统的换行符
如导入txt文件时,字段之间用的,分隔
mysql> load data local infile "[文本路径]" into table [table] fields terminated by ',' ;
如导入txt文件时,字段之间用的;分隔
mysql> load data local infile "[文本路径]" into table [table] lines terminated by  ';' ;
直接导出的方式:
[Sunrier@localhost MySql]$ mysql -uSunrier -predhat -e "use [databases];select * from [table] into outfile '[文本路径]' fields terminated by '|' lines terminated by '|\r\n' ;"
导出的内容为:
1|Jack|67|
使用Linux下Shell脚本的方法:
mysql -uSunrier -predhat <<EOF  
use [databases];  
select concat(studno,"|", fname ,"|",age,"|") from [table] into outfile '[文本路径]';  
EOF  
drop database if exists [databases]; --如果存在[databases]则删除