If your table name is bar and it is in a database named foo, the following commands will show you the columns in that table:
describe foo.bar; -OR- show columns from foo.bar; If you try either command on a table that does not exist, you get an error message. Therefore, the query only returns the fields if the table exists. Is that what you wanted? That's how I understood your question.... Rhino ----- Original Message ----- From: "Luiz Rafael Culik Guimaraes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 18, 2004 10:35 AM Subject: query only that return the fields that an table existe > Dear Friends > > as subject. is this possible > if yes, how to get the field names returned > > Regards > Luiz > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.588 / Virus Database: 372 - Release Date: 13/2/2004 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]