关于mysql:mySql常用语句新增查询修改删除

一、mySql罕用语句
1、新增数据库

CREATE TABLE sys_list (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键ID，主动递增’,
title varchar(32) NOT NULL COMMENT ‘题目’,
content varchar(200) NOT NULL COMMENT ‘内容’,
photo varchar(32) NOT NULL COMMENT ‘图片’,
author varchar(32) NOT NULL COMMENT ‘作者’,
type enum(‘1′,’2’) NOT NULL COMMENT ‘类型’,
createTime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
updateTime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2、新增一条数据
insert into sys_list values(1,’题目1′,’内容1′,”,’2020-10-07′,’2020-10-07′)

3、查问一条数据
select * from sys_brand d where d.id=1 //通过id查问
select * from sys_brand d where d.title like ‘%标%’ //通过title含糊查问

4、批改一条数据
update sys_list set title=’题目11′,content=’内容11′ where id=’1′

5、删除一条数据
delete from sys_list where id=’1′