I have been trying to add another column to a table in my database using MySQL Workbench. This generates an 'ALTER TABLE' command which then fails as it fails attempting a 'CREATE TABLE, which it should not be doing as the table already exists! The output is below:-
ERROR 1114: The table 'Analysis' is full SQL Statement: ALTER TABLE `Patient`.`Analysis` ADD COLUMN `TestDateTime` DATETIME NULL AFTER `idResults` ERROR: Error when running failback script. Details follow. ERROR 1050: Table 'Patient' already exists SQL Statement: CREATE TABLE `Patient` ( `idAnalysis` int(11) NOT NULL, `idResults` int(11) DEFAULT NULL, `ResultPDF` mediumblob, `ResultCSV` mediumblob ) ENGINE=InnoDB DEFAULT CHARSET=latin1
How can I add this extra column as this database will evolve over time as user requirements expand?