Hello Samuel, Many thanks for your quick and useful response. It has done the trick!!!. Thanks again, Cyp. ----- ----- Original Message ---- From: samuel &lt;samu60(a)gmail.com&gt; To: Cyprian Clement &lt;cyprian_clement(a)yahoo.co.uk&gt; Cc: serusers(a)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(a)yahoo.co.uk&gt;gt;: 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(a)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