SELECT DATE_FORMAT(dato, '%e/%c/%Y') AS dato FROM transportdokument WHERE
dato = '2013-07-20' AND dato = '2013-07-24' GROUP BY dato DESC is working
perfect in my PHP file.
But I need to transfer the date back from my norwegian formatted date to
the origin date format in WHERE dato =
I have been asked to set up multiple database replication which I have
done before for simple cases however there are some nuances with this
instance that add some complexity and I'd like to hear your collective
expertise on this proposed scenario:-
1) Single master database
2) n (probably 3
I'm unclear on your task, but maybe this function will help:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date
(It is confusing to have dato as both a column name and an alias.)
-Original Message-
From: Karl-Arne Gjersøyen
4) 3 tables from the slaves are to be replicated back to the master
NO.
However, consider Percona XtraDb Cluster or MariaDB+Galera. They allow
multiple writable masters. But they won't let you be so selective about tables
not being replicated.
Here are the gotchas for Galera usage: