@debasisdas The user is looking to setup a lookup table for his status codes not store all his data in one table.

Like I told you in my earlier post, 1 table is always faster.

You should also use an index if you want to increase scanning speeds as index scans are faster than table scans.

It is always faster accessing 1 table instead of multiple tables. Not quite sure what else you want in the table but try something like this would most likely be best

ID Code ...

At my previous company we also resorted to using dotdefender after we came under a serious sql injection attack. The product worked very well and we were able to get it up and running very fast. It...

Here is a link to an article on creating an event schedule in mysql, unfortunately I don't use mysql so it is the best I can do for you.
...

I don't know mysql very much but if you schedule a job it should not care if a file is open or not.

Schedule a job to run the script at whatever interval you want.

When I did my final project instead of trying to think of an aimless program that hundreds of other students have already done and will just be scrapped the second it was graded.

I found a small...