******************插入日期格式数据失败:
以下为创建表的sql语句:
create table EMP
(
EMPNO numeric(4) PRIMARY KEY,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR numeric(4),
HIREDATE numeric(8),
SAL numeric(7,2),
COMM numeric(7,2),
DEPNO numeric(4)
);
以下为插入数据的sql语句:
INSERT INTO EMP VALUES
(7934,'MILLER','CLERK',7782,'1982-01-23',1300,NULL,10);
错误1:numeric(4)为数字类型,不是日期类型
应把HIREDATE的字段类型改为data型
错误2:插入数据时'1982-01-23'应改为‘19820123’,去掉“-”,查询数据时会显示为日期类型
*************************
delete from Table [where 非主键列=value]报错(或update),报错如下:
0 | 60 | 14:27:12 | delete from emp where ENAME = 'allen' | Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. | 0.000 sec |
解决方法:执行SET SQL_SAFE_UPDATES = 0;命令行再执行就不会报错
原因如下:https://jingyan.baidu.com/article/e5c39bf58ed69239d76033a4.html