title: Error while creating tables in mysql.connector python -- syntax error code 1064(4200)
body: <pre><code>c1.execute(f&quot;create table {sub_table_name1}(srno int, data_name varchar(255), data varchar(255))&quot;)
  </code></pre>
  <p>the error is</p>
  <blockquote>
  <p>mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(srno int, data_name varchar(255), data varchar(255))' at line 1</p>
  </blockquote>
  <p>i swear to god i have no idea what is wrong...i'm still a beginner to python and mysql connection and any help is welcome</p>