mysql>DESC <tablename>
so, in the mysql prompt, typing DESC user_preferences will return the table columns.
Samuel
2007/6/7, Cyprian Clement cyprian_clement@yahoo.co.uk:
Hi,
With regard to the built in SER tables of the Mysql database, as most of them are empty(unless you insert rows) I would like to know first what columns are there already before I insert anything.
Does anyone know what command I can use to display columns of the empty table(say "usr_preferences" empty table) ?.
Thanks in advance.
Cyp.
Yahoo! Answers - Get better answers from someone who knows. Try it nowhttp://uk.answers.yahoo.com/;_ylc=X3oDMTEydmViNG02BF9TAzIxMTQ3MTcxOTAEc2VjA21haWwEc2xrA3RhZ2xpbmU .
Serusers mailing list Serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers