库的相关操作
– 查看已有库
SHOW DATABASES;
SHOW DATABASES;
SHOW DATABASES\G
– 新建库的操作
CREATE DATABASE 库名;
CREATE DATABASE `ET`;
– 查看建库信息
SHOW CREATE DATABASE 库名;
SHOW CREATE DATABASE `ET`;
– 把一个库设置为默认库
USE 库名;
USE ET;
– 删除库
DROP DATABASE 库名;
DROP DATABASE ET;
表相关操作
– 建表
CREATE TABLE 表名 (列名 列类型, …, 列名 列类型);
CREATE TABLE students (
id INT,
name VARCHAR(30),
idcard CHAR(18)
);
– 查看有默认库下有哪些表
SHOW TABLES;
SHOW TABLES;
– 查看建表信息
SHOW CREATE TABLE 表名;
DESC 表名;
SHOW CREATE TABLE students;
DESC students;
– 删表
DROP TABLE 表名;
DROP TABLE students;
– 修改表名称
RENAME TABLE 旧表名 TO 新表名;
RENAME TABLE students TO ET_students;
– 插入数据
INSERT INTO students (id, name,idcard) VALUES
(1,"张三",111);
– 修改数据
UPDATE students SET name = '张三' WHERE id = 2;
– 查询
SELECT * FROM students WHERE name = '张三';
– 删除
DELETE FROM students WHERE name = '张三';