尹少爷

摘要： 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' 阅读全文

摘要： 创建用户 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 阅读全文