[mj0769]

Hi all,

newbie sql question.. searched forums here but couldn't find an answer...

I'm working with a series of databases. One is called 'books' and the other 'storage'. I'mm trying to create a table within the storage db called 'CustomerID'..

When I do the CREATE TABLE how do I specify which db to add it to? I've followed several samples creating db's and then using 'create table'.. and get the error 'No database selected'.. seems obvious to get that.. but haven't been able to find a solution.

Thanks
-M

[OBP]

M, are you using MYSQL or something similar?
Where are you ttrying to create the From, outside the Database completely?

[mj0769]

ODP, thanks for the reply.

I'm using mysql with intentions of building a php-mysql app. For the CREATE TABLE I'm doing it from the command line in the mysql directory. I've modified the PATH so I can call mysql commands from anywhere.

I installed them using the xampp bundle. As for directories, it's something I could use help with too. Currently under the xampp dir' tree there are apache, mysql and php all in their own dir's. The server root is C:\xampp\htdocs. In order to run the complete app which I'm building, do I have to move everything ( apache, mysql and php) under the htdocs??

[OBP]

m, sorry I can't help you, my expertise is Access databases followed by Excel Workbooks. I don't know any MYSQL.

[slurpee55]

By default, the table is created in the default database. An error occurs if the table exists, if there is no default database, or if the database does not exist.
The table name can be specified as db_name.tbl_name to create the table in a specific database. This works regardless of whether there is a default database, assuming that the database exists. If you use quoted identifiers, quote the database and table names separately. For example, write `mydb`.`mytbl`, not `mydb.mytbl`.

[mj0769]

Thanks slurpee55, that worked. I created a new db called foo and added a table called 'mynewtable' using this:
create database foo;

create table foo.mynewtable (
name varchar(20) not null,
date1 date not null,
primary key(name) );

then...I was able to view what was created using: "describe foo.mynewtable;"..

Also, you may have noticed my other q' about dir' trees of php, mysql and xampp. I didn't know if it's ok as is or if I need to move everything under the htdocs tree. I ran the commands above in the server root at 'xampp\htdocs' and was able to access the db's fine. but it worked.. so I guess the current dir' tree is ok.

Thanks! -M

[slurpee55]

Glad it worked out for you - I am not a MySQL person either, just a good googler
If it all is working, please use the button at the top of the page to mark this thread as "Solved"