mysql> drop table scan; drop table package; create table scan like international.scan; create table package like international.package;
Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

mysql> load data infile 'package.dump' into table package; load data infile 'scan.dump' into table scan;
Query OK, 20 rows affected (0.00 sec)
Records: 20  Deleted: 0  Skipped: 0  Warnings: 0

Query OK, 20 rows affected (0.02 sec)
Records: 20  Deleted: 0  Skipped: 0  Warnings: 0

mysql> UPDATE scan s, package p SET destination = 'GIG', flight = 8865 WHERE s.barcode = p.barcode AND location = 'JFK';
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> use test;
No connection. Trying to reconnect...
Connection id:    1
Current database: *** NONE ***

Database changed
mysql> drop table package2; drop table scan2; create table package2 like package; create table scan2 like scan;
Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> load data infile 'package.dump' into table package2; load data infile 'scan.dump' into table scan2;
Query OK, 20 rows affected (0.01 sec)
Records: 20  Deleted: 0  Skipped: 0  Warnings: 0

Query OK, 20 rows affected (0.01 sec)
Records: 20  Deleted: 0  Skipped: 0  Warnings: 0

mysql> UPDATE scan2 s, package2 p SET destination = 'GIG', flight = 8865 WHERE s.barcode = p.barcode AND location = 'JFK';
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> use test;
No connection. Trying to reconnect...
Connection id:    1
Current database: *** NONE ***

