Mysql prompt tiphowtomysqlprompt2019.11.25You can change the mysql prompt client so you know where you are.
Very usefull when you manage a lot of mysql databases and you forget which one :-)Read moreDon't forget master infos in your MySQL dumpdevhowtomysql2017.02.20I tried to resync a slave MySQL after it disconnected from the master. But the binary log was already deleted on master, so the only solution was to restore from the last backup.Read moreMySQL import from csvdevhowtomysql2016.10.12To import a local CSV file into MySQL, use the syntax below :
LOAD DATA LOW_PRIORITY LOCAL INFILE '/path/tofile.csv' INTO TABLE database.Read moreMySQL export to csvdevhowtomysql2016.10.12To export a mysql results in CSV format, use the syntax below :
SELECT field1, field2, ... FROM table WHERE condition INTO OUTFILE '/tmp/toto.Read moreAllow invalid date in MySQLdevmysql2016.05.23Just in case you absolutely have to insert a date in MySQL that does’nt exist, eg 2014-02-30, you can run MySQL server in a special mode that authorizes such dates :Read more