56,687
社区成员
发帖
与我相关
我的任务
分享怎样把下面代码的结果写到一表中
下面语句给通过变量生成了个Num字段，怎样把可以把下面的结果写到另外的一个表，若在下面的select前加上insert into 表名，这样num列都为Null，请问怎样写就可以把num的值写到表中，谢谢！
SET @row_number = 0;
SELECT
(@row_number:=@row_number + 2) AS num, a.POID,a.VenderName
FROM
employee a
SET @row_number = 0;
SELECT
(@row_number:=@row_number + 2) AS num, a.POID,a.VenderName
FROM
employee a
...全文
请发表友善的回复…
发表回复
ChinaITOldMan 2019-04-01
- 打赏
- 举报
SET @row_number = 0;
create table tbname
SELECT * FROM (
SELECT
(@row_number:=@row_number + 2) AS num, a.POID,a.VenderName
FROM
employee a ) t ;
还可以上面那个用create table建立新表
AHUA1001 2019-03-20
- 打赏
- 举报
大致写一下哈，我加的这个括号，应该是关键。
SET @row_number = 0;
INSERT INTO TABLE_NAME(对应的字段名)
SELECT * FROM (
SELECT
(@row_number:=@row_number + 2) AS num, a.POID,a.VenderName
FROM
employee a ) t ;
SET @row_number = 0;
INSERT INTO TABLE_NAME(对应的字段名)
SELECT * FROM (
SELECT
(@row_number:=@row_number + 2) AS num, a.POID,a.VenderName
FROM
employee a ) t ;
