怎么把查询的某一行的几个字段值附给不同的变量呢?
SELECT FchkMYS1 INTO $FchkMYS1,FchkMYS2 INTO $FchkMYS2,FchkMYS3 INTO $FchkMYS3,FchkMYS4 INTO $FchkMYS4,FchkMYS5 INTO $FchkMYS5
FROM t_BOSCombinedTask
WHERE FBillNO=$T_FWorkNo;
这个老报错,不知道该怎么写?
SELECT FchkMYS1 INTO $FchkMYS1,FchkMYS2 INTO $FchkMYS2,FchkMYS3 INTO $FchkMYS3,FchkMYS4 INTO $FchkMYS4,FchkMYS5 INTO $FchkMYS5
FROM t_BOSCombinedTask
WHERE FBillNO=$T_FWorkNo;
这个老报错,不知道该怎么写?
FROM t_BOSCombinedTask
WHERE FBillNO=$T_FWorkNo;这个你自己可以改啊!!!这是mySQL的语法规定,没什么理由。
SELECT FchkMYS1 INTO $FchkMYS1,FchkMYS2 INTO $FchkMYS2,FchkMYS3 INTO $FchkMYS3,FchkMYS4 INTO $FchkMYS4,FchkMYS5 INTO $FchkMYS5
FROM t_BOSCombinedTask
WHERE FBillNO=$T_FWorkNo;
SELECT FchkMYS1 INTO $FchkMYS1 FROM t_BOSCombinedTask
WHERE FBillNO=$T_FWorkNo;
为什么SELECT给多个变量同时赋值不行呢,不会得一个一个的赋值吧,MYSQL语句也太笨了
select bh,xm into @ee,@ff from tt where ...