mysql的操作命令收集

复制表结构后复制数据

CREATE TABLE target_db.my_table LIKE source_db.my_table;

INSERT INTO target_db.my_table SELECT * FROM source_db.my_table;

批量修改特定日期数据

update fruit_table set total = total - 0.399 where date(create_time) ="2024-10-29"

联表匹配特定id的数据并修改

update fruit_delivery_qr_staff set net_weight = net_weight - 0.399 where delivery_qr_id in (select id from fruit_delivery_qr where date(create_time)="2024-10-29")

mysql简洁输出数据

mysql -u root -p --skip-column-names -e "select * from table" nacos -B
--skip-column-names  去掉输出的表头
-B   去掉输出的表框
nacos为指定的库名称
剩下的就是纯数据