我正在尝试将 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 才会插入失败?