sql - When I run the query , it asks me a parameter query for Johnny?

Question

INSERT INTO Sales
VALUES (20, Johnny, 4000, 25/10/2018);

Also in Query Design it doesn't allow me to make this query:

CREATE TABLE Sales (
    custID int,
    custName varchar(255),
    salesValue varchar(255),
    dateSales varchar(255)
    );

INSERT INTO Sales
VALUES (20, Johnny, 4000, 25/10/2018);

I want to create a query to make table and input these data inside it simultaneously.

标签： sqlms-access

Answer 1

Access SQL 中的语法是：

INSERT INTO Sales
VALUES (20, 'Johnny', 4000, #25/10/2018#);

我想创建一个查询来制作表格并同时在其中输入这些数据。

Access SQL 做不到。您必须运行两个查询才能做到这一点。