[分享]数据处理之增删改_软5_01

DESC stu_1;

SELECT * from stu_1;

INSERT INTO stu_1
VALUES (1,'许嵩',26,'2014-06-06');


INSERT INTO stu_1
VALUES (2,'徐良',18,'2012-07-07');

INSERT INTO stu_1
VALUES (3,'汪苏泷',NULL,NULL);

INSERT INTO stu_1(id)
VALUES (4);


SELECT * from stu_1;

INSERT INTO stu_1(id,age)
VALUES (5,17);

INSERT INTO stu_1(id,date)
VALUES (10,"2024-10-06");

INSERT INTO stu_1
VALUES (7,'哈利波特',24,'2022-06-12'),
(8,'刘能',22,'2023-06-12'),
(9,'楚雨荨',20,'2020-06-12');

SELECT * from stu_2;

DESC stu_2;

DESC stu_1;

INSERT INTO stu_1
SELECT * from stu_2
where stu_id = 66;

INSERT INTO stu_1(id,name)
SELECT stu_id,stu_name from stu_2
where stu_id = 67;

SELECT * from stu_1;

INSERT INTO stu_1
SELECT * from stu_2
where stu_id like '%8%';