Populating table with text file

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

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:

2, staff

or just


(though I can't image that working).

Any help is appreciated.



Re: Populating table with text file

Ward B wrote:
Quoted text here. Click to load it

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).



Site Timeline