Re: simple SQL question ?

If you want to know the structure of the table use

DESCRIBE sometable

Neil

Eric Chow <eric138_at_yahoo.com> wrote in message news:8cm3to$3o5$1_at_nnrp1.deja.com...
> Hi,
>
>
> "select * from sometable" will get all the contents of the table, right?
>
> But, if I want to show all the fields but only display one record, how ?
> The condition is that, I don't know the structure of that table.
>
> So, I have to use "select * from sometable". So, can I add some
> condition in it to only display one record with all the fields without
> knowing the table structure and the contents of the table ?
>
> Best regards,
> Eric
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Apr 10 2000 - 00:00:00 CDT