7 Jun
2007
7 Jun
'07
10:45 a.m.
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(a)yahoo.co.uk>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<http://uk.answers.yahoo.com/;_ylc=X3oDMTEydmViNG02BF9TAzIxMTQ3MTcxOT…
.
_______________________________________________
Serusers mailing list
Serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers