![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
wayneshu
这个作者很懒,什么都没留下…
展开
-
数据库和文件的导入导出
mysql 导出生成文件 select * into outfile "/root/tmp.txt" from check_account where isAccountBalance=0; 文件导入mysqlload data local infile "/tmp/tmp.txt" into table check_account informix导出生成的文件u原创 2009-08-05 12:49:00 · 172 阅读 · 0 评论 -
mysql结束符修改(“;”修改为“//”)----------delimiter
mysql> delimiter //mysql> select * from test -> ; -> //+------+------+| jydm | jye |+------+------+| 1220 | 1 || 1218 | 2 || 1114 | 3 |+------+------+3 rows in set (0.03 sec)mysql> s原创 2009-06-24 19:00:00 · 915 阅读 · 0 评论