Error when creating MySQL table

[neogazz]

Please see the attached picture. When I try to create my MySQL table using the below commands I get the attached error, why?

mysql> CREATE TABLE grocery_inventory (
-> id int not null primary key auto_increment,
-> item_name varchar (50) not null,
-> item_desc text,
-> item_price float not null,
-> curr_qty int not null
-> );

I am using Wampserver 2.0.

[numberwhun]

That error is telling you that you have not first selected a database in which to create your new table. First do the following:

use <dbname>;

where <dbname> is the name of your database. So, if you have a database called kitchen, you would issue the command:

use kitchen;

Then issue your create table command and it should work. If not and you have a syntax issue, then be sure to check the documentation for the command on the specific version of Mysql that you are using.

Regards,

Jeff

[neogazz]

Thanks I got it to work. First I created the database 'kitchen', via the phpMyAdmin consol. Then I inserted the below code and it worked:

use kitchen;
mysql> CREATE TABLE grocery_inventory (
id int not null primary key auto_increment,
item_name varchar (50) not null,
item_desc text,
item_price float not null,
curr_qty int not null
);