However I wrote php code at the old host to echo SQL command to fill up the table.
Something like this:
Code: Select all
INSERT INTO table (blah, blah2, blah3)
VALUES ('1', '1', '2007-01-02 09:00:00')
INSERT INTO table (blah, blah2, blah3)
VALUES ('2', '2', '2007-01-03 09:00:00')
....Obviously I'd rather avoid doing it that way.
How is it possible to do it in SQL?
Thanks.