to import csv file to a table in mysql, should it already exist?

i am trying to build a dynamic table uploaded by a user using odo but the table is not being created dynamically. is there any inbuilt method i can use or should i resort to manually creating the table and then inserting it.
datashape = discover(resource(csvfilepath))
uri=mysql+pymysql://'+username]+':'+password+'@localhost/'+databasename+"::"+tablename
x=odo(csvfilepath,uri,dshape=datashape)
this gives me an error that database.tablename doesnt exist