Showing entries 1 to 2
Displaying posts with tag: Routine (reset)
MySQL:The user specified as a definer does not exist (error 1449)-Solutions

Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.

Generate random test data for MySQL using routines

At times you’ll find yourself responsible for generating test data for newly created tables for testing or sampling purpose. There are tools that will generate random data for you but they’re not free. At-times you’ll write scripts to generate data but those will be table specific. I hate generating dummy data, yes I do and […]

Showing entries 1 to 2