Mysql执行批量sql时的格式问题:
mysql执行批量sql时,输出格式想和在mysql提示符下一致的话,使用-t 选项
-t, --table Output in table format.
例:
没有使用-t的样式:
[mysql@localhost tmp]$ mysql -u root -p < /home/mysql/select_tt.txt | less
Enter password:
id idd
99999 99999
2147483647 2147483647
123456 123456
Enter password:
id idd
99999 99999
2147483647 2147483647
123456 123456
使用-t的样式 :
[mysql@localhost ~]$ mysql -t -u root -p < /home/mysql/select_tt.txt | less
Enter password:
+------------+------------+
| id | idd |
+------------+------------+
| 99999 | 99999 |
| 2147483647 | 2147483647 |
| 123456 | 123456 |
+------------+------------+
Enter password:
+------------+------------+
| id | idd |
+------------+------------+
| 99999 | 99999 |
| 2147483647 | 2147483647 |
| 123456 | 123456 |
+------------+------------+