title: Mysql: Setup the format of DATETIME to 'DD-MM-YYYY HH:MM:SS' when creating a table
body: <p>After googling around, I cannot find a way to create a new table with a <code>DATETIME</code> column with the default format set to '<code>DD-MM-YYYY HH:MM:SS</code>'</p>
  
  <p>I saw a tutorial in which it was done in <code>phpmyadmin</code> so I suspect that I could use mysql via command line and achieve the same thing when creating my new table with </p>
  
  <pre><code>CREATE TABLE ()
  </code></pre>
  
  <p>Thank you in advance</p>