mysql
没事放放牛、
小菜鸟
展开
-
mysql索引的创建,验证索引是否生效
整篇以表sys_user为例,表名sys_user,字段如下1、索引的创建第一种:create index 索引名 on 表名 (要加索引的字段)具体:create index user_name_index on sys_user (user_name)检测索引是否生效:EXPLAIN select * from sys_user where user_name = '11'...原创 2020-04-22 13:45:16 · 1766 阅读 · 0 评论 -
mysql错误解决1093:[Err] 1093 - You can't specify target table 'go_order_pj' for update in FROM clause
mysql中不支持对查询修改,即对查询结果进行修改解决方法;将查询结果进行临时表转化即可:错误sql:UPDATE go_order_pjSET project_code = ‘02’WHEREgo_order_pj_id IN (SELECTgo_order_pj_idFROMgo_order_pjWHEREgo_order_id IN (SELECTgo_order...原创 2019-09-09 10:13:10 · 269 阅读 · 0 评论