1、update 基本用法:
2、在update中使用公式:
3、删除行:
4、从多个表中删除:
UPDATE
book
SET
cond
=
'
mint
'
;
一般不要这么用,因为这会将一个column的所有行的cond设为 'mint'。
UPDATE
book
SET
author
=
"Theodor Geisel"
WHERE
author
=
"Dr. Seuss";
2、在update中使用公式:
UPDATE
loan
SET date_lent = DATE_ADD(date_lent, INTERVAL 1 YEAR )
WHERE date_lent = ' 2005-01-01 ' ;
SET date_lent = DATE_ADD(date_lent, INTERVAL 1 YEAR )
WHERE date_lent = ' 2005-01-01 ' ;
3、删除行:
DELETE
FROM
book
WHERE
cond
=
'
poor
'
;
如果省略 where 语句,则会删除掉所有列
4、从多个表中删除:
DELETE
book, loan # tables
to
delete
from
FROM book, loan # tables to use in WHERE clause
WHERE book.book_id = loan.book_id
AND book.cond = ' poor ' ;
FROM book, loan # tables to use in WHERE clause
WHERE book.book_id = loan.book_id
AND book.cond = ' poor ' ;