WHERE 70 BETWEEN start_sequence AND end_sequence
AND 'C' BETWEEN start_batch AND end_batch;
Though what you should really do is add a unique auto increment to every
symbol, then you only have to do a simple range check.
Or use a full relational structure and have a OTM or MTM with your stock ta
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
muhammad subair schrieb:
> On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote:
>
>> Hi list,
>> i use mysqldump --tab to create database dumps. this will produce txt and
>> sql files.
>> the resulting sql files is owned by the user but the resulting datafile is
>> owned by mysql.mysql
>> is