3-28 MySQL 增删改
时间：2021-07-01 10:21:17
帮助过：4人阅读
int(4
) NOT NULL PRIMARY key auto_increment,
`name` VARCHAR(20) NOT NULL DEFAULT ‘匿名‘
,
sex VARCHAR(2) NOT
null DEFAULT ‘1‘
,
phone BIGINT(11
),
role int(2
),
score int(4
)
)
INSERT INTO student
VALUES (DEFAULT,‘zhangsan‘,2,13837689458,1,54
);
INSERT INTO student
VALUES (DEFAULT,‘lisi‘,2,18888888888,2,90
);
INSERT INTO student
VALUES (DEFAULT,‘wangwu‘,1,16666666666,3,94
);
INSERT INTO student
VALUES (DEFAULT,‘zhaoliu‘,2,15555555555,3,82
);
UPDATE student SET Phone=18650170763 WHERE id=2
;
SELECT*FROM student WHERE score<60
;
SELECT* FROM student WHERE name LIKE‘z%‘
;
SELECT * FROM student WHERE role IN (1,3
);
DELETE FROM student WHERE role=1
;
DELETE FROM student;
3-28 MySQL 增删改
标签：图片 mysql like hone http tab auto 技术 def
