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

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





mysql%26gt;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"

HEEEELP!!! (MySQL experts / experienced coding using MySQL)?
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 %26lt;databaseName%26gt;;


To create a database: create database %26lt;databaseName%26gt;;
Reply: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;
Reply:The problem is that u havent selected a database to create the table.





*to select a database


database: USE %26lt;databaseName%26gt;;





*to create a database


create database %26lt;databaseName%26gt;;





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....