Convert syntax to MySql 1

[MarcDePoe]

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.

<CFQUERY DATASOURCE=&quot;#listdatasource#&quot;>
	CREATE TABLE #Url.JobId#
	(id Counter,email varchar,SectionNumber integer,CONSTRAINT pk_constraint PRIMARY KEY (id))
</cfquery>
<CFQUERY DATASOURCE=&quot;#listdatasource#&quot;>
	CREATE INDEX table_index ON #Url.JobId# (email)
</cfquery>

Error message says that syntax is bad. Can anyone help?

 

[Bromrrrrr]

Try:
CREATE TABLE #url.JobId#
(id INTEGER PRIMARY KEY AUTO_INCREMENT, email VARCHAR(30) NOT NULL , SectionNumber INTEGER, INDEX(email))

This should do it all in one query....

Hope this helps,

Brommrrrr

 

[Bromrrrrr]

Actually that should read INDEX table_index (email) if you want to give your index a name.

Sorry 'bout that