Question: Why is this line wrong on mysql trying to creat table for my student database create table Student (ID number, Name VARCHAR(20), Age number, Section
Why is this line wrong on mysql trying to creat table for my student database
create table Student (ID number, Name VARCHAR(20), Age number, Section CHAR(5), City VARCHAR(20), Primary key(ID));
ERROR 1064 (42000): 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 ''number', Name varchar(20), Age 'number', Section (5), City varchar(20), Primary' at line 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
