摘要: mysql> select * into outfile '/home/angelmylove/mysql/student.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' from student limit 100;ERROR 1 (HY000): Can't create/write to file '/home/angelmylove/mysql/student.txt' 阅读全文
posted @ 2013-01-21 14:54 尹少爷 阅读(899) 评论(0) 推荐(0) 编辑
摘要: 创建用户 create user 用户名 indentified '用户密码';赋予权限: grand 权限 on 数据库名.表名称 to 用户名 indentified by '密码'权限意义ALL [PRIVILEGES]设置除GRANT OPTION之外的所有简单权限ALTER允许使用ALTER TABLEALTER ROUTINE更改或取消已存储的子程序CREATE允许使用CREATE TABLECREATE ROUTINE创建已存储的子程序CREATE TEMPORARY TABLES允许使用CREATE TEMPORARY TABLECREATE U 阅读全文
posted @ 2013-01-21 13:40 尹少爷 阅读(306) 评论(0) 推荐(0) 编辑