I derived by mysqldump the view in the database, but there are some views to export into the select 1, how is this to return a responsibility excuse me?
The mysqldump uuser1 - ppwd123 dbname1 v_agu & gt; E:/v_agu SQL
Results:
DROP TABLE IF the EXISTS ` v_agu `;
/*! 50001 the DROP VIEW IF the EXISTS ` v_agu ` */.
The SET @ saved_cs_client=@ @ character_set_client;
SET character_set_client=utf8;
/*! 50001 the CREATE VIEW ` v_agu ` AS SELECT
1 the AS ` exchangeid `,
1 the AS ` instrumentid `,
1 the AS ` instrumentname ` */.
The SET character_set_client=@ saved_cs_client;