<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><P> </P>
<P>Hello Samuel,</P>
<P> </P>
<P>Many thanks for your quick and useful response. It has done the trick!!!.</P>
<P> </P>
<P>Thanks again,</P>
<P> </P>
<P>Cyp.</P>
<P>-----</P>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: samuel <samu60@gmail.com><BR>To: Cyprian Clement <cyprian_clement@yahoo.co.uk><BR>Cc: serusers@lists.iptel.org<BR>Sent: Thursday, 7 June, 2007 8:45:06 AM<BR>Subject: Re: [Serusers] SER's MySql Tables display<BR><BR>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" target=_blank rel=nofollow> cyprian_clement@yahoo.co.uk</A>>:</SPAN>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<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 rel=nofollow>Try it now</A>.</SPAN></DIV><BR>_______________________________________________<BR>Serusers mailing list<BR><A href="mailto:Serusers@lists.iptel.org" target=_blank rel=nofollow>Serusers@lists.iptel.org </A><BR><A href="http://lists.iptel.org/mailman/listinfo/serusers" target=_blank rel=nofollow>http://lists.iptel.org/mailman/listinfo/serusers</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV><BR></DIV></div><br>
<hr size=1>
Web email has come of age. Don't settle for less than the <a href="http://us.rd.yahoo.com/mail/uk/taglines/gmail_com/nowyoucan/web_mail/*http://us.rd.yahoo.com/evt=40566/*http://uk.docs.yahoo.com/nowyoucan.html">All New Yahoo! Mail</a>.</body></html>