摘要: 一、首先要mysql授权 mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;Query OK, 0 rows affected (0... 阅读全文
posted @ 2018-09-16 19:16 莫逸风 阅读(80) 评论(0) 推荐(0) 编辑
摘要: 1、将表输出到文件 select * FROM zhilianzhaopin4 INTO OUTFILE 'G:/test.csv' --------输出位置 fields terminated by '@@' --------字段用@... 阅读全文
posted @ 2018-09-16 13:26 莫逸风 阅读(48) 评论(0) 推荐(0) 编辑