Mysql – Is it possible for a MySQL database to have duplicate tables with the same name

MySQL

As in the question title – is it possible for a MySQL database to have duplicate tables with the same name? Is there a directive that can be used for a database to allow this?

Normally, when trying to add duplicate tables, MySQL should return an error #1050 - Table 'tablename' already exists, but recently, while working on a project, I noticed that almost every table in the database is duplicated (only the structure, new tables are empty). While I know that some table-creating scripts could be executed, MySQL shouldn't allow this, right?

How to even deal with such an issue? The program causing this is a Magento – a PHP-based eCommerce platform.

enter image description here

There are parts of a dump from this database:

--
-- Table structure for table `adminnotification_inbox`
--

CREATE TABLE IF NOT EXISTS `adminnotification_inbox` (
  `notification_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Notification id',
  `severity` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Problem type',
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Create date',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `description` text COMMENT 'Description',
  `url` varchar(255) DEFAULT NULL COMMENT 'Url',
  `is_read` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag if notification read',
  `is_remove` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag if notification might be removed',
  PRIMARY KEY (`notification_id`),
  KEY `IDX_ADMINNOTIFICATION_INBOX_SEVERITY` (`severity`),
  KEY `IDX_ADMINNOTIFICATION_INBOX_IS_READ` (`is_read`),
  KEY `IDX_ADMINNOTIFICATION_INBOX_IS_REMOVE` (`is_remove`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Adminnotification Inbox' AUTO_INCREMENT=26 ;

--
-- Dumping data for table `adminnotification_inbox`
--
-- there was some data from this table, not relevant here

-- --------------------------------------------------------

--
-- Table structure for table `
                adminnotification_inbox`
--
-- in use(#1146 - Table 'dev_testproject_1_12.
                adminnotification_inbox' doesn't exist)
-- in use (#1146 - Table 'dev_testproject_1_12.
                adminnotification_inbox' doesn't exist)

-- --------------------------------------------------------

I don't think this dump would even run without errors.

Best Answer

Make sure that the table name has no whitespaces that are not displayed in HTML.