Database changed
mysql> show create table scan; show create table package;
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| scan  |CREATE TABLE `scan` (
  `id` int(11) NOT NULL auto_increment,
  `scan_upload_id` int(11) NOT NULL default '0',
  `barcode` varchar(37) default NULL,
  `carrier` char(2) NOT NULL default '',
  `secondary_carrier` char(2) default NULL,
  `postal_authority` char(2) default NULL,
  `weight` float(5,1) unsigned default NULL,
  `type` enum('P','D','L','U','O','T','R','C','X','Q','Y','V','E') default NULL,
  `flight` smallint(4) unsigned default NULL,
  `location` varchar(4) default NULL,
  `destination` varchar(4) default NULL,
  `handover_loc` varchar(4) default NULL,
  `inbound_flight` smallint(4) unsigned default NULL,
  `from_city` varchar(4) default NULL,
  `old_flight` smallint(4) unsigned default NULL,
  `old_destination` varchar(4) default NULL,
  `OUT_OF_BAND` varchar(100) default NULL,
  `itsDate` date default NULL,
  `itsTime` time default NULL,
  `itsDateTime` datetime default NULL,
  `sequential` int(11) default NULL,
  `bincode` varchar(10) default NULL,
  `error_code` tinyint(4) default '0',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `version` tinyint(4) default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `barcode` (`barcode`,`type`,`itsDate`,`location`),
  KEY `scan_upload_idx` (`scan_upload_id`),
  KEY `flight_idx` (`location`,`flight`),
  KEY `carrier_idx` (`carrier`),
  KEY `date_idx` (`itsDate`),
  KEY `destination_idx` (`destination`),
  KEY `type_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table   | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| package |CREATE TABLE `package` (
  `id` int(11) NOT NULL auto_increment,
  `barcode` varchar(37) default NULL,
  `carrier` char(2) NOT NULL default '',
  `weight` float(5,1) unsigned default NULL,
  `assignment_date` date default NULL,
  `assignment_time` time default NULL,
  `possession_date` date default NULL,
  `possession_time` time default NULL,
  `possession_city` varchar(4) default NULL,
  `delivery_date` date default NULL,
  `delivery_time` time default NULL,
  `delivery_city` varchar(4) default NULL,
  `load1_date` date default NULL,
  `load1_time` time default NULL,
  `load1_city` varchar(4) default NULL,
  `load2_date` date default NULL,
  `load2_time` time default NULL,
  `load2_city` varchar(4) default NULL,
  `load3_date` date default NULL,
  `load3_time` time default NULL,
  `load3_city` varchar(4) default NULL,
  `load4_date` date default NULL,
  `load4_time` time default NULL,
  `load4_city` varchar(4) default NULL,
  `load5_date` date default NULL,
  `load5_time` time default NULL,
  `load5_city` varchar(4) default NULL,
  `load6_date` date default NULL,
  `load6_time` time default NULL,
  `load6_city` varchar(4) default NULL,
  `return_date` date default NULL,
  `return_time` time default NULL,
  `return_city` varchar(4) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `barcode` (`barcode`,`assignment_date`,`carrier`),
  KEY `carrier_idx` (`carrier`),
  KEY `possession_date_idx` (`possession_date`),
  KEY `possession_city_idx` (`possession_city`),
  KEY `delivery_date_idx` (`delivery_date`),
  KEY `delivery_city_idx` (`delivery_city`),
  KEY `load1_date_idx` (`load1_date`),
  KEY `load1_city_idx` (`load1_city`),
  KEY `load2_date_idx` (`load2_date`),
  KEY `load2_city_idx` (`load2_city`),
  KEY `load3_date_idx` (`load3_date`),
  KEY `load3_city_idx` (`load3_city`),
  KEY `load4_date_idx` (`load4_date`),
  KEY `load4_city_idx` (`load4_city`),
  KEY `load5_date_idx` (`load5_date`),
  KEY `load5_city_idx` (`load5_city`),
  KEY `load6_date_idx` (`load6_date`),
  KEY `load6_city_idx` (`load6_city`),
  KEY `assignment_date_idx` (`assignment_date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql> select * from scan;
+--------+----------------+---------------------------+---------+-------------------+------------------+--------+------+--------+----------+-------------+--------------+----------------+-----------+------------+-----------------+-------------+------------+----------+-------------+------------+----------+------------+---------------------+---------+
| id     | scan_upload_id | barcode                   | carrier | secondary_carrier | postal_authority | weight | type | flight | location | destination | handover_loc | inbound_flight | from_city | old_flight | old_destination | OUT_OF_BAND | itsDate    | itsTime  | itsDateTime | sequential | bincode  | error_code | created             | version |
+--------+----------------+---------------------------+---------+-------------------+------------------+--------+------+--------+----------+-------------+--------------+----------------+-----------+------------+-----------------+-------------+------------+----------+-------------+------------+----------+------------+---------------------+---------+
| 271612 |          10887 | USJFKABRRIOEAUL5023404100 | RG      |                   | US               |    5.2 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:50:00 | NULL        |        979 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271613 |          10887 | USJFKYBRRIOEAUL5023800100 | RG      |                   | US               |    5.8 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:50:00 | NULL        |        980 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271614 |          10887 | USJFKABRRIOEAUL5023404000 | RG      |                   | US               |    4.8 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:50:00 | NULL        |        981 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271615 |          10887 | USJFKABRRIOEAUL5023401800 | RG      |                   | US               |    7.1 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:50:00 | NULL        |        982 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271616 |          10887 | USJFKABRRIOEAUL5023402800 | RG      |                   | US               |   10.9 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:50:00 | NULL        |        983 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271617 |          10887 | USJFKYBRRIOEAUL5023800200 | RG      |                   | US               |    4.5 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:51:00 | NULL        |        984 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271618 |          10887 | USJFKABRRIOEAUL5023402400 | RG      |                   | US               |    6.8 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:51:00 | NULL        |        985 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271619 |          10887 | USJFKABRRIOEAUL5023403400 | RG      |                   | US               |    7.0 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:51:00 | NULL        |        986 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271620 |          10887 | USJFKABRRIOEAUL5023402600 | RG      |                   | US               |    2.9 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:51:00 | NULL        |        987 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271621 |          10887 | USJFKYBRRIOEAUL5023800500 | RG      |                   | US               |    9.7 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:51:00 | NULL        |        988 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271622 |          10887 | USJFKYBRRIOEAUL5023800600 | RG      |                   | US               |    5.8 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:51:00 | NULL        |        989 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271623 |          10887 | USJFKABRRIOEAUL5023403000 | RG      |                   | US               |    6.8 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:52:00 | NULL        |        990 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271624 |          10887 | USJFKYBRRIOEAUL5023800800 | RG      |                   | US               |    7.1 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:53:00 | NULL        |        991 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271625 |          10887 | USJFKABRRIOEAUL5023404300 | RG      |                   | US               |    4.9 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:53:00 | NULL        |        992 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271626 |          10887 | USJFKABRRIOEAUL5023401900 | RG      |                   | US               |    8.7 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:53:00 | NULL        |        993 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271627 |          10887 | USJFKABRRIOEAUL5023400700 | RG      |                   | US               |    9.2 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:53:00 | NULL        |        994 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271628 |          10887 | USJFKABRRIOEAUL5023403700 | RG      |                   | US               |    9.1 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:53:00 | NULL        |        995 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271629 |          10887 | USJFKYBRRIOEAUL5023800900 | RG      |                   | US               |    6.0 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:53:00 | NULL        |        996 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271630 |          10887 | USJFKABRRIOEAUL5023400800 | RG      |                   | US               |    8.8 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:54:00 | NULL        |        997 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
| 271631 |          10887 | USJFKABRRIOEAUL5023403500 | RG      |                   | US               |   15.9 | P    |   8865 | JFK      |             | NULL         |              0 |           |          0 |                 | NULL        | 2005-08-23 | 14:54:00 | NULL        |        998 | ake04615 |          0 | 2005-08-23 15:09:35 |       1 |
+--------+----------------+---------------------------+---------+-------------------+------------------+--------+------+--------+----------+-------------+--------------+----------------+-----------+------------+-----------------+-------------+------------+----------+-------------+------------+----------+------------+---------------------+---------+
20 rows in set (0.00 sec)

mysql> select * from package;
+--------+---------------------------+---------+--------+-----------------+-----------------+-----------------+-----------------+-----------------+---------------+---------------+---------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+-------------+-------------+-------------+
| id     | barcode                   | carrier | weight | assignment_date | assignment_time | possession_date | possession_time | possession_city | delivery_date | delivery_time | delivery_city | load1_date | load1_time | load1_city | load2_date | load2_time | load2_city | load3_date | load3_time | load3_city | load4_date | load4_time | load4_city | load5_date | load5_time | load5_city | load6_date | load6_time | load6_city | return_date | return_time | return_city |
+--------+---------------------------+---------+--------+-----------------+-----------------+-----------------+-----------------+-----------------+---------------+---------------+---------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+-------------+-------------+-------------+
| 100210 | USJFKABRRIOEAUL5023404100 | RG      |    5.2 | 2005-08-23      | 14:50:00        | 2005-08-23      | 14:50:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100211 | USJFKYBRRIOEAUL5023800100 | RG      |    5.8 | 2005-08-23      | 14:50:00        | 2005-08-23      | 14:50:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100212 | USJFKABRRIOEAUL5023404000 | RG      |    4.8 | 2005-08-23      | 14:50:00        | 2005-08-23      | 14:50:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100213 | USJFKABRRIOEAUL5023401800 | RG      |    7.1 | 2005-08-23      | 14:50:00        | 2005-08-23      | 14:50:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100214 | USJFKABRRIOEAUL5023402800 | RG      |   10.9 | 2005-08-23      | 14:50:00        | 2005-08-23      | 14:50:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100215 | USJFKYBRRIOEAUL5023800200 | RG      |    4.5 | 2005-08-23      | 14:51:00        | 2005-08-23      | 14:51:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100216 | USJFKABRRIOEAUL5023402400 | RG      |    6.8 | 2005-08-23      | 14:51:00        | 2005-08-23      | 14:51:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100217 | USJFKABRRIOEAUL5023403400 | RG      |    7.0 | 2005-08-23      | 14:51:00        | 2005-08-23      | 14:51:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100218 | USJFKABRRIOEAUL5023402600 | RG      |    2.9 | 2005-08-23      | 14:51:00        | 2005-08-23      | 14:51:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100219 | USJFKYBRRIOEAUL5023800500 | RG      |    9.7 | 2005-08-23      | 14:51:00        | 2005-08-23      | 14:51:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100220 | USJFKYBRRIOEAUL5023800600 | RG      |    5.8 | 2005-08-23      | 14:51:00        | 2005-08-23      | 14:51:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100221 | USJFKABRRIOEAUL5023403000 | RG      |    6.8 | 2005-08-23      | 14:52:00        | 2005-08-23      | 14:52:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100222 | USJFKYBRRIOEAUL5023800800 | RG      |    7.1 | 2005-08-23      | 14:53:00        | 2005-08-23      | 14:53:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100223 | USJFKABRRIOEAUL5023404300 | RG      |    4.9 | 2005-08-23      | 14:53:00        | 2005-08-23      | 14:53:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100224 | USJFKABRRIOEAUL5023401900 | RG      |    8.7 | 2005-08-23      | 14:53:00        | 2005-08-23      | 14:53:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100225 | USJFKABRRIOEAUL5023400700 | RG      |    9.2 | 2005-08-23      | 14:53:00        | 2005-08-23      | 14:53:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100226 | USJFKABRRIOEAUL5023403700 | RG      |    9.1 | 2005-08-23      | 14:53:00        | 2005-08-23      | 14:53:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100227 | USJFKYBRRIOEAUL5023800900 | RG      |    6.0 | 2005-08-23      | 14:53:00        | 2005-08-23      | 14:53:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100228 | USJFKABRRIOEAUL5023400800 | RG      |    8.8 | 2005-08-23      | 14:54:00        | 2005-08-23      | 14:54:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
| 100229 | USJFKABRRIOEAUL5023403500 | RG      |   15.9 | 2005-08-23      | 14:54:00        | 2005-08-23      | 14:54:00        | JFK             | NULL          | NULL          | NULL          | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL       | NULL        | NULL        | NULL        |
+--------+---------------------------+---------+--------+-----------------+-----------------+-----------------+-----------------+-----------------+---------------+---------------+---------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+-------------+-------------+-------------+
20 rows in set (0.01 sec)

mysql> drop table scan; drop table package;
Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.01 sec)

