[Serusers] SER's MySql Tables display

[samuel]

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 at 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<http://uk.answers.yahoo.com/;_ylc=X3oDMTEydmViNG02BF9TAzIxMTQ3MTcxOTAEc2VjA21haWwEc2xrA3RhZ2xpbmU>
> .
>
> _______________________________________________
> Serusers mailing list
> Serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20070607/4c2b34fb/attachment.htm>