Just as I said. Any format that MySQL can read is ok. There are several -- INSERT commands, Load from text, etc.
The format varies based on the above.
If you use the INSERT you need to list the field names, followed by the values
If you use the load from text, you list the field names in the first row (or not at all) and the fields are in the order they appear in the database.
This is _not_ a Links SQL feature, it's a MySQL feature. All links does is use the mysql features.
There are several threads on the INSERT and LOAD command, and importing data here. Check them out for more details, and the solutions people have had to the various problems.
The format varies based on the above.
If you use the INSERT you need to list the field names, followed by the values
If you use the load from text, you list the field names in the first row (or not at all) and the fields are in the order they appear in the database.
This is _not_ a Links SQL feature, it's a MySQL feature. All links does is use the mysql features.
There are several threads on the INSERT and LOAD command, and importing data here. Check them out for more details, and the solutions people have had to the various problems.
