how to write SQL table data to a SQL backup table code example

Example: backup a table in sql

CREATE TABLE backup_table SELECT * FROM table_to_be_backed_up;