Amer Neely wrote:
>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?
>
What you can do is the following:
After the Create table command, add :
Alter table Respondents auto_increment=1000;
>
>
>
>>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.
>
>
--
------------------------------------------------------
\|/ ______ \|/
`@" / o . \ "@' Microsoft? Por acaso � alguma nova
/___| \____/ |___\ marca de papel higi�nico?
\___U__/
.^. Luciano Barcaro - Linux User # 99517
/v\ Registre-se gratuitamente em
// \\ http://counter.li.org
//(.)\\ ICQ # 17266954
^`~'^
------------------------------------------------------
---------------------------------------------------------------------
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
