how to take backup of sql table with data code example

Example: backup a table in sql

CREATE TABLE backup_table SELECT * FROM table_to_be_backed_up;