黑猴子的家：mysql 插入多行数据

1、查询表数据

SELECT * FROM beauty;

2、方式一：insert into...values

INSERT INTO beauty (id,NAME,phone,boyfriend_id) 
VALUES(106,'古力娜扎','119',1),(107,'范冰冰','112',1),(108,'吉克隽逸','888',1);

3、方式二：insert into...select

INSERT INTO beauty(NAME,phone)
SELECT '唐艺昕2','999' UNION
SELECT '李沁2','888' UNION
SELECT '董洁2','777'