mysql 常用命令

1、导出数据，不输出列名，用tab作为分隔符（-N Don't write column names in results. -s Print results with a tab as separator, each row on new line.）

mysql -u root -p***l -e "select * from record;" dating -sN

 

2、批量插入数据：

(

 

mysql> select version();

+-----------+

| version() |

+-----------+

| 5.0.67    | 

+-----------+

1 row in set (0.00 sec)

 

)

 

load data infile "/home/chengyi/tmp.txt" into table pet; 

 

#LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;  使用这个的时候报错，版本不支持

 

load data infile "/home/chengyi/tmp.txt" into table pet

FIELDS TERMINATED BY '  ' ENCLOSED BY '' ESCAPED BY '//'; # 指定分隔符

 

为了生成适合导入的数据：

 

select 　* from pet into outfile "/home/chengyi/tmp.txt";

 

可以通过查看load data的帮助：

 

help load data;