mysql - 从脚本运行时 MySQL 创建视图失败

Question

第一次海报。我无法让几个创建视图查询从 .sql 文件正确运行。我已经在学校服务器上测试了以下查询，它们工作正常，除非使用“源”命令运行。

*编辑：我试过source ~/file_location/file_name.sql从命令行运行这两种不同的方式，它会很好地提取文件，但似乎没有任何执行。我也试过直接在 sql server 登录时运行它< ~/file_location/file_name.sql

*编辑 2：现在显示文件应该指向哪个数据库的 USE 语句，之前未提及但在提出此问题时存在。

USE [database]    

CREATE VIEW Country_View AS
        SELECT Name, Code, Continent, Population
        FROM Country;

CREATE VIEW city_country_view AS 
    SELECT City.Name, City.Population, Country.Name, Country.Population
    FROM City, Country
    WHERE City.Country = Country.Code;

CREATE VIEW city_country_view2 AS
    SELECT City.Name, City.Population, Country.Name, Country.Population
    FROM City LEFT JOIN Country ON City.Country = Country.Code
    WHERE Country.Code = "USA" OR Country.Code = "CAN" OR Country.Code = "MEX";

CREATE VIEW country_language_view AS
    SELECT Country.Name, Country.Continent, Country.Region, CountryLanguage.Language
    FROM Country, CountryLanguage
    WHERE Country.Code = CountryLanguage.Country;

CREATE VIEW country_language_view2 AS
    SELECT Country.Name, Country.Continent, Country.Region, CountryLanguage.Language
    FROM Country LEFT JOIN CountryLanguage ON Country.Code = CountryLanguage.Country
    WHERE Language = "English" AND IsOfficial = "T";

同样，直接从命令行执行它们是可行的，但导入它们既不会引发错误，也不会创建视图。我相信 MySQL 版本是 5.7.19。

标签： mysqlsqlview