sql - 获取错误列在 PostgreSQL 中不存在
问题描述
我正在尝试填充数据库中的表,但收到该列不存在的错误。有人可以指导我哪里出错了。以下是我的查询:
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Shire, Robert, 206-524-2422, 12/14/2017, AntiqueDesk,3000.00, 249.00, 329.00);
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Shire, Robert, 206-524-2422, 12/14/2017, ‘AntiqueDeskChair’, 500.00, 41.50, 541.50);
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Goodyear,Katherine,206-524-3544, 12/15/2017, ‘DiningTableLinens’, 1000.00, 83.00, 1083.00);
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Bancroft, Chris, 426-635-9788, 12/15/2017, Candles, 50.00, 4.16, 54.16);
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Griffith, John, 206-524-4656, 12/23/2017, Candles, 45.00, 3.74, 48.74);
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Shire, Robert, 206-524-2422, 1/5/2018, DeskLamp, 250.00, 20.75, 270.75);
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Tierney, Doris, 425-635-8677, 1/10/2018, DiningTableLinens, 750.00, 62.25, 812.25);
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Anderson, Donna, 360-538-3544, 1/12/2018, BookShelf, 250.00, 20.75, 270.75);
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Goodyear, Katherine, 206-524-544, 1/15/2018, AntiqueChair, 1250.00, 103.75, 1353.75);
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Goodyear, Katherine, 206-524-544, 1/15/2018, AntiqueChair, 1750.00, 145.25, 1895.25);
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES (Tierney, Doris, 425-635-8677, AntiqueCandleHolders , 350.00, 29.05, 379.05)
解决方案
您插入的所有值都需要在单引号之间,例如:
INSERT INTO Sales (LastName,FirstName,Phone,InvoiceDate,InvoiceItem,Price,Tax,Total)
VALUES ('Shire', 'Robert', '206-524-2422', '12/14/2017', 'AntiqueDesk', '3000.00', '249.00', '329.00');
它将起作用:https ://dbfiddle.uk/?rdbms=postgres_9.4&fiddle=bdc47dea28c109aafb26aac1e8e5d856
推荐阅读
- java - Logback Spring - 在运行时使用 jar 外部的外部 yaml 文件更改日志级别
- c# - 错误:输入字符串的格式不正确
- spring-boot - 关于 ResponseStatusException 返回错误对象中的空消息字段
- json - Azure 资源管理器:Web 应用槽配置:应用服务身份验证
- google-apps-script - 我需要将 Google Sheet 1 中的数据复制到 Google Sheet2 中的一行
- python - 使用贪心方法的活动选择问题的不同解决方案
- angular - 是否可以在 TypeScript 中设置 Angular SelectionModel 对象的 CompareWith 函数
- python - 从包含路径的数据框列中提取字典到数据框
- python - 在我的函数之前和之后添加行使用装饰器
- php - 刷新网页后表单数据尝试重新发送