· 6 years ago · Aug 25, 2019, 04:26 PM
1drop table if exists grocery_list.correct_items cascade;
2CREATE TABLE grocery_list.correct_items (ID INT(5) NOT NULL AUTO_INCREMENT, Item VARCHAR(45) NOT NULL, PRIMARY KEY (ID), UNIQUE INDEX Item_UNIQUE (Item ASC) VISIBLE);
3insert into grocery_list.correct_items(Item) values('Milk');
4insert into grocery_list.correct_items(Item) values('Apple');
5insert into grocery_list.correct_items(Item) values('Meat');