mysql
iteye_6336
这个作者很懒,什么都没留下…
展开
-
mysql常用操作
编译安装[code="java"]apt-get install lib32ncursesw5-dev[/code]添加一个可远程登录的超级用户mysqladmin[code="java"]grant all on *.* to mysqladmin@'%' identified by 'mysqladmin';FLUSH PRIVILEGES;[/code]重置r...原创 2011-12-12 11:14:25 · 77 阅读 · 0 评论 -
mysql数据导入导出
SELECT INTO OUTFILE[code="java"]mysql -uroot -ppasswd -h 192.168.0.1 -P 3306 -e "select name, sex, age into outfile 'out.csv' FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '\"' LINES TERMINAT...2013-05-03 17:18:21 · 110 阅读 · 0 评论