CODEWITHSUNDEEP
mysql-error-1064
Daniel Victor
Daniel Victor

Reputation: 1

Error MySQL #1064 at 1 Line

I need to create table for my sql database and i have a 1 error sucking my work, anyone can help me for i fix that error:

[sql]CREATE TABLE `z_ots_comunication` (
`id` int(0) NOT NULL DEFAULT 0
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
`param1` varchar(255) NOT NULL,
`param2` varchar(255) NOT NULL,
`param3` varchar(255) NOT NULL,
`param4` varchar(255) NOT NULL,
`param5` varchar(255) NOT NULL,
`param6` varchar(255) NOT NULL,
`param7` varchar(255) NOT NULL,
`delete_it` int(2) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Msg of MySQL:

1064 - 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 '[sql]CREATE TABLE z_ots_comunication ( id int(0) NOT NULL DEFAULT 0 name' at line 1

Upvotes: 0

Views: 191

Answers (2)

yuvraj d
yuvraj d

Reputation: 27

Try This code u have missed a semi colon before name filed

CREATE TABLE `z_ots_comunication` (
`id` int(0) NOT NULL DEFAULT 0,
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`action` varchar(255) NOT NULL,
`param1` varchar(255) NOT NULL,
`param2` varchar(255) NOT NULL,
`param3` varchar(255) NOT NULL,
`param4` varchar(255) NOT NULL,
`param5` varchar(255) NOT NULL,
`param6` varchar(255) NOT NULL,
`param7` varchar(255) NOT NULL,
`delete_it` int(2) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Upvotes: 0

Fatih BAKIR
Fatih BAKIR

Reputation: 4715

You forgot to put a comma after the ID column:

CREATE TABLE `z_ots_comunication` (
`id` int(0) NOT NULL DEFAULT 0,
`name` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
...

Upvotes: 1

Related Questions