[thelist] Increment every value in table (MySQL)

r937 rudy at r937.com
Tue Jan 6 13:36:47 CST 2009

> Basically This query will give you the column names:
> SELECT name FROM syscolumns
> WHERE id = (SELECT id FROM sysobjects
> WHERE name= '<TableName>')
> ORDER by colorder;

wrong DBMS  ;o)

http://r937.com/ | http://rudy.ca/
pre-order my book "Simply SQL" from Amazon --

More information about the thelist mailing list