Hi All,
I need to import about 30,000 data records from a text file into a MySQL
database table, thru the LOAD DATA feature. The table in question will have a
auto increment column, plus 5 other columns. Should I include a field in the
text file to insert a value into the auto increment column, or if I leave that
out, inserting into the other 4 columns, will all the data being insert properly
and increment correctly?
Text file:
user|pass|email|fname|lname|birth
Table:
mem_id auto increment
user
pass
email
fname
lname
birth
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
---------------------------------------------------------------------
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
