title: Mysql SHOW CREATE TABLE Problem with default value
body: <p>I have two database and i am compare database with column by column.</p>
  
  <p>Database 1 : <code>SHOW CREATE TABLE affiliate_action</code> result is attached on link <a href="http://prntscr.com/m3xqe3" rel="nofollow noreferrer">http://prntscr.com/m3xqe3</a></p>
  
  <p>Database 2 : <code>SHOW CREATE TABLE affiliate_action</code> result is attached on link <a href="http://prntscr.com/m3xqjb" rel="nofollow noreferrer">http://prntscr.com/m3xqjb</a></p>
  
  <p>So difference is on default value. one is without single quote and second is with single quote.. so i make query like this</p>
  
  <p><code>ALTER TABLE affiliate_action MODIFY commission float NOT NULL DEFAULT 0;</code> so we can remove single quote problem. but nothing happen.</p>
  
  <p>Can someone tell me why its happening </p>