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 now.

_______________________________________________
Serusers mailing list
Serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers