MySQL의 데이터 작업 소개(코드 예제)

INSERT INTO info1 VALUES(1,'爱因斯坦','相对论')

INSERT INTO info1(id,name) VALUES(2,'爱迪生')

INSERT INTO info1 VALUES(3,'图灵','人工智能'),(4,'达芬奇','美学'),(5,'尼采','美学');

SELECT * FROM info1 WHERE id=2;

DELETE FROM info1 WHERE name='小泽玛利亚';

DELETE FROM info1;

TRUNCATE info1;

UPDATE info1 SET contribution='哲学、美学' WHERE id=5;

UPDATE info1 SET named='达·芬奇',contribution='艺术家、发明家、医学家' WHERE id=4;