Bill_zhang5的博客

union 查询语法：SELECT column_name(s) FROM table_name1UNIONSELECT column_name(s) FROM table_name2union all查询语法：SELECT column_name(s) FROM table_name1UNION ALLSELECT column_name(s) FROM table_name2uni

1．表中插入一行数据：INSERT INTO table_name VALUES ('value1', 'value2',....)2．向表中插入多行：INSERT INTO table_name ('COLUMN1, 'COLUMN2',...) VALUES ('value1', 'value2',....),VALUES ('value1', 'value2',....