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
August 10, 2011 07:20AM


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.