mysql> CREATE TABLE `scan` (
    ->   `id` int(11) NOT NULL auto_increment,
    ->   `scan_upload_id` int(11) NOT NULL default '0',
    ->   `barcode` varchar(37) default NULL,
    ->   `carrier` char(2) NOT NULL default '',
    ->   `secondary_carrier` char(2) default NULL,
    ->   `postal_authority` char(2) default NULL,
    ->   `weight` float(5,1) unsigned default NULL,
    ->   `type` enum('P','D','L','U','O','T','R','C','X','Q','Y','V','E') default NULL,
    ->   `flight` smallint(4) unsigned default NULL,
    ->   `location` varchar(4) default NULL,
    ->   `destination` varchar(4) default NULL,
    ->   `handover_loc` varchar(4) default NULL,
    ->   `inbound_flight` smallint(4) unsigned default NULL,
    ->   `from_city` varchar(4) default NULL,
    ->   `old_flight` smallint(4) unsigned default NULL,
    ->   `old_destination` varchar(4) default NULL,
    ->   `OUT_OF_BAND` varchar(100) default NULL,
    ->   `itsDate` date default NULL,
    ->   `itsTime` time default NULL,
    ->   `itsDateTime` datetime default NULL,
    ->   `sequential` int(11) default NULL,
    ->   `bincode` varchar(10) default NULL,
    ->   `error_code` tinyint(4) default '0',
    ->   `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    ->   `version` tinyint(4) default '1',
    ->   PRIMARY KEY  (`id`),
    ->   UNIQUE KEY `barcode` (`barcode`,`type`,`itsDate`,`location`),
    ->   KEY `scan_upload_idx` (`scan_upload_id`),
    ->   KEY `flight_idx` (`location`,`flight`),
    ->   KEY `carrier_idx` (`carrier`),
    ->   KEY `date_idx` (`itsDate`),
    ->   KEY `destination_idx` (`destination`),
    ->   KEY `type_idx` (`type`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE TABLE `package` (
    ->   `id` int(11) NOT NULL auto_increment,
    ->   `barcode` varchar(37) default NULL,
    ->   `carrier` char(2) NOT NULL default '',
    ->   `weight` float(5,1) unsigned default NULL,
    ->   `assignment_date` date default NULL,
    ->   `assignment_time` time default NULL,
    ->   `possession_date` date default NULL,
    ->   `possession_time` time default NULL,
    ->   `possession_city` varchar(4) default NULL,
    ->   `delivery_date` date default NULL,
    ->   `delivery_time` time default NULL,
    ->   `delivery_city` varchar(4) default NULL,
    ->   `load1_date` date default NULL,
    ->   `load1_time` time default NULL,
    ->   `load1_city` varchar(4) default NULL,
    ->   `load2_date` date default NULL,
    ->   `load2_time` time default NULL,
    ->   `load2_city` varchar(4) default NULL,
    ->   `load3_date` date default NULL,
    ->   `load3_time` time default NULL,
    ->   `load3_city` varchar(4) default NULL,
    ->   `load4_date` date default NULL,
    ->   `load4_time` time default NULL,
    ->   `load4_city` varchar(4) default NULL,
    ->   `load5_date` date default NULL,
    ->   `load5_time` time default NULL,
    ->   `load5_city` varchar(4) default NULL,
    ->   `load6_date` date default NULL,
    ->   `load6_time` time default NULL,
    ->   `load6_city` varchar(4) default NULL,
    ->   `return_date` date default NULL,
    ->   `return_time` time default NULL,
    ->   `return_city` varchar(4) default NULL,
    ->   PRIMARY KEY  (`id`),
    ->   UNIQUE KEY `barcode` (`barcode`,`assignment_date`,`carrier`),
    ->   KEY `carrier_idx` (`carrier`),
    ->   KEY `possession_date_idx` (`possession_date`),
    ->   KEY `possession_city_idx` (`possession_city`),
    ->   KEY `delivery_date_idx` (`delivery_date`),
    ->   KEY `delivery_city_idx` (`delivery_city`),
    ->   KEY `load1_date_idx` (`load1_date`),
    ->   KEY `load1_city_idx` (`load1_city`),
    ->   KEY `load2_date_idx` (`load2_date`),
    ->   KEY `load2_city_idx` (`load2_city`),
    ->   KEY `load3_date_idx` (`load3_date`),
    ->   KEY `load3_city_idx` (`load3_city`),
    ->   KEY `load4_date_idx` (`load4_date`),
    ->   KEY `load4_city_idx` (`load4_city`),
    ->   KEY `load5_date_idx` (`load5_date`),
    ->   KEY `load5_city_idx` (`load5_city`),
    ->   KEY `load6_date_idx` (`load6_date`),
    ->   KEY `load6_city_idx` (`load6_city`),
    ->   KEY `assignment_date_idx` (`assignment_date`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.01 sec)

mysql> load data infile 'package.dump' into table package; load data infile 'scan.dump' into table scan;
Query OK, 20 rows affected (0.00 sec)
Records: 20  Deleted: 0  Skipped: 0  Warnings: 0

Query OK, 20 rows affected (0.01 sec)
Records: 20  Deleted: 0  Skipped: 0  Warnings: 0

mysql> UPDATE scan s, package p SET destination = 'GIG', flight = 8865 WHERE s.barcode = p.barcode AND location = 'JFK';
Query OK, 20 rows affected (0.02 sec)
Rows matched: 20  Changed: 20  Warnings: 0

mysql> tee
Currently logging to file ''show_errors''
mysql> Aborted
