回复 3# gggeeqg 我给的就是ULW的情形另外, 你如果想用exact mysql syntax, DB2也是可以做到的看例子[db2inst1@s1 ~]$ db2set DB2_COMPATIBILITY_VECTOR=mys[db2inst1@s1 ~]$ db2stop force09/29/2015 13:48:33 0 0 SQL1...
显示全部回复 3# gggeeqg 我给的就是ULW的情形
另外, 你如果想用exact mysql syntax, DB2也是可以做到的
看例子
[db2inst1@s1 ~]$ db2set DB2_COMPATIBILITY_VECTOR=mys
[db2inst1@s1 ~]$ db2stop force
09/29/2015 13:48:33 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
[db2inst1@s1 ~]$ db2start
09/29/2015 13:48:40 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[db2inst1@s1 ~]$ db2 connect to sample
Database Connection Information
Database server = DB2/LINUXX8664 10.5.5
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
[db2inst1@s1 ~]$ db2 "select empno from emp limit 10,2"
EMPNO
------
000130
000140
2 record(s) selected.
收起