This is ideal for testing queries etc. Run this to copy a selection of data into a new table with the same scructure. Then you can run test queries etc on it. Once you are happy then run the queries on the live data table...enjoy
- CREATE TABLE NEW_TABLE_NAME SELECT * FROM EXISTING_TABLE WHERE SOME_VAILD_WHERE_CLAUSE
You need to login to post a comment.