CFQUERY - MySQL Chicken and Egg

[Nick Baker]

I am just now taking a stab at using MySQL, and hit a fundamental snag,
i.e., creating the database. MySQL indicates the following statement will
do the job

<cfquery name="CreateaDB">
CREATE DATABASE [IF NOT EXISTS] Test_DB
</cfquery>

However, as best I can tell CFQUERY wants, among other things, a datasource
and I can't create a datasource without a DB.

Any help would be appreciated.

Thanks,

Nick

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---