Perror的博客

创建数据库: CREATE DATABASE db_name CHARACTER SET utf8 查看所有的数据库: SHOW DATABASES; 查看数据库信息: SHOW CREATE DATABASE db_name; 删除指定数据库信息: DROP DATABASE db_name; 修改指定数据库信息: ALTER DATABASE CHARACTER SET...

创建表: CREATE TABLE table_name(id int PRIMARY KEY, name CHAR(50) NOT NULL); 删除表: DROP TABLE table_name; 修改表添加新的字段: ALTER TABLE table_name ADD user_id int NOT NULL; 修改表修改现有字段: ALTER TABLE table_...

单表查询: SELECT * FROM table_name; 单表指定字段查询: SELECT id, user_id FROM table_name; 单表指定查询条件查询: SELECT * FROM table_name WHERE id > 2; 多表查询: SELECT * FROM table_name, table_name1; 多表指定字段查询: S...

更新表字段值: UPDATE table_name SET sex = 1 WHERE userid = 3; 删除表字段值: DELETE FROM table_name WHERE userid = 3; 删除表字段值中的第一条: DELETE FROM table_name WHERE userid > 3 ORDER BY userid DESC LIMIT 1;...