MySQL早作业1

create table news(
	newsID int primary key auto_increment,
	newsTitle varchar(50),
	editer varchar(50),
	upDateTime Date,
	content varchar(500)
);	
1.
insert into news values('蔡徐坤打篮球','亿万粉丝',now(),'帅就完事了'),('马云不爱钱','亿万粉丝',now(),'牛就完事了');
insert into news values('第一','Carl_蔡先生','2018-07-18','体育'),('最编程','李玲','2017-5-18','Java');
2.
update news set content='体育爱好者' where content='体育';
3.
delete from news where year(now())-year(upDateTime)=0;
4.
select *from news order by upDateTime desc;
5.
select *from news where content='Java' and editer='李玲';
6.
select *from news where newsTitle like '%第一%' or newsTitle  like '%最%';
7.
drop table news;