学习笔记（4):MySQL数据库从入门到实战应用-数据库的基本概念

立即学习:https://edu.csdn.net/course/play/27328/362511?utm_source=blogtoedu

create table contacts(
    id int not null auto_increment primary key,
    name varchar(50),
    sex tinyint default 1,
    phone varchar(20)
)
 

desc contacts;

 


insert into contacts(name,sex,phone) values('张三',1,'13900000000');
insert into contacts(name,sex,phone) values('Tom\'s cat',1,'13900000001');
insert into contacts(name,sex,phone) values("Lily's cat",1,'13900000002');
insert into contacts(name,phone) values('李四','13900000003'),('王五','13900000004'),('赵六','13900000005');

update contacts set sex=2 where id=6;

update contacts set sex=2,phone='18900001111' where id=5;

delete from contacts where id=2;

delete from contacts;