title: How to change column charset, set as not null and add a default value?
body: <p>The column contains some rules such as not nullable and character_set_name is latin1 and I should write a query to update <strong>only the character_set_name</strong>.</p>
  <blockquote>
  <p>field: name</p>
  <p>type: varchar(255)</p>
  <p>null: NO</p>
  <p>default: JACK</p>
  <p>character_set_name: latin1</p>
  </blockquote>
  <p>Is there any way to do this in one query?</p>
  <pre><code>ALTER TABLE table MODIFY name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  ALTER TABLE table MODIFY name VARCHAR(255) NOT NULL DEFAULT 'JACK';
  </code></pre>
  <p>if I run only the first query, 'name' will accept null values and default=null.</p>