SQL query error MyISAM

Question

enterdani 0 Newbie Poster

9 Years Ago

I know that myisam is no longer used by I don't know how to update the query.
I am trying to create tables with text in "Run SQL query in myphpadmin. Can anyone help?
This is the complete error I receive:
//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 'MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1' ;

CREATE TABLE Blog (
`' at line 6 //

CREATE TABLE `ACheck` (
  `AdminID` int(11) NOT NULL auto_increment,
  `EmailAddress` varchar(50) NOT NULL default '',
  `Password` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`AdminID`)
) MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1' ;


CREATE TABLE `Blog` (
  `BlogID` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '0',
  `Content` text NOT NULL,
  `Email` varchar(100) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`BlogID`)
) MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1' ;


CREATE TABLE `Box` (
  `BoxID` float NOT NULL auto_increment,
  `Name` varchar(100) NOT NULL default '',
  `Position` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`BoxID`)
) MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1' ;



CREATE TABLE `Category` (
  `CategoryID` float NOT NULL auto_increment,
  `Name` varchar(100) NOT NULL default '',
  `Code` tinyint(1) NOT NULL default '0',
  `Url` varchar(100) NOT NULL default '',
  `Subcode` float NOT NULL default '0',
  PRIMARY KEY  (`CategoryID`)
) MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1' ;



CREATE TABLE `Images` (
  `ImageID` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '',
  `Imagefile` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`ImageID`)
) MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1' ;



CREATE TABLE `Members` (
  `MemberID` float NOT NULL auto_increment,
  `FirstName` varchar(30) NOT NULL default '',
  `LastName` varchar(30) NOT NULL default '',
  `EmailAddress` varchar(100) NOT NULL default '',
  `Password` varchar(100) NOT NULL default '',
  `City` varchar(20) NOT NULL default '',
  `Country` varchar(20) NOT NULL default '',
  `IP` varchar(100) NOT NULL default '',
  `LogDate` varchar(10) NOT NULL default '',
  `News` tinyint(1) NOT NULL default '1',
  `Active` int(1) NOT NULL default '0',
  `ID` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`MemberID`)
) MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1' ;



CREATE TABLE `Metatags` (
  `TagID` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '',
  `Title` text NOT NULL,
  `Description` text NOT NULL,
  `Keywords` text NOT NULL,
  PRIMARY KEY  (`TagID`)
) MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10' ;

INSERT INTO `Metatags` VALUES(1, 'accountsubmit.php', '', '', '');
INSERT INTO `Metatags` VALUES(2, 'confirmaccount.php', '', '', '');
INSERT INTO `Metatags` VALUES(3, 'createaccount.php', '', '', '');
INSERT INTO `Metatags` VALUES(4, 'forgotpassword.php', '', '', '');
INSERT INTO `Metatags` VALUES(5, 'index.php', '', '', '');
INSERT INTO `Metatags` VALUES(6, 'logout.php', '', '', '');
INSERT INTO `Metatags` VALUES(7, 'memberinfo.php', '', '', '');
INSERT INTO `Metatags` VALUES(8, 'passwordconfirm.php', '', '', '');
INSERT INTO `Metatags` VALUES(9, 'searchresult.php', '', '', '');



CREATE TABLE `Products` (
  `ProductID` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '',
  `Category` varchar(100) NOT NULL default '',
  `ProductName` varchar(100) NOT NULL default '',
  `Image` varchar(200) NOT NULL default '',
  `Html` text NOT NULL,
  `Subcode` varchar(20) NOT NULL default '0',
  PRIMARY KEY  (`ProductID`)
) MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1' ;



CREATE TABLE `Settings` (
  `SettingsID` int(1) NOT NULL default '1',
  `Boxonoff` int(1) NOT NULL default '1',
  `Boxposition` int(1) NOT NULL default '0',
  `Boxcount` int(1) NOT NULL default '1',
  `Boxname` varchar(20) NOT NULL default 'Category',
  `Todayposition` int(1) NOT NULL default '1',
  `Todayonoff` int(1) NOT NULL default '1',
  `Todayname` varchar(20) NOT NULL default 'Today',
  `Mostonoff` int(1) NOT NULL default '1',
  `Mostposition` int(1) NOT NULL default '0',
  `Mostname` varchar(20) NOT NULL default 'Most Viewed',
  `Newonoff` int(1) NOT NULL default '1',
  `Newposition` int(1) NOT NULL default '0',
  `Newname` varchar(20) NOT NULL default 'Newly Added',
  `Memberonoff` int(1) NOT NULL default '1',
  `Memberposition` int(1) NOT NULL default '1',
  `Membername` varchar(20) NOT NULL default 'Member Login',
  `Searchonoff` int(1) NOT NULL default '0',
  `Searchname` varchar(100) NOT NULL default 'Search',
  `EmailAddress` varchar(100) NOT NULL default ''
) MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `Settings` VALUES(1, 1, 0, 1, 'Category', 1, 1, 'Today Box', 1, 1, 'Most Viewed', 1, 1, 'Newly Added', 1, 1, 'Member Module', 1, 'Search A Product', '');



CREATE TABLE `Static` (
  `StaticID` float NOT NULL auto_increment,
  `Name` varchar(100) NOT NULL default '',
  `Url` varchar(100) NOT NULL default '',
  `Html` text NOT NULL,
  `Boxname` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`StaticID`)
) MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10' ;

INSERT INTO `Static` VALUES(1, 'Account Submit', 'accountsubmit.php', '', 'System');
INSERT INTO `Static` VALUES(2, 'Confirm Account', 'confirmaccount.php', '', 'System');
INSERT INTO `Static` VALUES(3, 'Create Account', 'createaccount.php', '', 'System');
INSERT INTO `Static` VALUES(4, 'Forgot Password', 'forgotpassword.php', '', 'System');
INSERT INTO `Static` VALUES(5, 'Index', 'index.php', '', 'System');
INSERT INTO `Static` VALUES(6, 'Log Out', 'logout.php', '', 'System');
INSERT INTO `Static` VALUES(7, 'Member Info', 'memberinfo.php', '', 'System');
INSERT INTO `Static` VALUES(8, 'Password Confirm', 'passwordconfirm.php', '', 'System');
INSERT INTO `Static` VALUES(9, 'Search Result', 'searchresult.php', '', 'System');


CREATE TABLE `Template` (
  `TemplateID` int(11) NOT NULL default '0',
  `Main_Hex` varchar(20) NOT NULL,
  `Header_Hex` varchar(20) NOT NULL,
  `Item_Hex` varchar(20) NOT NULL,
  `Header_Font_Hex` varchar(20) NOT NULL,
  `Item_Font_Hex` varchar(20) NOT NULL
) MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `Template` VALUES(0, '#ffffff', '#6d9bf7', '#f0f0f0', '#ffffff', '#000000');


CREATE TABLE `Views` (
  `ViewID` float NOT NULL auto_increment,
  `Url` varchar(100) NOT NULL default '',
  `Number` float NOT NULL default '0',
  `Name` varchar(100) NOT NULL default '',
  `Type` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`ViewID`)
) MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10' ;

INSERT INTO `Views` VALUES(1, 'accountsubmit.php', 0, 'Account Submit', 'Page');
INSERT INTO `Views` VALUES(2, 'confirmaccount.php', 0, 'Confirm Account', 'Page');
INSERT INTO `Views` VALUES(3, 'createaccount.php', 0, 'Create Account', 'Page');
INSERT INTO `Views` VALUES(4, 'forgotpassword.php', 0, 'Forgot Password', 'Page');
INSERT INTO `Views` VALUES(5, 'index.php', 0, 'Index', 'Page');
INSERT INTO `Views` VALUES(6, 'logout.php', 0, 'Log Out', 'Page');
INSERT INTO `Views` VALUES(7, 'memberinfo.php', 0, 'Member Info', 'Page');
INSERT INTO `Views` VALUES(8, 'passwordconfirm.php', 0, 'Password Confirm', 'Page');
INSERT INTO `Views` VALUES(9, 'searchresult.php', 0, 'Search Result', 'Page');

php

2 Contributors
1 Reply
345 Views
11 Minutes Discussion Span
Latest Post 9 Years Ago Latest Post by iamthwee

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

iamthwee · Answer 1 · 2015-02-09T22:34:15+00:00

ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;