I have a database of ~60000 records that is updated daily. 10 procedures are to be created in MYSQL to separate specific records into separate tables.
Procedures are to be called everytime after update takes place. Simple PHP file needs to be created to call procedures and check if they were successfylly applied or any errors happened.
Database CSV file updated is located here: <[login to view URL]>
file is about 30MB
File is already converted into MYSQL database and it words.
Reason for doing this: We want to create additional sets of data to be searched for in our database.
Access to our MYSQL database will be provided to winner OR you can work on data provided