Posted by Kristofer on 08/10/05 18:50

Ward B wrote:

[ snip ]

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

Assuming you are using the link "Insert data from a text file into the
table" from the SQL window, you can either do it either way.

By default it will expect both columns (in your first example).

Alternatively, you can put "groups_name" into the "Column names" field,
and feed it your second example. That way it will only expect you to
provide the groups_name column, and it will auto-increment the first
column for you.

Kristofer

[Back to original message]