I have table latest location there i have lat and long with device id.
one more table with fencing name,there i have polygon points. so now how i can check point lies inside polygon. i need this with regular interval of time and storing that to new table.
so how to find this with MySQL function,event or with procedure?


Create a trigger for your location table: http://dev.mysql.com/doc/refman/5.6/en/trigger-syntax.html and inside the trigger function use st_within

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.