碼农的日常

在清空表中数据时报错：[SQL]truncate table ACT_RE_DEPLOYMENT ;[Err] 1701 - Cannot truncate a table referenced in a foreign key constraint (`act`.`ACT_GE_BYTEARRAY`, CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (...

一段时间不写就忘记了，写个博客记录哈--  建表CREATE TABLEIF NOT EXISTS USER (    id VARCHAR (125) NOT NULL COMMENT 'id',    user_name VARCHAR (64) NOT NULL COMMENT '用户名',    real_name VARCHAR (64) COMMENT '姓名',  ...