the connection froze, and any subsequent attempts to connect to this table were unsuccessful. I can't retrieve field structure, I can't drop the (obviously corrupted) table, I can't even drop the database. I tried to do the dropping from the command line, just to get the same result ...
DROP TABLE IF EXISTS `mydb`.`language` ; CREATE TABLE IF NOT EXISTS `mydb`.`language` ( `idlangues` TINYINT UNSIGNED NOT NULL , `Language_Name` VARCHAR(10) NOT NULL , PRIMARY KEY (`idlangues`) ) ENGINE = InnoDB; -- --- -- Table `mydb`.`Accomodation` -- --- DROP TABLE IF...
DROP TABLE IF EXISTS `test2`.`method` ; CREATE TABLE IF NOT EXISTS `test2`.`method` ( `MethodID` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT, `Abbr` CHAR(1) NOT NULL, `Desc` VARCHAR(45) NOT NULL, PRIMARY KEY (`MethodID`),
DROP TRIGGER IF EXISTS Sakila.Trigger_Before_An_ArgentineWines_update; CREATE TRIGGER Trigger_Before_An_ArgentineWines_update BEFORE UPDATE ON ArgentineWines FOR EACH ROW INSERT INTO ArgentineWines SET action = 'update', RankingId = OLD.RankingId, ...
-> PRIMARY KEY (id), -> FOREIGN KEY(`policyId`) REFERENCES policies (id) ON DELETE CASCADE, -> FOREIGN KEY(`compartmentId`) REFERENCES compartments (id) ON DELETE SET NULL, -> CHECK (`allowAnyGroup` IN (0, 1)) -> ); ERROR 1005 (HY000): Can't create table 'policy_stat...
PRIMARY KEY(id_s_user) )TYPE=InnoDB; DROP TABLE IF EXISTS skillset; CREATE TABLE skillset ( id_skillset INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, skillset_name VARCHAR(50) NOT NULL UNIQUE, PRIMARY KEY(id_skillset) )TYPE=InnoDB;
DROP TABLE IF EXISTS `silox`.`tbl_relate_feature` ; SHOW WARNINGS; CREATE TABLE IF NOT EXISTS `silox`.`tbl_relate_feature` ( `idtbl_relate_feature` INT NOT NULL , `feature_id` INT NULL , `product_id` INT NULL , PRIMARY KEY (`idtbl_relate_feature`) ) ...
DELIMITER $$ DROP PROCEDURE IF EXISTS `batteries`.`proc1` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `proc1`() BEGIN set @stmt = 'select run_name, t1, t2 from test_project'; prepare stmt from @stmt; execute stmt; END $$ ...
(45) NULL , `meter_count` INT NULL , `segment_length` INT NULL , `observation_id` INT NOT NULL , PRIMARY KEY (`segment_id`, `lion_id`, `side`, `observation_id`) , INDEX `lions-segments` (`lion_id` ASC, `side` ASC) , INDEX `obs_to_data` (`observation_id` ASC) , ...
Thanks. DROP TABLE IF EXISTS `4images_wordlist`; CREATE TABLE IF NOT EXISTS `4images_wordlist` ( `word_text` varchar(50) NOT NULL DEFAULT '', `word_id` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`word_id`), UNIQUE KEY `word_text` (`word_text`) ...