SQL question
Posted: Tue Feb 13, 2007 7:23 am
I'd like to move the content of one table in my database to another. The other database is already set up however the domain is still being transferred. Because I don't have dedicated IP I can't use php code rewrite the table.
However I wrote php code at the old host to echo SQL command to fill up the table.
Something like this:
The problem is I wanted copy and paste the commands into SQL (phpMyAdmin), but it will only take them one at a time.
Obviously I'd rather avoid doing it that way.
How is it possible to do it in SQL?
Thanks.
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.