title: How can I create table named as current date in python MySQL?
body: <p>I am creating a table in python MySQL and want to use the current date as table name. My code giving an error. here is my code:</p>
  <pre><code>def create():
  conn = mysql.connector.connect(user='root', host='localhost', database='college', password='$@ffron@09')
  cur = conn.cursor()
  current_date = date.today()
  query = 'create table %s(Name char(40) not null,Academic_year VARCHAR(5) not null ,Serial_number varchar(20) primary key ,Father_name char(20) not null, Mother_name char(20) not null,Email_id VARCHAR(25) not null unique,Contact_number int not null,Semester VARCHAR(5) not null)'
  data=(current_date,)
  cur.execute(query,data)
  
  create()
  </code></pre>
  <p>This code throwing an error: 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 ''2021-04-13'(Name char(40) not null,Academic_year VARCHAR(5) not null ,Serial_nu' at line 1</p>
  <p>How can I achieve this and rectify this error?</p>