I need to create a table and now we're using MySql as opposed to Microsoft Access.
The following code used to work fine, but now I can't seem to get the syntax ok for MySql.
Error message says that syntax is bad. Can anyone help?
The following code used to work fine, but now I can't seem to get the syntax ok for MySql.
Code:
<CFQUERY DATASOURCE="#listdatasource#">
CREATE TABLE #Url.JobId#
(id Counter,email varchar,SectionNumber integer,CONSTRAINT pk_constraint PRIMARY KEY (id))
</cfquery>
<CFQUERY DATASOURCE="#listdatasource#">
CREATE INDEX table_index ON #Url.JobId# (email)
</cfquery>