Re: I need the command line...
| From: | Jack Dempsey | Date: | Wed, 14 Mar 2001 06:18:25 +0000 |
| Subject: | Re: I need the command line... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-43777@lists.php.net to get a copy of this message | ||
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: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net