Home >Backend Development >PHP Tutorial >mysql一张表往另一张表导数据,其中新表有个字段是固定值,sql语句怎么写?

mysql一张表往另一张表导数据,其中新表有个字段是固定值,sql语句怎么写?

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-06 20:06:381500browse

mysql一张表往另一张表导数据,其中新表有个字段是固定值,sql语句怎么写?

回复内容:

mysql一张表往另一张表导数据,其中新表有个字段是固定值,sql语句怎么写?

insert into a select '定值' from b

insert into table_A(需要的字段)
select 需要的字段 from table_B

先导过去再执行update,非要一次搞定吗。思路啊。

1、固定值那2个字段设为默认值
2、先导过去,再update那2个固定值

3、mysql> select 5 as b; (嗯,还可以这样子的)
b
5

select a, b, c,"固定值" as d into table2 from table1

...ptkm

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