Hi

[Patricia May]

Hi

I am just about to import a txt file to mySQL and am wondering about
the automated numbers created in my Access database - I have created a
column 'etc_id' with mediumint as the type and I see that it begins
with 0.

Will the numbers created in Access populate this column? or am I going
about this the wrong way. Would appreciate someone explaining this
process to me as I cant find any specific info on this subject.

Puzzled

[Bill Karwin]

Re: Hi

Patricia May wrote:[color=blue]
> Will the numbers created in Access populate this column? or am I going
> about this the wrong way. Would appreciate someone explaining this
> process to me as I cant find any specific info on this subject.[/color]

MySQL has an optional column attribute called AUTO_INCREMENT. An
integer column with this specifier generates a new increasing value if
you provide no value, but if you do specify a value, that is the value
inserted.

See http://dev.mysql.com/doc/mysql/en/ex...INCREMENT.html

Regards,
Bill K.

[Patricia May]

Re: Hi

Hi Bill

Thanks

On Sat, 13 Nov 2004 23:37:08 -0800, Bill Karwin <bill@karwin.co m>
wrote:[color=blue]
>
>MySQL has an optional column attribute called AUTO_INCREMENT. An
>integer column with this specifier generates a new increasing value if
>you provide no value, but if you do specify a value, that is the value
>inserted.
>
>See http://dev.mysql.com/doc/mysql/en/ex...INCREMENT.html
>
>Regards,
>Bill K.[/color]