I'm trying to automate transfering data from a non-SQL database to MySQL. The text file containing the data has the following format:
TRUNCATE TABLE 'products';
INSERT INTO 'products' VALUES (1,2,'Some Product',9.95);
Using phpMyAdmin 2.6.0, the "Choose File" works nicely every time to import 7600 data records into MySQL 3.23.56.
But file_get_contents() in a PHP script produces "SQL systax errors" with the same text file.
Can someone suggest a PHP / SQL approach that will import cleanly?
Automate Data Import
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users