MySQL Forums
Forum List  »  Newbie

How do I change this table to get it to load
Posted by: Jason Breithaupt
Date: March 02, 2009 08:44AM

I am getting an error #1067 message when installing:

Table structure for table 'banneradmin'
#

CREATE TABLE banneradmin (
id int(11) DEFAULT '0' NOT NULL auto_increment,
adminuser varchar(15) NOT NULL,
adminpass varchar(15) NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id, adminuser)
);

INSERT INTO banneradmin (id, adminuser, adminpass) VALUES (1, 'admin',
'pass');


# --------------------------------------------------------

I am having trouble installing the above table. Unfortunately my whole
database is written like this. When I check on the server I get sent to
MYSQL Documentation for 5.0. Is there any way to fix this? Even if you
can point me to the correct place in the documentation I would
appreciate it very much.

Options: ReplyQuote


Subject
Written By
Posted
How do I change this table to get it to load
March 02, 2009 08:44AM


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.