title: Create a table in Mysql from selected columns of exisiting table and with same structure
body: <p>I am a newbie and  i am using <strong>mysql</strong>. I want to create a table <strong>product</strong> from an existing table <strong>customer</strong> but i want only the selected columns of <strong>customer</strong> table to be created in new table and that too with the same structure. Eg In customer table there is a column with name <strong>DATE</strong> which has <strong>default as CURRENT_TIMESTAMP</strong> and <strong>ON UPDATE CURRENT TIMESTAMP</strong> . SO i want that this structure is also created in the new table.</p>
  
  <p>I looked other answers but they do not copy the structure. Please help me</p>