摘要:
1.Windows下的命令 启动服务:mysqld --console 或 net start mysql 关闭服务:mysqladmin -uroot -p shudown 或 net stop mysql 2.Linux下的命令 启动服务:service mysql start 关闭服务:ser 阅读全文
摘要:
select * from cr01 into outfile 'C:/Users/del/Desktop/table1_data.csv' character set gb2312 fields terminated by ',' optionally enclosed by '"' escape 阅读全文
摘要:
导出文本文件: select sx,mz,bz from cr01 into OUTFILE 'C:/Users/del/Desktop/a.txt' fields terminated by ':' LINES TERMINATED BY '\r\n'; 导入恢复: load data infil 阅读全文