Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Populating table with text file
August 6, 2005, 8:18 pm
rate this thread
I'm somewhat new to this whole MySQL/PHP thing and need a little help.
My web hosting service uses phpMyAdmin and at the bottom of the screen
iis an area where I can upload a text file to populate a table.
I have a table named groups with two fields:
groups_id auto-increment primary
So how do I create my text file to populate this table?
I'm going to use MS Notepad.
If it's set to auto-increment, do I need to include the number? If
so, does it start at 0 (zero)?
Would the file look like:
(though I can't image that working).
Any help is appreciated.
Re: Populating table with text file
Why are you asking the same question three times in a row?
Anyway, I believe PHPMyAdmin contains an upload option where you can
specifiy things like fields, field seperators etcetera. Auto-incrementing
fields do not require value assignment (often even not recommended).
- » Populating MySQL table with text file using myPHPadmin
- — Previous thread in » PHP Scripting Forum