Skip navigation links

MySQL Forums :: Newbie :: Create table


Advanced Search

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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Options: ReplyQuote


Subject Written By Posted
Create table michael simpson 01/24/2006 07:10PM
Re: Create table Andrei Son 01/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.