UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]// 一个表内通过 select 更新update cluster as a set a.kube_conf=(select conf from(select c.kube_conf as conf from cluster as c where c.id=11)as d)where a.id=16;
insert
insertinto joke (gid,name)value(0,"joker");
delete
deletefrom tableName where id=10;
group by count
# 自动更新查询
select id, count(*) as cfrom app_commit group by app_id, commit_id, branch order by c;
唯一
# show
mysql>showkeysfrom cluster;+---------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+|Table| Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed |Null| Index_type |Comment| Index_comment |+---------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| cluster |0|PRIMARY|1| id | A |2|NULL|NULL||BTREE|||| cluster |0| name |1| name | A |2|NULL|NULL||BTREE|||+---------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+# add unique keyaltertable app_commit addUNIQUEKEY idx_app_commit_branch(app_id, commit_id, branch);# drop unique keyaltertable app_commit dropindex idx_app_commit_branch;