i'm guessing you want a create clause:
CREATE TABLE foo ( id INT PRIMARY KEY NOT NULL AUTO_INCREMENT, firstname
CHAR(20), age INT);
you'll want to tweak this to meet your needs, but it should do the
trick...
jack
Dhaval Desai wrote:
>
> Hi!
>
> CAn anybody give me the command line of Mysql for
> doing the following.
>
> I want to have three columns
>
> id
> firstname
> age
>
> the id field mu auto_inrement..meaning it should
> automatically goas 1.2.3.4.5.6 as someone inserts
> values into firstname and age.
>
> Thank You
> Dhaval Desai
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great prices.
> http://auctions.yahoo.com/
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
