sql - Error creating table in MySQL Workbench - Stack Overflow
to customize your list.
Join the Stack Overflow Community
Stack Overflow is a community of 6.4 million programmers, just like you, helping each other.
J it only takes a minute:
CREATE TABLE `sampledb`.`student` (
varchar sname(50),
varchar rno(13),
varchar year(10),
varchar sem(10),
varchar section(10),
varchar phone(12),
varchar pphone(12)
Error message:
there was an error while applying sql script to the database
157k70291366
closed as not a real question by , , , ,
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and
cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened,
.If this question can be reworded to fit the rules in the , please .
While you have given a datatype on the columns, you did not specify the length of the varchar and you have the order of the column names and length in the wrong spot.
The script should be:
CREATE TABLE `sampledb`.`student`
sname varchar(50) ,
rno varchar (13),
year varchar (10),
sem varchar (10),
section varchar(10),
phone varchar (12),
pphone varchar (12)
for reference
149k33203283
year is a reserved keyword. Change it to a different name or wrap it around with ticks (`)
157k70291366
You need to swap the datatype and column name:
CREATE TABLE `sampledb`.`student` (
sname varchar(50),
rno varchar(13),
year varchar(10),
sem varchar(10),
section varchar(10),
phone varchar(12),
pphone varchar(12)
Not the answer you're looking for?
Browse other questions tagged
Stack Overflow works best with JavaScript enabled