Archive for April, 2015

Unusual: Mysql, partitioning

### Partitioning: mysql>ALTER TABLE `els_clipping_tester_err` ADD FOREIGN KEY (`clipping_id`) REFERENCES `inf_clipping3`(`CLIP_ID`) ON DELETE RESTRICT ON UPDATE RESTRICT; ERROR 1005 (HY000): Can’t create table ‘inforia.#sql-7f30_17f4dd0’ (errno: 150) Cannot resolve table name close to …. mysql>alter table clipping3 remove partitioing; mysql>ALTER TABLE `els_clipping_tester_err` ADD FOREIGN KEY (`clipping_id`) REFERENCES `inf_clipping3`(`CLIP_ID`) ON DELETE RESTRICT ON UPDATE RESTRICT; Query OK, […]

Read more...