Hi All
We use mysql to store customer order data. Each day's orders are added to the same mysql db.
So, for example, the whole year could all be in that one db.
What we're trying to do is select out a single day's orders from the monster db and dump just that day's orders to a file or to the monitor.
We would also like to format that dump with our choice of delimiter, etc., just like with the dump utility in Mysqlman.
Is it possible to select out data by date and have it dumped to either a file or to the monitor?
Many thanks.
------------------------------------------
We use mysql to store customer order data. Each day's orders are added to the same mysql db.
So, for example, the whole year could all be in that one db.
What we're trying to do is select out a single day's orders from the monster db and dump just that day's orders to a file or to the monitor.
We would also like to format that dump with our choice of delimiter, etc., just like with the dump utility in Mysqlman.
Is it possible to select out data by date and have it dumped to either a file or to the monitor?
Many thanks.
------------------------------------------