MySQL Forums :: Newbie :: How do I change this table to get it to load


Advanced Search

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 Jason Breithaupt 03/02/2009 08:44AM
Re: How do I change this table to get it to load Lee Wood 03/02/2009 10:55AM
Re: How do I change this table to get it to load steve persipidus 03/02/2009 01:19PM
Re: How do I change this table to get it to load Alvaro Nuñez 03/02/2009 01:26PM
Re: How do I change this table to get it to load Guelphdad Lake 03/02/2009 03:26PM


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.