在选择错误中插入...选择除法运算符？

Question

如果不存在则创建表 XY ( x 整数不为空， y 浮点数为空， 主键(x) ）

INSERT INTO XY (x,y)
(select 1 as x ,(1/7) as y);

错误吗？

Error code 1064, SQL state 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO XY (x,y)
(select 1 as x ,(1/7) as y)' at line 7
Line 1, column 1

有任何想法

Answer 1

您应该在 CREATE TABLE 语句之后（或在 INSERT 语句之前）添加 ;。您正在尝试执行 2 个不带分隔符的不同查询。

CREATE TABLE IF NOT EXISTS XY (
x INT NOT NULL ,
y FLOAT NULL ,
PRIMARY KEY(x)
);  # !!! Originally, you missed ;

INSERT INTO XY (x,y)
(select 1 as x ,(1/7) as y);

Answer 2

select 语句需要加括号吗

INSERT INTO XY (x,y)
select 1 as x ,(1/7) as y;