[Serusers] SER's MySql Tables display
Cyprian Clement
cyprian_clement at yahoo.co.uk
Thu Jun 7 10:29:37 CEST 2007
Hello Samuel,
Many thanks for your quick and useful response. It has done the trick!!!.
Thanks again,
Cyp.
-----
----- Original Message ----
From: samuel <samu60 at gmail.com>
To: Cyprian Clement <cyprian_clement at yahoo.co.uk>
Cc: serusers at lists.iptel.org
Sent: Thursday, 7 June, 2007 8:45:06 AM
Subject: Re: [Serusers] SER's MySql Tables display
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.
_______________________________________________
Serusers mailing list
Serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
___________________________________________________________
New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes.
http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20070607/ee1e2811/attachment.htm>
More information about the sr-users
mailing list