03232006 1557 GMT-6
So once a month you are matching each record
to one of 40 criteria AND if they match any of them
you want to move them copied from db1, put into another
db2, and deleted from db1.
Does that mean every month you will add to db2? Does that
mean db1 will be getting smaller and smaller?
If you are doing this through a web interfact, php is
the way to go - but if you have access to the machine,
just store the procedure and do it there.
Wade
Christopher E wrote:
>Hello All,
>
>I am trying to find a scrip that would allow me to filter out and move
>to another database the records that don't match.
>
>I have this database that has 1.5 million records, now out of all this
>records there is roughly about 300,000 records that are once I needed.
>
>Now I have about 40 different things that these records could match
>and if it matches in any of these things then I want them moved to the
>other database, at that point they would be deleted from the first
>database but the onces from the first database that did not match
>would remain in there intill I delete them my self as there is times
>where I will realize i missed a keyword or code that could of been
>searched.
>
>This prossess would be done once amonth.
>
>I am using MySQL v3.23.58 and PHP v4.3
>
>would it be better to have this all done or as much as can through
>MySQL or through PHP what ever is the best way is the way I would like
>help with.
>
>PLEASE if there is any one that could help me with this I would be
>greatful.
>
>
>
>
>
>
>
>
>The php_mysql group is dedicated to learn more about the PHP/MySQL web
>database possibilities through group learning.
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
