第十六课 更新和删除数据
一、更新数据
(1)SET命令将新值赋给被更新的列
UPDATE inf
SET age = '69',
city = 'F'
WHERE id = 5;
二、删除数据
(1)delect from指定要删除数据的表名;WHERE子句过滤要删除的行
DELETE FROM score2
WHERE id = 1;
(1)SET命令将新值赋给被更新的列
UPDATE inf
SET age = '69',
city = 'F'
WHERE id = 5;
(1)delect from指定要删除数据的表名;WHERE子句过滤要删除的行
DELETE FROM score2
WHERE id = 1;