veg.sql

CREATE TABLE vegetable (
vege_id INT NOT NULL AUTO_INCREMENT ,
vege_name VARCHAR(50) NOT NULL UNIQUE,

image VARCHAR(50) NOT NULL UNIQUE,

PRIMARY KEY (vege_id)

);



insert into vegetable (vege_name,image) values('Tomato','tomato.png');
insert into vegetable (vege_name,image) values('Potato','potato.png');
insert into vegetable (vege_name,image) values('Beans','beans.png');
insert into vegetable (vege_name,image) values('BitterGourd','bittergourd.png');
insert into vegetable (vege_name,image) values('Brinjal','brinjal.png');
insert into vegetable (vege_name,image) values('Carrot','carrot.png');
insert into vegetable (vege_name,image) values('ChickenPeas','chickenpeas.png');
insert into vegetable (vege_name,image) values('Cucumber','cucumber.png');
insert into vegetable (vege_name,image) values('Garlic','garlic.png');
insert into vegetable (vege_name,image) values('GreenChilli','greenchilli.png');
insert into vegetable (vege_name,image) values('Lemon','lemon.png');
insert into vegetable (vege_name,image) values('Onion','onion.png');
insert into vegetable (vege_name,image) values('Raddish','raddish.png');
insert into vegetable (vege_name,image) values('BabyCorn','babycorn.png');
insert into vegetable (vege_name,image) values('Beetroot','beetroot.png');
insert into vegetable (vege_name,image) values('BottleGourd','bottlegourd.png');
insert into vegetable (vege_name,image) values('Brocli','brocoli.png');
insert into vegetable (vege_name,image) values('Cabbage','cabbage.png');
insert into vegetable (vege_name,image) values('Capsicum','capsicum.png');
insert into vegetable (vege_name,image) values('CauliFlower','cauliflower.png');
insert into vegetable (vege_name,image) values('Coriander','coriander.png');
insert into vegetable (vege_name,image) values('DrumStick','drumstick.png');
insert into vegetable (vege_name,image) values('Ginger','ginger.png');
insert into vegetable (vege_name,image) values('LadysFinger','ladysfinger.png');
insert into vegetable (vege_name,image) values('Methi','methi.png');
insert into vegetable (vege_name,image) values('Spinach','spinach.png');