トップ＞ ｍｙｓｑｌ＞ mysql fk 外部キー　削除

mysql fk 外部キー　削除

mysql fk 外部キー　削除

 

mysql> show fields from cook;
+-------------+------------------+------+-----+---------------------+----------------+
| Field       | Type             | Null | Key | Default             | Extra          |
+-------------+------------------+------+-----+---------------------+----------------+
| cook_seq    | int(10) unsigned | NO   | PRI | NULL                | auto_increment |
| menu_seq    | int(10) unsigned | NO   | MUL |                     |                |
| name        | varchar(255)     | YES  |     | NULL                |                |
| price       | int(11)          | YES  |     | NULL                |                |
| selected    | int(11)          | YES  |     | 0                   |                |
| sort        | int(11)          | YES  |     | 999999              |                |
| setumei1    | varchar(255)     | YES  |     | NULL                |                |
| setumei2    | varchar(255)     | YES  |     | NULL                |                |
| image1      | varchar(255)     | YES  |     | NULL                |                |
| status      | varchar(1)       | NO   |     | 1                   |                |
| regist_date | timestamp        | NO   |     | CURRENT_TIMESTAMP   |                |
| update_date | timestamp        | NO   |     | 0000-00-00 00:00:00 |                |
+-------------+------------------+------+-----+---------------------+----------------+
12 rows in set (0.12 sec)

 

mysql> SHOW CREATE TABLE cook;

 

| cook  | CREATE TABLE `cook` (
  `cook_seq` int(10) unsigned NOT NULL auto_increment,
  `menu_seq` int(10) unsigned NOT NULL,
  `name` varchar(255) default NULL,
  `price` int(11) default NULL,
  `selected` int(11) default '0',
  `sort` int(11) default '999999',
  `setumei1` varchar(255) default NULL,
  `setumei2` varchar(255) default NULL,
  `image1` varchar(255) default NULL,
  `status` varchar(1) NOT NULL default '1',
  `regist_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `update_date` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`cook_seq`),
  KEY `menu_seq` (`menu_seq`),
  CONSTRAINT `cook_ibfk_1` FOREIGN KEY (`menu_seq`) REFERENCES `menu` (`menu_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

 

mysql> ALTER TABLE cook DROP FOREIGN KEY cook_ibfk_1;
Query OK, 52 rows affected (0.14 sec)
Records: 52  Duplicates: 0  Warnings: 0

 

 

| cook  | CREATE TABLE `cook` (
  `cook_seq` int(10) unsigned NOT NULL auto_increment,
  `menu_seq` int(10) unsigned NOT NULL,
  `name` varchar(255) default NULL,
  `menuname` varchar(255) default NULL,
  `price` int(11) default NULL,
  `selected` int(11) default '0',
  `sort` int(11) default '999999',
  `setumei1` varchar(255) default NULL,
  `setumei2` varchar(255) default NULL,
  `image1` varchar(255) default NULL,
  `status` varchar(1) NOT NULL default '1',
  `regist_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `update_date` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`cook_seq`),
  KEY `menu_seq` (`menu_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

 

 

 

カテゴリ内の記事