MySQL includes the database name in the view definition, making the view undeployable to a database with a different name (which I do when running tests, for example.)
Right now, I simply redefine the view later in the file, after the md5sum, and that works fine. But I'd like to be able to omit the dumped definition for clarity.
+1 for this.
MySQL includes the database name in the view definition, making the view undeployable to a database with a different name (which I do when running tests, for example.)
Right now, I simply redefine the view later in the file, after the md5sum, and that works fine. But I'd like to be able to omit the dumped definition for clarity.