RE: Selecting from the range of serial numbers

2009-07-24 Thread Gavin Towey
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

Selecting from the range of serial numbers

2009-07-24 Thread hezjing
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

Re: mysqldump and access rights

2009-07-24 Thread walter harms
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