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. --------------------------------------------------------------------- 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