导出csv
select * from test_info
into outfile ‘/tmp/test.csv’
fields terminated by ‘,’ optionally enclosed by ‘”‘ escaped by ‘”‘
lines terminated [Read More…]
Archive for August, 2015
[AMP] Mysql 字符集设置
2015.8 28
MySQL字符集设置
• 系统变量：
– character_set_server：默认的内部操作字符集
– character_set_client：客户端来源数据使用的字符集
– character_set_connection：连接层字符集
– character_set_ [Read More…]
[AMP] mysqlimport: Error: 13, Can’t get stat of
2015.8 27
[root@sun ~]# mysqlimport –fields-terminated-by=, –lines-terminated-by=\n ziliao ./a.csv
mysqlimport: Error: 13, Can’t get stat of ‘/var/lib/mysql [Read More…]
