clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2805502 fiddles created (40746 in the last week).

CREATE TABLE `shipment` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `carrier` varchar(45) NOT NULL, `bill_number` varchar(45) NOT NULL, `tracking_num` varchar(45) NOT NULL, `invoice_date` date NOT NULL, `fee` decimal(8,2) NOT NULL, `ship_date` date DEFAULT NULL, `delivery_date` date DEFAULT NULL, `recipient` varchar(255) DEFAULT NULL, `shipper` varchar(255) DEFAULT NULL, `zip_from` varchar(5) DEFAULT NULL, `zip_to` varchar(5) DEFAULT NULL, `notes` text, `found` enum('No','Yes','PO','Invoice','Event','Manual','Fee','Supplies') NOT NULL DEFAULT 'No', PRIMARY KEY (`id`), UNIQUE KEY `carrier` (`carrier`,`bill_number`,`tracking_num`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
 hidden batch(es)


INSERT shipment SET carrier = "Shipper", bill_number = "1234", tracking_num = "1234", invoice_date = "2021-07-08", fee = "1.00", ship_date = "2021-06-10", delivery_date = NULL, zip_from = "ABCD", zip_to = "", recipient = "||", shipper = "COMPANY", notes = "||||", found = "No"
 hidden batch(es)