On Fri, Oct 22, 2004 at 03:27:28PM +0800, Rafael 'Dido' Sevilla wrote: > First thing I noticed is that Oracle doesn't support the LIMIT clause > for some reason.
It could be because LIMIT is not defined in the SQL standard. > Another thing that tripped me up while doing this conversion was the > auto incrementing indexes and the NOW() function that MySQL developers > take for granted. All of these had to be done on the client side, which > was particularly painful in the latter case. There's more to it than that. I've also done such conversion in the past -- not with Oracle but with PostgreSQL. A page about MySQL gotchas[1] has served me well. [1] http://sql-info.de/mysql/gotchas.html -- $_=q:; # SHERWIN # 70;72;69;6e;74;20; 27;4a;75;73;74;20; 61;6e;6f;74;68;65; 72;20;50;65;72;6c; 20;6e;6f;76;69;63; 65;27;:;;s=~?(..); ?=pack q$C$,hex$1; ;;;=egg;;;;eval;;; -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
