How do you create temporary MySQL table in SQLAlchemy?

Quick help with MySQL 'create table' command

• I'm trying to create a table called review_main with the following fields: primary key (I guess? do I need one?) company_name (40 chars) city (40 chars) rating (40 chars) phone (12 chars) review_text (need lots of room for this) Could you please provide the MySQL query I need to execute this?

• Answer:

  If there will be multiple ratings for each company, Here is the SQL statement to create such review_main: CREATE TABLE review_main ( company_name VARCHAR(40) NOT NULL, city VARCHAR(40) NOT NULL, rating VARCHAR(40) NOT NULL, phone VARCHAR(12) NOT NULL, review_text MEDIUMTEXT NOT NULL, PRIMARY KEY (company_name,rating) ); Note: TEXT provides a maximum of 64KB space MEDIUMTEXT provides a maximum of 16MB space Please let me know if you have anymore questions. Thank you. -googleexpert