So that's the error I'm getting. According to what I observe, the SQL query created when I hit the remove button is incorrect, but I'm not sure how to fix it.
Could it be because I set lower case table names = 2 in the my.ini config file? This is the only modification I made to the my.ini file.
The table structure is as follows:
- Code: Select all
--
-- Table structure for table `Followups`
--
CREATE TABLE `Followups` (
`ID` int(10) UNSIGNED NOT NULL,
`ContactID` int(10) UNSIGNED NOT NULL,
`RMID` int(10) UNSIGNED NOT NULL,
`Number` tinyint(3) UNSIGNED NOT NULL,
`CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Indexes for table `Followups`
--
ALTER TABLE `Followups`
ADD PRIMARY KEY (`ID`);
--
-- AUTO_INCREMENT for table `Followups`
--
ALTER TABLE `Followups`
MODIFY `ID` int(12) UNSIGNED NOT NULL AUTO_INCREMENT;
Following this sample here https://www.scaler.com/topics/rename-table-name-in-sql/ , I attempted to construct a clone of the table using just lowercase characters in the table name, and I was able to remove records from that table. So, as I suspected, the problem is caused by the lower case table names parameter in the my.ini file. Any suggestions on what I should do next to remedy this issue without having to modify all of my table names?