2005/9/1, Vladimir B. Tsarkov <bvbn@stripped>:
> I've heard that LIMIT is a MySQL specific, and cannot be used in any other
> DBMS. Is there any portable alternative to LIMIT? I'd like to create a
> portable PHP pager for a web site, but all the tutorials that I've found,
> contain solutions based on the LIMIT usage.
" For compatibility with PostgreSQL, MySQL also supports the LIMIT
row_count OFFSET offset syntax."
but if you want to be fully compatible with many others RDBMS, go for
something like adodb, or some others DB interface in PHP
> Good Luck!
> Please avoid sending me Word or PowerPoint attachments.
> See http://www.gnu.org/philosophy/no-word-attachments.html
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
Webzine Rock : http://www.w-fenec.org/