HEEEELP!!! (MySQL experts / experienced coding using MySQL)?

[bill]

I am used to code my queries using the oracle software which is 8i. I am new to MySQL. I tried to code:

mysql>CREATE TABLE BOOKS(title VARCHAR(15), type VARCHAR(10), author VARCHAR(30), published DATE);

but an error message occured instead...
"ERROR 1046 (3D000):No database selected"

Why it creates an error? Why the error stated "No database selected" when the codes I used is not to select but to create a table?Are codes in MySQL and ORACLE the same? What should be the proper way done? Is it the error in the installation process?

Please help me solve my problem. I am using MySQL server 5.0.

I am a fresh graduate programmer, so I know a bit of "programming /(software) and hardware terminologies"

[nitinparwal]

It means you havent selected a database to create the table into.
Have you created a database to insert the table into??

To select/use a database: USE <databaseName>;
To create a database: create database <databaseName>;

[Zatoichi]

You have to select the database where you want to create the table. Have you created the database?

Try this command to select the database

USE databasename;

[ryandesign]

The problem is that u havent selected a database to create the table.

*to select a database
database: USE <databaseName>;

*to create a database
create database <databaseName>;

if you are new to mysql I prefer you to use phpmyadmin panel for database codings.

http://.....mysql_server path/phpmyadmin/

http://192.168.10.1/phpmyadmin/

it would be somethin like these....