I just migeate from MS SQL to MySQL but have problem on "Cascade Update". Suppose I have BOOK and LIST_TYPE tables like this:
BOOK, field: Book_Name, Book_Type LIST_TYPE, field: Book_Type If I already define Cascade Update between BOOK and LIST_TYPE, then when I update the content of Book_Type (from table LIST_TYPE): the Book_Type of BOOK automatically change too. How to perform Cascade Update in MySQL?