>Is the command prompt the only place where you can create
a new database?
Yes, although someone did once post the name of a web-based admin tool,
something like myphpadmin or mysqladmin...
>How do you set up datasources (I installed MyODBC) on a local
machine (standalone)?
Control Panel->32 bit ODBC->... you should see the MyODBC driver listed.
Choose it & set up a user or system DSN with the name of the database.
> What are the required parameters in a query to a MySQL db?
You just need an SQL statement.
> If I want to create a database locally, but want to transfer it
over my hosting company, how would I go about doing that if
possible at all?
I have a longstanding habit of creating a text file containing all the
SQL DROP TABLE and CREATE TABLE statements that you need in order to
recreate the database. Comes in handy sometimes. Maybe there's another way.
There's a very useful HTML doc you can download from
http://www.mysql.com/documentation/mysql/full/
which probably answers all these questions better than I have.
Enjoy
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
