/*drop table Person;

create table Person(
    id int not null auto_increment,
    primary key(id),
    `name` varchar(30),
    age int

);

insert into Person values
(null, 'Mustermann',42),
(null, 'Musterfrau',24),
(null, 'Friedl',19);

select * from Person*/

/*drop table Essen;

create table Essen(
    id int not null auto_increment,
    primary key(id),
    `Bezeichnung` varchar(50),
    `Menge` varchar(30),
    `Art`   varchar(30),
    `KCAL`  int not null
);

insert into Essen values
(null,"Leberkässemmel","Stück","Essen",500),
(null,"Spaghetti Bolognese", "Teller", "Essen", 595),
(null,"Weißbier", "Halbe", "Trinken", 225),
(null,"Avocado", "Stück", "Essen", 543),
(null,"Laugenbrezel", "Stück", "Essen", 192),
(null,"Cola", "kleine Flasche", "Trinken", 220);

-- select * from Essen
*/
update Essen
Set Bezeichnung = "Coca Cola"
where Bezeichnung = "Cola";

--select * from Essen

delete from Essen where Bezeichnung = "Avocado";

--select * from Essen

insert into Essen values
(null,"Croissant klein", "Stück", "Essen", 220);

select * from Essen