Writing to MySql DB from ascii file
Posted on 2007-11-14
I need the sql command for mysql (database info at end of question) for reading the contents of an ascii file and inserting them into a table. Below is the necessary information to write the query.
File name: c:\test\AD.asc
I could delimit the file ascii file to read using spaces or tabs if necessary.
The table to which I would like to add the contents of the file is called: 'datasetsSpecific'. Below I have outlined the table column names followed by their format and what it should be filled in with. In advance, thank you very much.
collectedDataID (INT) - FILLED IN WITH A ONE FOR EVERY ENTRY
period (DATETIME) - FILLED IN WITH THE FIRST TWO COLUMNS OF THE FILE CONCATENATED
open (decimal) - FILLED IN WITH COLUMN #3
flatTick (INT) - NOT FILLED IN
MySQL 5.0.45-community-nt via TCP/IP
MySQL Client Version 5.1.11