mysql中的dual
#以下2条sql语句,效果一样
SELECT 666 FROM DUAL;
SELECT 666;
/*
在MySQL中,DUAL纯粹是为了满足select ... from...这一习惯
在mysql中,SELECT 666;和SELECT 666 FROM DUAL;效果一样,但
是在oracle中,SELECT 666;这样写会报错,所以必须加上FROM DUAL,必
须写成SELECT 666 FROM DUAL;
*/
#
SELECT '江西省赣州市于都县' FROM DUAL;
SELECT '江西省赣州市于都县';
#
SELECT 10 + 15 FROM DUAL;
SELECT 10 + 15;
SELECT 5 + 3 FROM DUAL WHERE 666 = 888;