一、数据库操作
- 数据库的创建
CREATE DATABASE mydb1;
CREATE DATABASE mydb2 CHARACTER
SET utf8;
CREATE DATABASE mydb3 CHARACTER
SET utf8 COLLATE utf8_general_ci;
- 数据库的修改
ALTER DATABASE mydb2 CHARACTER
SET gbk
- 数据库的删除
DROP DATABASE
IF
EXISTS mydb3;
- 数据库的查看
SHOW DATABASES;
SHOW CREATE DATABASE mydb1;
数据库中表操作
USE mydb1;
DROP TABLE
IF
EXISTS employee;
CREATE TABLE employee (
id INT PRIMARY KEY auto_increment,
NAME VARCHAR (20) NOT NULL,
gender VARCHAR (20),
birthday DATE,
entry_date DATE,
job VARCHAR (20),
salary DOUBLE,
resume TEXT
);
SELECT * from employee
DROP TABLE
IF
EXISTS employee2;
CREATE TABLE employee2 (
id INT PRIMARY KEY auto_increment,
NAME VARCHAR (20) NOT NULL,
gender VARCHAR (20),
birthday DATE,
entry_date DATE,
job VARCHAR (20),
salary DOUBLE,
resume TEXT
);
SELECT * from employee2
DROP TABLE
IF
EXISTS employee2;
ALTER TABLE employee ADD image BLOB;
ALTER TABLE employee MODIFY job VARCHAR(60);
ALTER TABLE employee DROP gender;
RENAME TABLE employee TO user;
ALTER TABLE user CHARACTER SET utf8;
ALTER TABLE user CHANGE COLUMN name username VARCHAR(30);
SHOW TABLES;
SHOW CREATE TABLE user;
desc user;
三、表记录的操作
INSERT INTO user(username) VALUES("zs"),("ls"),("wangwu");
UPDATE user set salary=5000;
UPDATE user set salary=3000 WHERE username="zs";
UPDATE user set salary=4000,job="ccc" WHERE username="ls";
UPDATE user set salary=salary+1000 WHERE username="wangwu";
DELETE FROM user WHERE username="zs";
DELETE FROM user;