sql - missing or invalid option , in creating table due to if not exists

Question

i have tried to create a table using if not exists using mysql in sql plus, but i got error

SQL> CREATE TABLE IF NOT EXISTS tasks (
  2  todo_id int auto_increment,
  3  task_id int);
CREATE TABLE IF NOT EXISTS tasks (
            *

ERROR at line 1: ORA-00922: missing or invalid option

Answer 1

You message indicates that you are using Oracles SQL PLUSand not mysql.,

so use

CREATE TABLE tasks (
        todo_id NUMBER  GENERATED BY DEFAULT ON NULL AS IDENTITY,
            task_id NUMBER(5)
      );

Please check the manual, for more information