between 2 dates select latest_date, lowest_date, floor(datediff(date(latest_date), date(lowest_date)) / 365) from your_table
Converts something like 45353 into 2012-11-10 update as tb set tb.your_mysql_datefield = date_add(date('1899-12...
select replace(picon, 'http', 'shit') from mytable select replace( , ' ', ' ') from in an update update mytable set picon...
Best results in other decks
We had a strange behaviour on one of our mariadb-servers: Everyday at around midnight we saw that the root...
If replication is broken by a simple invalid query, i.e. grants change, etc. you can force-skip that query: