Are dynamic insert statements possible in MySQL. I am creating an application that generates a database driven web application with minimal human intervention. Briefly, a user is allowed to build an HTML form(by adding HTML form elements) on a web portal and then he/she submits the form. Once the form is submitted, the metadata of the form is planned to be used to
1. dynamically create a table in the database.
2. dynamically write insert statements to insert values from the form.
I wanted to know if
1. we can dynamically create a table and also generate the corresponding insert statements for the form fields.