> 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