Trying to create backup of SQL Table [duplicate]

Question

While creating a backup of a table, I am using the following Syntax -

CREATE TABLE new_table LIKE original_table;
INSERT new_table SELECT * FROM original_table;

But while executing the first Statement only, I am getting the folowing error:

SQL-Fehler: ORA-00922: Fehlende oder ungültige Option 00922. 00000 - "missing or invalid option"

I am new to SQL but this should be simple execution.

That's an Oracle error I don't know that mysql has this option — P.Salmon
– P.Salmon, Commented Mar 22, 2019 at 8:10

ScaisEdge · Accepted Answer · 2019-03-22 08:12:30Z

0

In oracle you should use CREATE AS select

CREATE TABLE new_table 
AS SELECT * FROM original_table

in mysql CREATE SELECT

CREATE TABLE new_table 
SELECT * FROM original_table

answered Mar 22, 2019 at 8:12

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1