mysql批量添加查询数据库语句

INSERT INTO 表名 (列1, 列2, 列3) VALUES
  (值1, 值2, 值3),
  (值4, 值5, 值6),
  ...

INSERT INTO users (name, age, email) VALUES
  ('Alice', 25, 'alice@example.com'),
  ('Bob', 30, 'bob@example.com'),
  ('Charlie', 35, 'charlie@example.com');

LOAD DATA INFILE '文件路径' INTO TABLE 表名
  [FIELDS
    [TERMINATED BY '分隔符']
    [ENCLOSED BY '包围符']
    [ESCAPED BY '转义符']
  ]
  [LINES
    [STARTING BY '前缀']
    [TERMINATED BY '行结束符']
  ]

LOAD DATA INFILE 'data.txt' INTO TABLE users
  FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

SELECT 列1, 列2, ... FROM 表名 WHERE 列 IN (值1, 值2, ...);

SELECT name, age FROM users WHERE id IN (1, 2, 3);

SELECT 列1, 列2, ... FROM 表名1 WHERE 条件1
UNION ALL
SELECT 列1, 列2, ... FROM 表名2 WHERE 条件2
...

SELECT name, age FROM users WHERE age < 30
UNION ALL
SELECT name, age FROM users WHERE name LIKE 'A%';