个人日记-数据库简单操作

use mldn; //使用数据库


//创建数据库表
CREATE TABLE mytab(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
password VARCHAR(32) NOT NULL,
age INT NOT NULL,
sex VARCHAR(2) NOT NULL,
birthday DATE NOT NULL
)


DROP TABLE mytab；


//查看您数据库
DESC mytab; 


show databases; 
show tables;


CREATE TABLE user(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
password VARCHAR(32) NOT NULL,
age INT NOT NULL,
sex VARCHAR(2) NOT NULL,
birthday DATE NOT NULL
)


INSERT INTO user(name,password,age,sex,birthday) VALUES ('赵强','zhaoqiang',28,'男','1989-12-29');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('卞银燕','zhaoqiang',28,'女','1989-12-12');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('张三','zhaoqiang',28,'男','1989-12-29');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('李四','zhaoqiang',28,'女','1989-12-12');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('王五','zhaoqiang',28,'男','1989-12-29');
INSERT INTO user(name,password,age,sex,birthday) VALUES ('赵启','zhaoqiang',28,'女','1989-12-12');


DELETE FROM user WHERE id=3 ;


UPDATE user SET name='MLDN',age=5,birthday='2000-08-27' WHERE id=4 ;


SELECT name,birthday FROM user ;


SELECT * FROM user WHERE name LIKE '%赵%' OR password LIKE '%m%' ;


SELECT * FROM user WHERE name LIKE '%m%' OR password LIKE '%m%' LIMIT 10,5 ;