SQL笔记（一）批量插入多条记录

/*
语法：INSERT INTO table
  (
  field1, field2
  )
VALUES
  ('field1_1', 'field2_1'),
  ('field1_2', 'field2_2'),
  ('field1_3', 'field2_3'),
  ('field1_4', 'field2_4'),
  ('field1_5', 'field2_5'),
  ('field1_6', 'field2_6');
*/
INSERT INTO user
  (
  name, pwd
  )
VALUES
  ('name1', 'pwd1'),
  ('name2', 'pwd2'),
  ('name3', 'pwd3'),
  ('name4', 'pwd4'),
  ('name5', 'pwd5'),
  ('name6', 'pwd6');