mysql 1064错误 delete from 表名 a where a.id>=20报错

报错sql : delete from sys_role_user a where a.userId>=20;

在这里插入图片描述

解决方法

playA : delete from sys_role_user where userId>=20;(去掉别名)
playB : delete a from sys_role_user a where a.userId>=20;(或者在delete 后面加上别名 )
在这里插入图片描述

using APP_API; using DoMain.hp_dto; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using Model.sys_model; using System.Reflection; namespace CY_API.Controllers.EscortControllers { /// <summary> /// 服务对象控制器 /// </summary> [Route("api/[controller]")] [Authorize] [ApiExplorerSettings(GroupName = "base_data")] public class OrderPersonController : BaseApiController { public OrderPersonController(IFreeSql fsql) : base(fsql) { } /// <summary> /// 获取服务对象 /// </summary> /// <returns></returns> [HttpGet("GetOp")] [AllowAnonymous] public ActionResult<retEnumerable<sys_orderperson>> GetOp(int page=1, int size=10) { var data = _fsql.Select<sys_orderperson>(); data.OrderBy(x => x.sort).Page(page, size).ToList(); return Ok(data.GetRetEnumerable(page, size)); } /// <summary> /// 删除服务对象 /// </summary> /// <param name="id"></param> /// <returns></returns> [HttpDelete("DeleteOP")] [AllowAnonymous] public IActionResult DeleteOP(int id) { _fsql.Transaction(() => { _fsql.Update<sys_orderperson>(id).Set(a => a.is_del, true).ExecuteAffrows(); }); return this.ReturnOk(); } /// <summary> /// 修改服务对象 /// </summary> /// <param name="person"></param> /// <returns></returns> [HttpPut("UpdateOP")] [AllowAnonymous] public IActionResult UpdateOP([FromBody] sys_orderperson person) { _fsql.Transaction(() => { var result = _fsql.Update<sys_orderperson>() .Set(x => x.name, person.name) .Set(x => x.sex, person.sex) .Set(x => x.phone, person.phone) .Set(x => x.age, person.age) .Set(x => x.idCard, person.idCard) .Set(x => x.sort, person.sort) .Set(x => x.remark, person.remark) .Where(x => x.orderperson_id == person.orderperson_id) .ExecuteAffrows(); }); return this.ReturnOk(); } /// <summary> /// 新增服务对象 /// </summary> /// <param name="person"></param> /// <returns></returns> [HttpPost] [AllowAnonymous] public IActionResult InsertOrderPerson([FromBody]retOrderperson person) { _fsql.Transaction(() => { var result = _fsql.Insert<sys_orderperson>() .Insert(x => x.name, person.name) .Set(x => x.sex, person.sex) .Set(x => x.phone, person.phone) .Set(x => x.age, person.age) .Set(x => x.idCard, person.idCard) .Set(x => x.sort, person.sort) .Set(x => x.remark, person.remark) .Where(x => x.orderperson_id == person.orderperson_id) .ExecuteAffrows(); }); return this.ReturnOk(); //_fsql.Insert<sys_orderperson>().Insert(); //return this.ReturnOk(); } } } 添加代码报错,如何写
08-06
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

是美婷吗

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值