Can somebody help with the errors in the code
I am unable to run it on netbeans.
CREATE TABLE users(
id int GENERATED ALWAYS AS IDENTITY ,
first_name varchar(20) DEFAULT NULL,
last_name varchar(20) DEFAULT NULL,
username varchar(250) DEFAULT NULL,
password varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE todos (
id bigint(20) GENERATED ALWAYS AS IDENTITY ,
description varchar(255) DEFAULT NULL,
is_done bit(1) NOT NULL,
target_date datetime(6) DEFAULT NULL,
username varchar(255) DEFAULT NULL,
title varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
I am getting the following errors :
[Exception, Error code 30,000, SQLState 42X01] Syntax error: Encountered "ENGINE" at line 8, column 2.
Line 8, column 2
[Exception, Error code 30,000, SQLState 42X01] Syntax error: Encountered "(" at line 2, column 10.
Line 11, column 10