insert into asdasd.ASDASDASDSAD
(
i_table_iid,
i_table_text,
i_table_way,
i_table_in1,
i_table_in2,
i_table_in3,
i_table_in4,
i_table_in5,
i_table_in6,
i_table_in7,
i_table_in8,
i_table_in9,
i_table_in10,
i_table_out1,
i_table_out2,
i_table_out3,
i_table_out4,
i_table_orderly,
i_table_time,
i_table_lasttime
)
select
p_10,
p_nr,
p_way,
CONCAT(p_1","p_1num),
CONCAT(p_2","p_2num),
p_3,
p_4,
p_5,
p_6,
p_7,
p_8,
p_9,
p_11,
concat_ws(',',p_10,p_num),
concat_ws(',',p_10_extra1,p_10_extra1_num),
concat_ws(',',p_10_extra2,p_10_extra2_num),
concat_ws(',',p_10_extra3,p_10_extra3_num),
p_xiangxing,
p_time,
p_lasttime
from ewrw.ASDASDASD
4 个解决方案
#1
使用 concat(p_p1,','p_1num) 可以连接
#2
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p_1num)
concat(p_2,','p_2num)
#3
使用 concat(p_p1,',',p_1num) 可以连接 不小心少了个逗号 !
#4
直接连接不行吗 比如 SELECT (A.ID + ',' + A.NAME) AS AAA
#1
使用 concat(p_p1,','p_1num) 可以连接
#2
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p_1num)
concat(p_2,','p_2num)
#3
使用 concat(p_p1,',',p_1num) 可以连接 不小心少了个逗号 !
#4
直接连接不行吗 比如 SELECT (A.ID + ',' + A.NAME) AS AAA