Re: MySQL - Creating The Database

On Tuesday 04 June 2002 19:03, Jason Teagle wrote: > > Ummm, not sure exactly what you're asking but you can use mysql_query to > > issue the relevant sql commands to create your database and tables and > > Am I correct in saying that none of the SQL functions in PHP can actually > create a database file when no file existed before? In other words, an > empty database file must exist before SQL functions can be called on it? As the guy said, use mysql_query() to issue the sql commands to create the database: CREATE DATABASE my_database; > This is the problem - how _do_ you create it? What does your install script > do? Copy a blank template of a DB from a file in your installation package, > or literally create a new file? I have no existing databases to work > with... (what's the file extension for a MySQL-type database anyway [i.e., > MS Access = .MDB, MySQL = ?] ?) The problem is that you haven't read the (mysql) manual. Either read the manual or search out (and read) the numerous tutorials that are available. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Dogs just don't seem to be able to tell the difference between important people and the rest of us. */