error. no database selected problem solved!

Thanks for all of your input. I didn't realize that I had to 1st create the database: mysql> create database phonelist; Database "phonelist" created. and than follow that up with: mysql> use phonelist Database changed next: mysql> create table table01( id INT(100) PRIMARY KEY, firstName VARCHAR(15), lastName VARCHAR(15), email VARCHAR(20), phone VARCHAR(15) ); Query OK, 0 rows affected (0.00 sec) The next step is to put data into the table. Thanks again for all help. p ===== ---------------- "forget your lust for the rich man's gold. All that you need, is in your soul. You can do this if you try. All that I want for you my son, is to be satisfied" ~ Lynard Skynard