title: How do I add "On Update Cascade" to my existing MySQL tables through PHPmyAdmin?
body: <p>So I'm doing some work on this database with many tables, several of which have a 1 to many relationship to several other tables. I recently realized I'd made a mistake in one of my PARENT keys, and I updated it thinking it would update in the foreign key. I was very confused when it didn't. I then learned that I would have had to set up a "On Update Cascade" on the table (With the foreign key?) if I wanted automatic updates to take place. However, I'm pretty far along with my database development and I'd like very much not to have to start my tables over just to add this feature into my tables. </p>
  
  <p>I'm using PhpMyAdmin to do pretty much everything, and I can't seem to find a button that will do this for me. So What I need to know is: Is there a way I can retrofit my foreign keys so that future updates cascade as needed? </p>
  
  <p>The Following 3 tables are examples of tables in my database. (This code was taken from the EXPORT files)</p>
  
  <p><strong>MySQL</strong></p>
  
  <pre><code>CREATE TABLE `Icon_Stats` (
    `Id` int(11) NOT NULL,
    `Stat` char(255) COLLATE utf8_bin NOT NULL,
    `Meaning` char(255) COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  CREATE TABLE `Icon_Values` (
    `Id` int(11) NOT NULL,
    `Value` char(255) COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  
  CREATE TABLE `Icons_Apt` (
    `Id` int(11) NOT NULL,
    `Species` char(255) COLLATE utf8_bin NOT NULL DEFAULT 'All',
    `Trait` char(255) COLLATE utf8_bin NOT NULL,
    `Stat` char(255) COLLATE utf8_bin NOT NULL,
    `Value` char(255) COLLATE utf8_bin NOT NULL,
    `Color` char(255) COLLATE utf8_bin NOT NULL,
    `Img` varchar(255) COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  </code></pre>
  
  <p><strong>Icons_Apt</strong> has 4 foreign keys, but for the sake of this example I've only listed 2: <strong>Stat</strong> from <strong>Icon_Stats</strong> and <strong>Value</strong> from <strong>Icon_Values</strong>. I've combed the export file for Icons_Apt, but I can't find anything stating that either of those fields have a foreign key. I'm not sure how my database would know about all the relations if I were to export and then re-import all this data. </p>
  
  <p>In any case, <strong>is there a way for me to update the current tables to "On Update Cascade"?</strong> Or would I have to delete the tables, create a new one and import all the data again?</p>