↓返回底部
JS PHP HTML5 CSS3 jQuery SQL BootStrap5 Other
其他

UNION ALL 合并创建同结构表

<meta charset="utf-8">
CREATE TABLE table 

SELECT * FROM table11 

UNION ALL SELECT * FROM table12
UNION ALL SELECT * FROM table13
UNION ALL SELECT * FROM table14
UNION ALL SELECT * FROM table15

UNION ALL SELECT * FROM table21
UNION ALL SELECT * FROM table22
UNION ALL SELECT * FROM table23

UNION ALL SELECT * FROM table31
UNION ALL SELECT * FROM table32
UNION ALL SELECT * FROM table33
UNION ALL SELECT * FROM table34
UNION ALL SELECT * FROM table35
UNION ALL SELECT * FROM table36
UNION ALL SELECT * FROM table37

UNION ALL SELECT * FROM table41
UNION ALL SELECT * FROM table42
UNION ALL SELECT * FROM table43
UNION ALL SELECT * FROM table44
UNION ALL SELECT * FROM table45
UNION ALL SELECT * FROM table46

UNION ALL SELECT * FROM table50
UNION ALL SELECT * FROM table51
UNION ALL SELECT * FROM table52
UNION ALL SELECT * FROM table53
UNION ALL SELECT * FROM table54

UNION ALL SELECT * FROM table61
UNION ALL SELECT * FROM table62
UNION ALL SELECT * FROM table63
UNION ALL SELECT * FROM table64
UNION ALL SELECT * FROM table65

定义和用法

语法

参数值

返回值

  • Server Sent | 在线编辑 | 1.php |
  • 欢迎纠错:如果发现错误,请发到我的QQ:3166692976,感谢!
  • 本站及其内容仅作为站长本人学习探索之用途,不保证(包括但不限于)内容的准确性、有效性。本站保留解释权。
  • 心不得满,事不得全。鸟飞不尽,话说不完。休息一下吧!
  • 1500km.com,   Copyright ©2022,   all rights received.
  • ↑返回顶部