I am reading the doc for the relevant tool in order to use it, well, actually I have performed a test with great success but when i came across to tables with foreign keys i got troubled . So i have a few questions on the subject which i don’t understand:
I dont understand this. I mean, why does the child table “follows” the old table? The way I think of it , the child table will look for the foreign keys according to the table name (right?), and since the new table (the altered) was renamed and has the proper name, how come the child table tries to reference the foreign keys to the old one. Also, as it is stated on the manual, the old table is dropped which means the child table tries to reference a table that doesn’t exist?
What change on the foreign keys will be made on the child table? I mean, the table name and the rows are the same …
I am not an expert of mysql so excuse me in advance if i ask something obvious.