Curtis Maurand wrote:
>
> How about:
>
> UserID SMALLINT UNSIGNED AUTO_INCREMENT NULL PRIMARY KEY DEFAULT 1000
>
> Curtis
>
Good suggestion. But it too returns 1..7 when I do a 'select userid from
respondents'.
> 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
