List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 13 2002 8:34pm
Subject:Re: AUTO_INCREMENT= ?
View as plain text  
At 15:23 -0400 5/13/02, Amer Neely wrote:
>  > 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.

Let's see a sample of the file.  Without that, we're just guessing.
mysql won't interpret INSERT statements differently in batch mode
than in interactive mode.
Thread
AUTO_INCREMENT= ?Amer Neely13 May
  • Re: AUTO_INCREMENT= ?Victoria Reznichenko13 May
Re: AUTO_INCREMENT= ?Amer Neely13 May
  • Re: AUTO_INCREMENT= ?Luciano Barcaro13 May
  • Re: AUTO_INCREMENT= ?Paul DuBois13 May
  • Re: AUTO_INCREMENT= ?Curtis Maurand13 May
  • Re: AUTO_INCREMENT= ?Amer Neely13 May
    • Re: AUTO_INCREMENT= ?Paul DuBois13 May
  • Re: AUTO_INCREMENT= ?Amer Neely13 May
  • Re: AUTO_INCREMENT= ?Amer Neely13 May
    • Re: AUTO_INCREMENT= ?Paul DuBois13 May
  • Re: AUTO_INCREMENT= ?Amer Neely13 May
    • Re: AUTO_INCREMENT= ?Paul DuBois13 May