What is wrong with my code? See area circled in red SQL Fiddle MySQL 5.6 Build Schema

What is wrong with my code?  See area circled in red

 

Transcribed Image Text:

SQL Fiddle MySQL 5.6 Build Schema View Sample Fiddle 1 Create Table employee ( 2 employee_id INTEGER NOT NULL, 3 first_name VARCHAR(30) NOT NULL, 4 last_name VARCHAR (30) NOT NULL, 5 hire_date DATE NOT NULL, 6 job_title VARCHAR(30) NOT NULL, 7 shop_id INTEGER NOT NULL, 8 PRIMARY KEY (employee_id) 9 FOREIGN KEY (shop_id) REFERENCES coffee shop (shop_id) 10 ); C Clear Edit Fullscreen" Browser > Text to DDL Run SQL Please build schema. Edit Fullscreen" [:] D [:] * You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY (shop_id) REFERENCES coffee_shop (shop_id) )' at line 9 SQL Fiddle MySQL 5.6 Build Schema View Sample Fiddle 1 Create Table employee ( 2 employee_id INTEGER NOT NULL, 3 first_name VARCHAR(30) NOT NULL, 4 last_name VARCHAR (30) NOT NULL, 5 hire_date DATE NOT NULL, 6 job_title VARCHAR(30) NOT NULL, 7 shop_id INTEGER NOT NULL, 8 PRIMARY KEY (employee_id) 9 FOREIGN KEY (shop_id) REFERENCES coffee shop (shop_id) 10 ); C Clear Edit Fullscreen" Browser > Text to DDL Run SQL Please build schema. Edit Fullscreen" [:] D [:] * You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY (shop_id) REFERENCES coffee_shop (shop_id) )' at line 9

Answer rating: 100% (QA)

The error that exists in the given create statement is that comma is missin... View the full answer