sql-03テーブルレコードの操作
843 ワード
--
SELECT
*
FROM
tb_user;
--
INSERT INTO tb_user ( uid, uname, upassword )
VALUES
( NULL, ' ', '123456' );
--
INSERT INTO tb_user
VALUES
( NULL, ' ', '654321', NULL, '' );
-- ( , )
UPDATE tb_user
SET upassword = '666';
-- ( , )
UPDATE tb_user
SET upassword = '999'
WHERE
uname LIKE ' ';
-- ( , )
DELETE
FROM
tb_user;
-- ( , )
DELETE
FROM
tb_user
WHERE
uid = 1;
--
START TRANSACTION;
--
DELETE FROM tb_user;
-- ,
ROLLBACK;
-- ,uid , ( : , )
TRUNCATE tb_user;