your stock table.
Regards,
Gavin Towey
-Original Message-
From: hezjing [mailto:hezj...@gmail.com]
Sent: Friday, July 24, 2009 10:27 AM
To: mysql@lists.mysql.com
Subject: Selecting from the range of serial numbers
Hi
My stock serial number format is 1A - 9A, 1B - 9B
Hi
My stock serial number format is 1A - 9A, 1B - 9B ... 1Z
- 9Z.
These stocks are check in to warehouse in different order, so the worker may
check in the stocks like
1A - 00100A
9B - 00010C
00051B - 00070B
I have a table to keep track the stock check in transa
