盒子论坛 v2.1

这么一句
ALTER TABLE  `bcbt`  ADD COLUMN  IF not EXISTS  `ksmpy`  varchar(20);
运行后提示：
Project sj.exe raised exception class EMySqlException with message '#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS  `ksmpy`  varchar(20)  ;
ALTER TABLE  `bcjl`  ADD COLUMN IF NOT E' at line 1'.
navicat运行提示：
[ERR] 1064 - 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 'IF not EXISTS  ( `ksmpy`  varchar(20))' at line 1
[ERR] ALTER TABLE  `bcbt`  ADD COLUMN  IF not EXISTS  ( `ksmpy`  varchar(20)) ;
[SQL] Finished with error

怎么回事，网上都是这个语句啊
----------------------------------------------
-

作者：

fxfwy (凡星)	★☆☆☆☆	-
	盒子活跃会员

2023/12/24 18:22:35

1楼：

mysql 8.1
不能用IF not EXISTS ？
----------------------------------------------
-

作者：

tuesdays (Tuesday)	▲▲▲▲△	-
	普通会员

2023/12/24 18:34:03

2楼：

8.1 甚至 int都不能指定长度了.
----------------------------------------------
delphi界写python最强, python界写delphi最强. 写自己的代码, 让别人去运行.

信息

登陆以后才能回复