CREATE TABLE books(id Integer PRIMARY KEY, title VARCHAR(100),autor VARCHAR(60));
INSERT INTO books(id, title, author) VALUES(1,'War and Peace','Leo Tolstoy'),(3, 'Crime and Punishment','Fyodor Dostoyevsky');
delete from books where id=3;
UPDATE books SET Author='Lev Nikolayevich Tolstoy' WHERE Id=1;
SQL CRUD撸一遍
最新推荐文章于 2024-04-19 02:15:06 发布