Forum Moderators: open

Message Too Old, No Replies

How to select table field names

         

asantos

5:32 pm on Dec 18, 2007 (gmt 0)

10+ Year Member



How can i select the fieldnames from a table in a sql sentence?

lets suppose we have this table:
id_user
user
password
name
lastname

... i need the sentence to return: id_user, user, password, name, lastname.

asantos

5:47 pm on Dec 18, 2007 (gmt 0)

10+ Year Member



nevermind. here is the solution:

SHOW COLUMNS FROM usuario