晨柚的部落格

CREATE TABLE IF NOT EXISTS `Professional_History` (
  `Month_Year` varchar(200) CHARACTER SET utf8 NOT NULL,
  `Title` varchar(1000) CHARACTER SET utf8 NOT NULL,
  `Department` varchar(100) CHARACTER SET utf8 NOT NULL,
  `Professional_History_Section` varchar(1000) CHARACTER SET utf8 NOT NULL,
  `Unit_name` varchar(100) CHARACTER SET utf8 NOT NULL,
  `Id` varchar(100) CHARACTER SET utf8 NOT NULL,
   PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `Professional_History` (`Month_Year`,`Title`,`Department`,`Professional_History_Section`,`Unit_name`,`Id`) VALUES
('2205', '區塊鍊','大學','業界','人事部', 'A112');

CREATE TABLE IF NOT EXISTS `Professional_Societies` (
  
  `Id` varchar(20) CHARACTER SET utf8 NOT NULL,
  `Professional_Societies_Year` varchar(200) CHARACTER SET utf8 NOT NULL,
  `Topic` varchar(1000) CHARACTER SET utf8 NOT NULL,
  `Description` varchar(100) CHARACTER SET utf8 NOT NULL,
  `Professor_Id` varchar(100) CHARACTER SET utf8 NOT NULL,
   PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ALTER TABLE `Professional_Societies` ADD CONSTRAINT `Professional_Societies_Fk` FOREIGN KEY (`Professor_Id`) REFERENCES `Professional_History` (`Id`);

INSERT INTO `Professional_Societies` (`Id`,`Professional_Societies_Year`,`Topic`,`Description`,`Professor_Id`) VALUES
('888248', '2085', '資料庫鍊','資料庫', 'A112');

ALTER TABLE `表格名稱` ADD CONSTRAINT `關聯名稱` FOREIGN KEY (`foreignKeyName`) REFERENCES `關聯資料表名稱` (`關聯資料表欄位`);
通常後面會加上 
ON DELETE  +類型
ON UPDATE  +類型 

如果沒加預設就是都是  RESTRICT
CASCADE      同樣動作執行更新或刪除
SET NULL     子表一起空值
NO ACTION    什麼都不做
RESTRICT     簡單來說如果子表 要匯入 就一定要有關聯的表先匯入  EX:一定要有ProfessorId