MySQL数据更新操作的两种办法(数据可视化工具和SQL语句)

CREATE TABLE thboPRIMARY KEY,
name VARCHAR(30)  ,
author VARCHAR(10),
publish VARCHAR(20),
price DECIMAL(6,2)
)
INSERT INTO thbook
    SELECT * FROM Book WHERE publish='清华大学出版社'

INSERT INTO Student(stu_ID,name,sex,birthdate)
VALUES('021B310001','张冬','男','1999-11-26')

INSERT INTO Student
VALUES('021B310001','张冬','男','1999-11-26')

INSERT INTO Student(stu_ID,name,sex)
       VALUES('021B310002','张三','女')
  或者：
INSERT INTO Student
       VALUES('021B310002','张三','女',NULL)

DELETE FROM Book

DELETE FROM Book WHERE price>100

DELETE FROM Borrow WHERE Reader_id IN
(SELECT Reader_id FROM Reader WHERE name='王旭')

UPDATE Book SET price = price*0.8

UPDATE Book SET price = price*1.15 WHERE public='清华大学出版社'

update reader set birthdate='1995-3-2' 
where name='王旭'

update Reader set name='宋玮凌',sex='男'
where Reader_ID='021B310005'

UPDATE Borrow SET Borrowdate= '2022-5-1'
WHERE reader_ID IN (SELECT reader_ID FROM Reader WHERE name= '王旭')

UPDATE Borrow SET Borrowdate= '2022-5-1'
FROM Borrow JOIN Reader ON Borrow.reader_ID = Reader.reader_ID 
WHERE name= '王旭'

UPDATE Borrow SET Borrowdate= '2022-6-8'
    WHERE reader_ID IN 
(SELECT reader_ID FROM Reader
    WHERE name= '张三')
and book_ID IN 
(SELECT book_ID FROM book
    WHERE name= '高等数学')