Skip navigation links

MySQL Forums :: Database Administration & Monitoring :: create table mystery / misserry


Advanced Search

create table mystery / misserry
Posted by: Pieter Huiberts ()
Date: August 10, 2011 07:20AM

I am trying to issue the following 2 statements, see below. Statement 1 fails where and Statement 2 is successful. The only difference I can see is the db.

Why would statement 1 fail?

s1 error: "Error Code: 1005. Can't create table 'rev_cdmrp.meetings' (errno: 121)"
Server: localhost (MySQL host info: localhost via TCP/IP)
Server version: 5.1.36-community-log
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)


-- statement1
drop table if exists rev_cdmrp.meetings;
create table rev_cdmrp.meetings (
t1 int(11) AUTO_INCREMENT NOT NULL
, t2 varchar(200) not null default 'ss'
,PRIMARY KEY(t1)
)ENGINE=InnoDB;

-- statement2
drop table if exists workArea.meetings;
create table workArea.meetings (
t1 int(11) AUTO_INCREMENT NOT NULL
, t2 varchar(200) not null default 'ss'
,PRIMARY KEY(t1)
)ENGINE=InnoDB;

Options: ReplyQuote


Subject Written By Posted
create table mystery / misserry Pieter Huiberts 08/10/2011 07:20AM
Re: create table mystery / misserry Pieter Huiberts 08/10/2011 07:22AM


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.