怎么把查询的某一行的几个字段值附给不同的变量呢?
SELECT FchkMYS1 INTO $FchkMYS1,FchkMYS2 INTO $FchkMYS2,FchkMYS3 INTO $FchkMYS3,FchkMYS4 INTO $FchkMYS4,FchkMYS5 INTO $FchkMYS5
FROM t_BOSCombinedTask
WHERE FBillNO=$T_FWorkNo;
这个老报错,不知道该怎么写?
...全文
187711打赏收藏
如何把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,FchkMYS2 INTO $FchkMYS2,FchkMYS3 INTO $FchkMYS3,FchkMYS4 INTO $FchkMYS4,FchkMYS5 INTO $FchkMYS5
FROM t_BOSCombinedTask
WHERE FBillNO=$T_FWorkNo;
SELECT FchkMYS1,FchkMYS2,FchkMYS3,FchkMYS4,FchkMYS5 INTO $FchkMYS1, $FchkMYS2, $FchkMYS3, $FchkMYS4, $FchkMYS5
FROM t_BOSCombinedTask
WHERE FBillNO=$T_FWorkNo;