Search code examples
mysqlsqldatabasecreate-table

SQl - How can i create multiple copies of single table

I have a table name 'RealData' and i wanted an exact copy of this table so i just did

Create table RealData_long as select * from RealData

Which worked well as i expected. Now i need to create multiple copies of the same table RealData. How can i create multiple copies of the same table? is it possible to do any modification to the above query to achieve this?Or do i have to write a new query?

Solution

  • If you really mean to do what you're asking (no matter why and what for) - dynamic SQL may be the answer. Generate the query text, then execute it.