Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Data Format

Quote Reply
Data Format
Hello,

We wish to know the Data format for LinksSQL, So that locally the data could be feeded and than uploaded.



------------------
Quote Reply
Re: Data Format In reply to
The format is anything MySQL can read.

Check out http://mysql.org/

Quote Reply
Re: Data Format In reply to
We wanted to know before uploding we wanted to create data locally offline than uplaod it directly to LINKS SQL, Not from the Admin panel ,as it is very combersome if you need to add number of entries.


------------------
Quote Reply
Re: Data Format In reply to
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.