linux另人忘了吃晚飯

1. SHOW CREATE TABLE alarm;
2. 找到像這樣CONSTRAINT `server_id_refs_id_34554433` FORIEGN KEY (`server_id`) REFERENCES `server` (`id`) line.
3. ALTER TABLE `alarm` DROP FOREIGN KEY `server_id_refs_id_34554433`;
4. ALTER TABLE `alarm` DROP `server_id`

       要新增的話

   ALTER TABLE alarm
   1. DROP FOREIGN KEY server_id_refs_id_34554433, 
   2.ADD CONSTRAINT FOREIGN KEY (galid) REFERENCES Girls (galid) 
   ON UPDATE CASCADE
   ON DELETE CASCADE;

首先先更新你的軟體管理工具

sudo apt-get update

在開始前:

    Step1: 確認你的hostname輸入