[Serusers] SER's MySql Tables display

[Cyprian Clement]

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>