Mysql 命令积累总结
- 创建数据库 create database databaseName;
- 创建用户 create user userName @’localhost’ identified by ‘userPassword’;
- 为用户赋权限grant all privileges on databaseName.* to userName ;
- 查看当前用户下数据库:show databases;
- 查看数据库中所有表:show tables;
- 查看表所有属性:show columns from XXX;
- 删除表字段:alter table tableName drop columnName;
- 为表增加字段:alter table tableName add columnName columnType;
- 将某字段设为主键;alter table tableName add primary key(keyName);
- 改变字段属性:alter table tableName modify columnName cloumnType [null or not]