为什么 PHPPGAdmin 在命令行没有插入时会出现插入错误?

我正在尝试将 PHPPGadmin 插入到我的一张表中:

INSERT INTO teachers (first_name,last_name,school,hire_date,salary) VALUES ('Ron','Buckby','F.D. Roosevelt School','04-17-1979',34900);

然后我得到一个错误:

SQL error:

ERROR:  syntax error at or near "INTO"
LINE 1: SELECT COUNT(*) AS total FROM (INSERT INTO teachers (first_n...
                                              ^
In statement:
SELECT COUNT(*) AS total FROM (INSERT INTO teachers (first_name,34900)) AS sub

但是,如果我在命令行上执行完全相同的插入操作,它会起作用:

analysis=# INSERT INTO teachers (first_name,34900);
INSERT 0 1

然后我可以对数据进行选择:

SELECT * FROM teachers WHERE first_name ilike 'ron' AND last_name ilike 'buckby';
 id | first_name | last_name |        school         | hire_date  | salary
----+------------+-----------+-----------------------+------------+--------
 16 | Ron        | Buckby    | F.D. Roosevelt School | 1979-04-17 |  34900
(1 row)

为什么只有使用 PHPPGAdmin 才会插入失败?

xzpxiao 回答:为什么 PHPPGAdmin 在命令行没有插入时会出现插入错误?

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/605977.html

大家都在问