DROP TABLE IF EXISTS `my-view-name`;
[localhost] CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `my-view-name` AS my-query-that-is-long;
[localhost] 
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
[localhost] /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_LOCAL_SQL_MODE, '') */;