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: 3  Duplicates: 0  Warnings: 0
truck_id is_online deleted_at
ABC123 0 null
ADF134 0 null
DEF123 0 null
Records: 6  Duplicates: 0  Warnings: 0
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
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fiddle.c.consignment_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by