突变
更新并且同步语句到每个节点ALTER TABLE v_face on cluster perftest_2shards_1replicas update data_flg = 1 where face_id = '350100123456000000000220201117164935211340621134';
删除并且同步语句到每个节点
ALTER TABLE v_image_info on cluster perftest_2shards_1replicas delete where father_id = '350100123456000000000220201117164935211340621134';
查询和插入
查询与MYSQL大体相似SELECT * FROM v_image_info
插入
insert into v_face (face_id,info_kind,source_id,device_id,left_top_x,left_top_y,right_btm_x,right_btm_y,is_driver,is_foreigner,is_suspected_terrorist,is_criminal_involved,is_detainees,is_victim,is_suspicious_person, location_mark_time,face_appear_time,face_disAppear_time,id_type,id_number,name,used_name,alias,gender_code,age_up_limit,age_lower_limit,ethic_code,natio_nality_code,native_city_code,residence_admin_division, chinese_accent_code,job_category,accompany_number,hair_style,hair_color,skin_color,face_style,facial_feature,physical_feature,respirator_color,cap_style,cap_color,glasses_style,glasses_color,passport_type, immigrant_type_code,suspected_terroris_tnumber,criminal_involved_specilisation_code,body_speciall_mark,crime_method,crime_character_code,escaped_criminal_number,detention_house_code,detainees_identity, detainees_special_identity,member_type_code,victim_type,injured_degree,corpse_condition_code,attitude,similarity_degree,eyebrow_style,nose_style,mustache_style,lip_style,wrinkle_pouch,acnestain, freckle_birth_mark,scard_imple,other_feature,data_flg,crt_time,crt_user,crt_name,crt_host,upd_time,upd_user,upd_name,upd_host) VALUES ('350100123456000000000220201117164935211340621134', 1, '35010012345600000000022020111716493521134', '35010100081197008491', 7140, 3083, 7858, 4527, 2, 2, 2, 2, 2, 2, 2, '2020-11-17 16:49:35.0', '2020-11-17 16:49:35.0', '2020-11-17 16:49:35.0', null, null, '张三', null, null, '1', 31, 31, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1, 1606810609436, null, null, null, null, null, null, null);
