mysql>DESC <tablename><br><br>so, in the mysql prompt, typing DESC user_preferences will return the table columns.<br><br>Samuel<br><br><div><span class="gmail_quote">2007/6/7, Cyprian Clement <<a href="mailto:cyprian_clement@yahoo.co.uk">
cyprian_clement@yahoo.co.uk</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;"> </div>
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;">Hi,</div>
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;"> </div>
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;">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.
</div>
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;"> </div>
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;">Does anyone know what command I can use to display columns of the empty table(say "usr_preferences" empty table) ?.</div>
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;"> </div>
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;">Thanks in advance.</div>
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;"> </div>
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;">Cyp.</div>
<div style="font-size: 12pt; font-family: times new roman,new york,times,serif;">---------</div></div><span class="ad"><br>
<hr size="1">
Yahoo! Answers - Get better answers from someone who knows. <a href="http://uk.answers.yahoo.com/;_ylc=X3oDMTEydmViNG02BF9TAzIxMTQ3MTcxOTAEc2VjA21haWwEc2xrA3RhZ2xpbmU" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
Try
it now</a>.</span></div><br>_______________________________________________<br>Serusers mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org
</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.iptel.org/mailman/listinfo/serusers" target="_blank">http://lists.iptel.org/mailman/listinfo/serusers</a><br><br></blockquote></div><br>