MySQL Forums
Forum List  »  Newbie

Create table
Posted by: michael simpson
Date: January 24, 2006 07:10PM

Hello. I'm using PHPMyAdmin to export a .sql file to upload to a server elsewhere. The export is fine without errors, but upon importing the .sql file I get an error:
"#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 AUTO_INCREMENT=1' at line 19".

I cannot see any syntax errors, but being a newbie maybe I'm missing something here.

Thanks in advance for any help.

Here's part of the code:

DROP TABLE IF EXISTS `mos_banner`;
CREATE TABLE `mos_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`)

Options: ReplyQuote

Written By
Create table
January 24, 2006 07:10PM
January 25, 2006 03:09AM

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.