数据库常用查询2

show databases;
use demo;
select DATABASE();
drop table user;

create table if not EXISTS user(
id int UNSIGNED primary key auto_increment,
name VARCHAR(20),
gender enum('男','女','保密') DEFAULT '保密'
);
show tables;
desc user;

-- 插入数据
insert into user (name) values('Alex');
insert into user (name,gender) values('张三','男'),('李四','女'),('王五','男');

select * from user;

delete from user;
delete from user where id =6;

update user set name = 'lisa';
update user set name = 'lisa' ,gender = '女' where id = 7;

CREATE table if not EXISTS student(
id int UNSIGNED PRIMARY key auto_increment,
name VARCHAR(20) not null,
age TINYINT UNSIGNED not null,
gender enum('男','女','保密') DEFAULT '保密',
class VARCHAR(20),
createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP on UPDATE CURRENT_TIMESTAMP
);
desc student;
INSERT INTO student (name , age ,gender, class ) VALUES ('张三',18,'女','2班'),('李四',19,'男','1班'),('王五',18,'女','2班'),('lisa',19,'女','2班'),('Alex',18,'男','1班');