Starting out with MySQL

[JoeLongstreet]

Hello,

 

This is my very fist post so obviously I am totally new to the subject.  I'm working from an O'Reilly book (Learning PHP and MySQL by Michele E. Davis and Jon A. Phillips) and I've come to the section on introducing MySQL.  The book tells me to type a chunk of code into the command line client:

 

CREATE TABLE books (
title_id INT NOT NULL AUTO_INCREMENT,
title VARCHAR (150),
pages INT,
PRIMARY KEY (title_id));
CREATE TABLE authors (
author_id INT NOT NULL AUTO_INCREMENT,
title_id INT NOT NULL,
author VARCHAR (125),
PRIMARY KEY (author_id));

 

And then it gives me this: ERROR 1046 (3D000): No database selected

 

The book doesn't say anything about this so I'm a little confused.

 

I've been writing my PHP in Dreamweaver and everything has been going smoothly.  Just need a little help in getting MySQL going.  I'm also running Mac OSX 10.4.11 if that makes any difference.

 

Any suggestions?

 

Thanks,

 

Joe

 

 

[otuatail]

You need a database. how are you executing this? do you have phpmyadmin to controll a database. Database have tables and you have to create a table within it.

 

Desmond.

 

[JoeLongstreet]

Not entirely sure what your asking since I'm pretty new.  I'm executing this through Terminal on a Mac?  I don't know what phpmyadmin is and I'm not sure how to create a table.

 

Any chance you could point me in the direction of a tutorial that would help me figure out some of these things?

 

Thanks,

 

Joe

[wildteen88]

Make sure you havn't missed a step in the book (back track a page or two). The book should explain how to select or create a databases before telling you how to create a table.