describe table

mysql> describe shipped_order;
+---------------------+--------------+------+-----+---------+----------------+
| Field               | Type         | Null | Key | Default | Extra          |
+---------------------+--------------+------+-----+---------+----------------+
| id                  | int(11)      | NO   | PRI | NULL    | auto_increment |
| ship_to_address     | varchar(255) | YES  |     | NULL    |                |
| total_weight        | bigint(20)   | YES  |     | NULL    |                |
| ups_tracking_number | bigint(20)   | YES  |     | NULL    |                |
| real_shipping_costs | varchar(10)  | YES  |     | NULL    |                |
| processing_date     | date         | YES  |     | NULL    |                |
| notification_status | varchar(255) | YES  |     | NULL    |                |
| email_address       | varchar(255) | YES  |     | NULL    |                |
| order_id            | int(11)      | YES  | MUL | NULL    |                |
+---------------------+--------------+------+-----+---------+----------------+
9 rows in set (0.02 sec)

myodbc.log

-- Query logging
--
--  Driver name: MySQL ODBC 5.1 Driver  Version: 05.01.0006
-- Timestamp: 100310 15:40:18

INSERT INTO shipped_order (ship_to_address, total_weight, order_id, email_address, processing_date, real_shipping_costs, ups_tracking_number)  VALUES ( _latin1'123 main st   rainbow city AL 35906', '1.6', '1257', _latin1'[email protected]', _latin1'201003', _latin1'41.71', '1Z00000000000000') ;
ROLLBACK;
COMMIT;

worldship_output

Exporting to local_clickfund_export

Shipments since 02/08/2010 up to 03/10/2010

There are 2 to be exported.

Exporting record 1

  extracting data for package: 1

Preparing data for export, please wait.

  translating record 1 for shipped_order

  writing record 1 to shipped_order

Truncated column shipped_order::order_id in table shipped_order from '1257973085' to '1257'.

Truncated column shipped_order::processing_date in table shipped_order from '20100310144109' to '201003'.

The export has been abandoned!!  Attempting to rollback changes in the export database.

Export cancelled, or there were problems during export that may have caused the export to fail!

No records were exported.