mysql 学习笔记

vio

1) mysql -e "mysql command"
etc:
mysql -e "select * from DB;" -u.. -p.. DB

2) group_concat()
etc:
select a,group_concat(b) from DB where a='..' group by a;

3) concat_ws;
mysql> select concat_ws('-',COLLECTION_NAME,PLATE,ROW_POS,COL_POS) as platewell from _glz_mgc2gene limit 10;
+--------------+
| platewell    |
+--------------+
| IRAU-44-h-2  |
| IRAU-33-f-11 |
| IRAU-29-h-2  |
| IRAU-44-c-4  |
| IRAT-4-d-8   |
| IRAU-39-d-9  |
| IRAU-33-c-3  |
| IRAT-6-e-11  |
| IRAU-27-h-8  |
| IRAU-30-f-6  |
+--------------+
10 rows in set (0.00 sec)

4) 只导出结构
mysqldump -d 或者 mysqldump --no-data   
只导出数据
mysqldump --no-create-info



本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/20591/showart_172973.html