How about:

UserID SMALLINT UNSIGNED AUTO_INCREMENT NULL PRIMARY KEY DEFAULT 1000

Curtis



Amer Neely said:
>> Amer,
>> Monday, May 13, 2002, 2:03:28 AM, you wrote:
>>
>> AN> Win/98
>> AN> MySQL 3.23.46
>>
>> AN> I'm trying to use AUTO_INCREMENT=1000 to specify my staring value
>> in an AN> ID column in batch mode, but it doesn't want to work. I can
>> get it to AN> work in interactive mode though.
>>
>> AN> In a file (create_tables.sql) I have:
>>
>> AN> CREATE TABLE Respondents (UserID SMALLINT UNSIGNED AUTO_INCREMENT
>> NOT AN> NULL PRIMARY KEY,
>> AN>                           UserLastName VARCHAR(25) NOT NULL, AN>
>>                         UserFirstName VARCHAR(20) NOT NULL, AN>
>>                    UserEmail VARCHAR(60) NOT NULL,
>> AN>                           UserPhoneAC CHAR(3) NOT NULL,
>> AN>                           UserPhoneNum VARCHAR(8) NOT NULL,
>> AN>                           UserPhoneExt VARCHAR(5),
>> AN>                           UserLevel VARCHAR(20) NOT NULL,
>> AN>                           UserFoundBy VARCHAR(40) NOT NULL,
>> AN>                           KeyDM ENUM('Y','N') NOT NULL,
>> AN>                           DMPositionTitle VARCHAR(30) NOT NULL,
>> AN>                           IPAddr VARCHAR(15) NOT NULL,
>> AN>                           IPName VARCHAR(100))
>> AN>                           AUTO_INCREMENT=1000;
>>
>> AN> which I am then loading into mysql like this:
>>
>> AN> c:\mysql\data\mydb mysql mydb < create_tables.sql
>>
>> AN> No errors, but when I populate the table with values (also from a
>> file), AN> the values for UserID start at 1, not 1000.
>>
>> I guess that your UserID in the file begins from 1, not from 1000. You
>> can get values that are starting from 1000, if you insert into column
>> NULL or 0 or if you insert values from 1000 manually :)
>
> Yes, I understand that, but I'm trying to create the table and
> initialize UserID by redirecting a .sql file into mysql (batch mode). I
> don't want to insert a 'dummy' record starting at 1000, I want MySQL to
> do that, like it says in "MySQL" by Paul DuBois [p.94, chap.2.]. Again,
> this works in interactive mode, but NOT in batch mode. Can you or
> someone explain how this can be done in batch mode?
>
>> AN> The values I'm inserting for
>> AN> UserID are all 'null' (without quotes).
>>
>> How did you inserted values? Manually or from a file?
>
> As I indicated above, from a file.
> --
> /* All outgoing email scanned by Norton Antivirus 2002 */
> Amer Neely, Softouch Information Services
> W: www.softouch.on.ca
> E: [EMAIL PROTECTED]
> V: 519.438.5887
> Perl | PHP | MySQL | CGI programming for shopping carts, data entry
> forms.
> "We make web sites work!"
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to