Duplicate sql table

hello I would like to launch a request in a tag to make a backup copy of my SQL table
the SQL command works but I cannot integrate it into a script
“select * INTO TABLE1 FROM TABLE2”

I tried this but it doesn’t work
system.db.runPrepUpdate( “SELECT * INTO TABLE1 FROM TABLE2”)

Tag scripts run the gateway scope, so you will need to specify the database connection.

Also, since this doesn’t appear to be parametrized, you may be able to get away with using system.db.runUpdateQuery()