Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Incomplete
-
5.5.47
-
Ubuntu 14.04.1
Description
I Want to create table family Using this command :
CREATE TABLE `FAMILY` ( `FAMILY_ID` bigint(20) NOT NULL, `PERSON_ID` bigint(20) DEFAULT NULL, `CREATED_BY` varchar(45) DEFAULT NULL, `LAST_UPDATED_BY` varchar(45) DEFAULT NULL, `LAST_UPDATED_DT` datetime DEFAULT NULL, `STATUS` varchar(45) DEFAULT NULL, PRIMARY KEY (`FAMILY_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
I got the result :
ERROR 1050 (42S01): Table '`bfm`.`FAMILY`' already exists
After That I run desc command :
> desc FAMILY;
I got result :
ERROR 1146 (42S02): Table 'bfm.FAMILY' doesn't exist
I use show tables command and got family table doesn't exist.
* But I am not able to create family table .*