mysql数据库基本使用

#创建库：

CREATE DATABASE `user` CHARACTER SET utf8 COLLATE utf8_general_ci;

#创建用户并授权：

CREATE user 'user_test'@'%' IDENTIFIED BY 'user';
GRANT ALL ON user.* TO user_test;
FLUSH PRIVILEGES;

#忽略外检删除表：

SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE auth_group;                
DROP TABLE auth_group_permissions;     
DROP TABLE auth_permission;            
DROP TABLE auth_user;                  
DROP TABLE auth_user_groups;           
DROP TABLE auth_user_user_permissions; 
DROP TABLE django_admin_log;           
DROP TABLE django_content_type;        
DROP TABLE django_migrations;          
DROP TABLE django_session;  
SET FOREIGN_KEY_CHECKS = 1;

#插入：

INSERT INTO USER (***, ***, ***,) VALUES (***，***，***);

#更新

UPDATE USER SET username='***' WHERE email='***'