Hello Samuel,

Many thanks for your quick and useful response. It has done the trick!!!.

Thanks again,

Cyp. -----

----- Original Message ---- From: samuel samu60@gmail.com To: Cyprian Clement cyprian_clement@yahoo.co.uk Cc: serusers@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@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

___________________________________________________________ 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