mysql联表删除

1、表结构

user表

CREATE TABLE `user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) NOT NULL COMMENT '姓名',
  `age` int(11) NOT NULL COMMENT '年龄',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '状态',
  `points` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `name` (`name`,`age`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=46823 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

user_test表

CREATE TABLE `user_test` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2、删除一个表数据

delete ut from user u,user_test ut where u.id=ut.user_id and u.id=298;

3、删除多个表数据

delete u,ut from user u,user_test ut where u.id=ut.user_id and u.id=298;