mysql 选择插入数据(包含不存在列)具体实现_MySQL
- WBOYOriginal
- 2016-06-01 13:25:221085browse
bitsCN.com
mysql> select 'name',id from table_b; //'name' 不在table_b表中
+------+-----------+
| name | id |
+------+-----------+
| name | 123456 |
| name | 1234567 |
| name | 12345678 |
| name | 123456789 |
+------+-----------+
4 rows in set (0.00 sec)
mysql> insert into table_a(name,b_refer) select 'name', id from table_b; //'name' 不在table_b表中
Query OK, 4 rows affected (0.03 sec)
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql 不等于 符号写法_MySQLNext article：MySQL中select语句介绍及使用示例_MySQL