title: Is mysql compatible with sql-92?
body: <p>The other day I was trying to create a table in mysql usign a standard syntax:</p>
  
  <pre><code>create table client(
      rc character varying(11)
      constraint client_pk primary key 
  );
  </code></pre>
  
  <p>However, mysql doesn't support setting a primary key this way. (I'm 99% sure it's compliant with the sql-92 norm)
  So my question: Does MySQL fail to support at even these basic things from a 20 year old standard, or am I missing something?</p>
  
  <p>EDIT: my goal is NOT to create this table using using some mysql dialect, but to create this table using a standardized syntax. And the question is whether it is possible.</p>