MySQL 导出的视图 错误 的问题
我通过mysqldump导出数据库中的view,可是有一些视图导出来变成了select 1,请问这是怎么回事呢
mysqldump -uuser1 -ppwd123 dbname1 v_agu >E:/v_agu.sql
结果:
DROP TABLE IF EXISTS `v_agu`;
/*!50001 DROP VIEW IF EXISTS `v_agu`*/;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_agu` AS SELECT
1 AS `exchangeid`,
1 AS `instrumentid`,
1 AS `instrumentname`*/;
SET character_set_client = @saved_cs_client;