参考： http://blog.youkuaiyun.com/lonesomer/archive/2006/05/04/708193.aspx实例：use mydb;select * from person into outfile "d:\data.txt";use otherdb;load data local infile "d:\data.txt" into table perso...

表结构如下:mysql> select * from test;+—-+——-+| id | name |+—-+——-+| 1 | test1 || 2 | test2 || 3 | test3 || 4 | test4 || 5 | test5 |+—-+——-+执行以下SQL:mysql> select * from t...

### Error querying database.  Cause: java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 19 to TIMESTAMP.### The error may involve com.dajie.core.user.dao.UserDao.getByUid-...

实例：SELECT GROUP_CONCAT(uid) FROM tb_user_email WHERE email IN ('qa201@xxx.com', 'qa202@xxx.com');结果集： 3076028,3076271  参考：MySQL中group_concat函数完整的语法如下：group_concat([DISTINCT] 要连接的...