Re: Reading a table without knowing column names

2003-09-24 Thread Paul DuBois
At 19:33 +0200 9/24/03, Philippe MAIRE wrote: Hi I would like to execute a select on a table for which i don't know the column names. IE I would like a command like select column(1) from table where ... Sure, if I ask, it is because I cannot use the desc command. You can use SELECT but you cannot u

Re: Reading a table without knowing column names

2003-09-24 Thread Director General: NEFACOMP
I think by issuing a SELECT * FROM tblTableName will execute your query without knowing the column names. But you can also issue a SHOW FIELDS FROM tblTableName to get a list of the table columns. Hope this helps, Thanks Emery - Original Message - From: "Philippe MAIRE" <[EMAIL PROTECTED]