level 6
碎梦zdr
楼主
请教大神们一个问题,mysql中有哪个SQL MODE 可以使 位与 & 操作符可以像oracle中那样作为输入的提示符吗？或者mysql 哪个操作符可以作为输入的提示符呢(等效于oracle的 &)？
oracle中这样提示
SQL> select * from dual where rownum=#
Enter value for num: 1
mysql中却是报错
mysql> select * from payment where payment_id=&paymentid;
ERROR 1064 (42000): 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 '&paymentid' at line 1
2016年06月04日 08点06分
1
oracle中这样提示
SQL> select * from dual where rownum=#
Enter value for num: 1
mysql中却是报错
mysql> select * from payment where payment_id=&paymentid;
ERROR 1064 (42000): 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 '&paymentid' at line 1
