add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version()
5.7.39
Records: 6  Duplicates: 0  Warnings: 0
Records: 3  Duplicates: 0  Warnings: 0
truck_id is_online deleted_at
ABC123 0 null
ADF134 0 null
DEF123 0 null
consignment_id shipment transporter truck_id
30 shipment1 transporter1 ABC123
31 shipment2 transporter2 ABC123
32 shipment3 transporter3 DEF123
33 shipment4 transporter4 DEF123
34 shipment5 transporter5 DEF123
35 shipment6 transporter6 DEF123
consignment_id shipment transporter truck_id truck_id is_online deleted_at
31 shipment2 transporter2 ABC123 ABC123 0 null
35 shipment6 transporter6 DEF123 DEF123 0 null