mysql简单sql语句_mysql数据库简单sql语句

创建数据库：CREATE DATABASE DB-NAME; CREATE DATABASE IF NOT EXISTS DB-NAME; 查询数据库 SHOW DATABASES; 删除数据库DROP DATABASE DB-NAME; 创建表  CREATE TABLE IF NOT EXISTS student(name CHAR(10) NOT NULL,age INT UNSIGNED NOT NULL,xingbie CHAR(1) NOT NULL); 查看表 SHOW TABLES;//SHOW TABLES FROM DB-NAME; 查看表结构 DESC 表名; 删除表 DROP TABLE 表名; 给表添加数据(列) ALTER TABLE DB-NAME ADD course VARCHAR(10); 修改列 ALTER TABLE student CHANGE course Course VARCHAR(10) AFTER name; 删除列 DROP 列名; 插入 INSERT INTO student(name,Course,age,xingbie) values ('jieke','wuli',78,'f'); 查询 SELECT *FROM student; SELECT name,Course FROM student; WHERE 指定选择条件 SELECT name,Course FROM student WHERE xingbie='m'; 更改 UPDATE student SET Course='fuck' WHERE name='jieke'; 删掉 DELETE FROM student WHERE Course='fuck';