You must issue a specialized InnoDB command before running your script: Actually, the constraint comes from the InnoDB engine. Unlike the friendly CASCADE CONSTRAINTS clause you can use in Oracle, MySQL won’t let you create a re-runnable script with only DDL statements. My sample Video Store scripts for my database class are updated for MySQL referential integrity. That trick requires that you write your loading scripts for the Inno DB and use referential integrity constraints. There’s only one real trick to making automatic ERD diagramming work. I don’t want them to leverage the automatic ERD diagramming while they’re learning how to do it. Since my students have to do all their work in Oracle and then port it to MySQL, I demonstrate Quest’s Toad for MySQL’s at the end of the term. In fact, it was annoying to have to install the Microsoft. While SQL Developer is a nice tool and free, Toad is still an awesome development platform, albeit for Windows.
0 Comments
Leave a Reply. |