Where did you get Windows version? Did you compile it using SQLITE_ENABLE_UPDATE_DELETE_LIMIT?
From Compilation Options For SQLite<http://www.sqlite.org/compile.html#enable_update_delete_limit> : "*SQLITE_ENABLE_UPDATE_DELETE_LIMIT* This option enables an optional ORDER BY and LIMIT clause on UPDATE<http://www.sqlite.org/lang_update.html> and DELETE <http://www.sqlite.org/lang_delete.html> statements. If this option is defined, then it must also be defined when using the 'lemon' tool to generate a parse.c file. Because of this, this option may only be used when the library is built from source, not from the amalgamation <http://www.sqlite.org/amalgamation.html> or from the collection of pre-packaged C files provided for non-Unix like platforms on the website." Com os melhores cumprimentos, Luís Simão 2013/11/10 BULUSLI <quanwei9...@126.com> > hello Sir,I don't Know this isn't a bug > In my windows machine I used "update test set id=0 limit 0,1" and In my > linux machine use"update test set id=0 limit 0,1" answer is different. > In windows,he is tell me"Error: near "limit": syntax error" But in > linux is right! So this is aBug? (my mother tongue isn't English,so....) > > Version: > my Windows: SQLite 3.8.1 2013-10-17 12:57:35 > c78be6d786c19073b3a6730dfe3fb1be54f5657a > my Linux : SQLite 3.7.15.2 2013-01-09 11:53:05 > c0e09560d26f0a6456be9dd3447f5311eb4f238f > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users