php - MySQL 错误编号 : 1064 in codeigniter

Question

我想在 codeigniter 中创建一个 View 表，但出现错误 MySQL Error Number: 1064

$this->db->query('
    CREATE VIEW totalamount AS
    SELECT column amount, user
    FROM transactions
    WHERE user = 1
');

Answer 1

请记住空间不支持任何数据库列，例如您使用的列名列数量。现在它将有 column_amount

请遵循以下代码:

$this->db->query('CREATE VIEW totalamount AS
SELECT column_amount, user FROM transactions WHERE user = 1');