Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9875

ERROR 1050 Table already exists

    XMLWordPrintable

    Details

      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 .*

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            anujdhiman anuj dhiman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: