RESOLVED:
Hi - I'm building a new site and trying to test creating a database and getting this error. I went and created a new DB in the web GUI called test and am just trying to create one table as a test, but getting this error.
my script that I used to create a local DB that worked is as follows:
-- Table test
.what
CREATE TABLE IF NOT EXISTS test
.what
(
idwhat
INT NOT NULL AUTO_INCREMENT,
name
VARCHAR(45) NULL,
PRIMARY KEY (idwhat
))
ENGINE = InnoDB;
SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Any idea?