overwrite table (mysql), please help

[themainman]

thanks

[r937]

instead of DROP TABLE (which you will do eventually), run this --

RENAME TABLE `name` TO backup_name

then run your script to create `name`

if you are happy with the results, then DROP TABLE backup_name

if anything goes wrong, you can DROP `name` and then RENAME backup_name back to `name`

[r937]

that looks okay except for the missing semicolon after the RENAME command

[r937]

no, it shouldn't

[r937]

themainman, that was quite uncool

you have just made the whole thread pointless

one of the reasons why people use a public forum (and why some of us feel it is worthwhile to give freely of our time and knowledge by posting answers on public forums) is so that others who come after us can learn

by deleting all your posts (and erasing the first one, which you cannot delete), you've made this thread useless to other people

it's not likely that i will be offering you any help in future