Insert into message_m (site_cd,msg_seq_no,message,message_yobi,reg_day,trans_time,trans_kbn,trans_yobi1,trans_yobi2)
values('01',select max(msg_seq_no) from message_m,'3213','1','2005/01/01','1','1','1','1')格式不正.错在那里.我知道.但是求....求这个语句的正确写法? 谢谢.
values('01',select max(msg_seq_no) from message_m,'3213','1','2005/01/01','1','1','1','1')格式不正.错在那里.我知道.但是求....求这个语句的正确写法? 谢谢.
select ('01',select max(msg_seq_no),'3213','1','2005/01/01','1','1','1','1')
from message_m
Insert into message_m (site_cd,msg_seq_no,message,message_yobi,reg_day,trans_time,trans_kbn,trans_yobi1,trans_yobi2)
select ('01',这里出错 select max(msg_seq_no),'3213','1','2005/01/01','1','1','1','1')
from message_m
再请教
reg_day字段是date的话,还要to_date()一下
Insert into message_m (site_cd,msg_seq_no,message,message_yobi,reg_day,trans_time,trans_kbn,trans_yobi1,trans_yobi2)
values('01',select max(msg_seq_no) from message_m,'3213','1','2005/01/01','1','1','1','1') 把select max(msg_seq_no) from message_m 换成 '88' ..插入成功
select ('01',max(msg_seq_no),'3213','1','2005/01/01','1','1','1','1')
from message_m手误,不好意思……
Insert into message_m (site_cd,msg_seq_no,message,message_yobi,reg_day,trans_time,trans_kbn,trans_yobi1,trans_yobi2)
select ('01'这里出错,max(msg_seq_no),'3213','1','2005/01/01','1','1','1','1')
from message_m
再请
select '01'这里出错,max(msg_seq_no),'3213','1','2005/01/01','1','1','1','1'
from message_m…………不知道说什么了,以后要早睡觉@_@