Removing Definer line from mysqldump
I’ve had issues from time to time where a sql file won’t import because if has a definer in it that doesn’t match the server I’m trying to import the… Read more »
Category: SQL
MySQL triggers for inserted and updated unix timestamps
Here’s the sql I use when creating a database for an app where it’s assumed each table will have columns that store unix time stamps for their created date and… Read more »
MySQL Command line database copy
Sometimes you need to copy a database to a dev database or something. You can usually do this through phpmyadmin, but it’s so much faster, especially with large databases, to… Read more »
MySQL search and replace using update, set
[code language=”sql”] UPDATE table SET column = replace(tablefield, "search", "replace"); [/code]