pymysql.err.InternalError: (1075, 'Incorrect table definition; there can be only one auto column and it must be defined as a key')
python中使用pymysql创建table是报错是上面标题,sql语句如下:sql = '...
在oracle里使用自增ID字段的步骤比较繁琐,总结如下:
-- 创建表
CREATE TABLE ADVICE
(
ID INT NOT NULL,
ACTIVE INT DEFAULT 1 NOT NULL,
TYPE INT NOT NULL,
MSG VARCHAR2(512) NOT NULL,
ADVICE VARCHAR2(4...