MySQL Forums
Forum List  »  Russian

Ошибка SQL syntax error 1064
Posted by: Artem Zdorov
Date: November 09, 2009 12:40AM

Доброго всем времени суток,

при импорте базы у меня выпадает ошибка синтакса 1064. Помогите решить проблему.
Заранее спасибо.
Вот лог:
*******************
SQL query:

CREATE TABLE `jos_banner` (
`bid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`cid` int( 11 ) NOT NULL default '0',
`type` varchar( 10 ) NOT NULL default 'banner',
`name` varchar( 50 ) NOT NULL default '',
`imptotal` int( 11 ) NOT NULL default '0',
`impmade` int( 11 ) NOT NULL default '0',
`clicks` int( 11 ) NOT NULL default '0',
`imageurl` varchar( 100 ) NOT NULL default '',
`clickurl` varchar( 200 ) NOT NULL default '',
`date` datetime default NULL ,
`showBanner` tinyint( 1 ) NOT NULL default '0',
`checked_out` tinyint( 1 ) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar( 50 ) default NULL ,
`custombannercode` text,
PRIMARY KEY ( `bid` ) ,
KEY `viewbanner` ( `showBanner` )
) ENGINE = MYISAM AUTO_INCREMENT =3 DEFAULT CHARSET = latin1;

MySQL said: Documentation
#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 'DEFAULT CHARSET=latin1' at line 1

Options: ReplyQuote


Subject
Views
Written By
Posted
Ошибка SQL syntax error 1064
5863
November 09, 2009 12:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.