• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Solved Error in querys

Stewie

Family Guy # ;3
Joined
May 3, 2010
Messages
786
Reaction score
12
Location
TV
SQL:
CREATE TABLE `woe` (`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,`started` INT( 11 ) NOT NULL ,`guild` INT( 11 ) NOT NULL ,`breaker` INT( 11 ) NOT NULL ,`time` INT( 11 ) NOT NULL ,PRIMARY KEY ( `id` ) ,UNIQUE (`id`) ENGINE = MYISAM
CREATE TABLE `tmpwoe` (`started` INT( 11 ) NOT NULL ,`guild` INT( 11 ) NOT NULL ,`breaker` INT( 111 ) NOT NULL ,`time` INT( 1 ) NOT NULL) ENGINE = MYISAM ;
ALTER TABLE `tmpwoe` ADD `indexer` INT NOT NULL 
INSERT INTO `tmpwoe` (`started` ,`guild` ,`breaker` ,`time`, `indexer`)VALUES ('0', '0', '0', '0', '1');

error
Code:
#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 'ENGINE = MYISAM
CREATE TABLE `tmpwoe` (`started` INT( 11 ) NOT NULL ,`guild` IN' at line 1

someone can help me pls?
 
Last edited:
SQL:
CREATE TABLE `woe`
(
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`started` INT(11) NOT NULL,
	`guild` INT(11) NOT NULL,
	`breaker` INT(11) NOT NULL,
	`time` INT(11) NOT NULL,
	PRIMARY KEY (`id`), UNIQUE (`id`)
) ENGINE = InnoDB;

CREATE TABLE `tmpwoe`
(
	`started` INT(11) NOT NULL,
	`guild` INT(11) NOT NULL,
	`breaker` INT(11) NOT NULL,
	`time` INT(11) NOT NULL,
	`indexer` INT(11) NOT NULL
) ENGINE = InnoDB;

INSERT INTO `tmpwoe` VALUES (0, 0, 0, 0, 1);
 
Back
Top