mySQL

run-> cmd
cd:\phpdev\mysql\bin\mysql
create database products;
use products;
mysql>create table items(
itemID int(11) not null auto_increment,
itemName varchar(255) not null default ' ',
itemPrice float not null default ' 0 ',
primary key (itemID));
insert into items (itemName,itemPrice) values ('Apple','3.99'),
('Orange','4.99'),
('Mango','6.99');
select * from items;