create table mystery / misserry
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;
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.