Populating table with text file

[Ward B]

Greetings.

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
groups_name

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:

0,students
1,faculty
2, staff

or just

students
faculty
staff

(though I can't image that working).

Any help is appreciated.

Thanks.

Ward

[Janwillem Borleffs]

Re: Populating table with text file

Ward B wrote:[color=blue]
> So how do I create my text file to populate this table?
>[/color]

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


JW