How do you create temporary MySQL table in SQLAlchemy?

Need a MySQL 'create table' string

• I need a MySQL query to create a table with the following columns (character count should be 50 unless otherwise indicated in parentheses): PodcastName Category Province (2) Website Email Description Keywords City DateAdded Rating (1) --- will be a number between 1 and 5 XML-URL ProducerName HostName

• Answer:

  Hi rservice, Please find the create table statement below. Replace "Tablename" with your preferred name for the table. CREATE TABLE Tablename ( PodcastName varchar(50), Category varchar(50), Province varchar(2), Website varchar(50), Email varchar(50), Description varchar(50), Keywords varchar(50), City varchar(50), DateAdded varchar(50), Rating tinyint, XML-URL varchar(50), ProducerName varchar(50), HostName varchar(50) ); If you require any further clarification, please do not hesitate to ask. Regards, lotd