----- Original Message -----
From: Matt Robertson
To: CF-Talk
Sent: Thursday, July 08, 2004 6:19 PM
Subject: Re: SOT: MySQL Create table/field
brobborb wrote:
> Hey guys, is it possible to create tables and fields inside the CFQUERY tag with a
>mysql database? if so, can you send me to some resources that show
the syntax?
Hey, its CF-Talk... you're already at the resource, dude :-)
<cfquery
username="#request.myDBUserName#"
password="#request.myDBPassword#"
datasource="#request.myDSN#">
CREATE TABLE approvers (
ID int(10) unsigned not NULL auto_increment,
ParentID int(10) unsigned ,
ApproverID int(10) unsigned ,
Reviewed char(1) ,
Approved char(1) ,
ApproverName varchar(255) ,
ApproverEmail varchar(255) ,
Comments text ,
LastReview datetime ,
PRIMARY KEY (ID),
INDEX ParentID (ParentID),
INDEX ApproverID (ApproverID)
);
</cfquery>
--
--Matt Robertson--
MSB Designs, Inc.
mysecretbase.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
