DROP DATABASE IF EXISTS demo4_1_db;
CREATE DATABASE IF NOT EXISTS demo4_1_db;
USE demo4_1_db;

CREATE TABLE Cereal_prices (
	cereal_ID int(5) PRIMARY KEY NOT NULL AUTO_INCREMENT,
	name char(30),
	manufacturer char(30),
	price_box decimal(5,2),
	last_updated TIMESTAMP
);

CREATE TABLE Cereal_nutrit_info (
	cereal_ID int(5) PRIMARY KEY NOT NULL AUTO_INCREMENT,
	name char(30),
	protein int(5),
	saturated_fat int(5)	
);

CREATE TABLE Cereal_prices_backup (
	cereal_ID int(5) PRIMARY KEY NOT NULL AUTO_INCREMENT,
	name char(30),
	manufacturer char(30),
	price_box decimal(5,2),
	last_updated TIMESTAMP
);

## show the row data 

 
## 1: Add rows, specifying columns:


## 2: Add rows, without specifying columns... auto_inc...timestamp...


## 3: Add rows whenever the system isn't busy...


## 4: Add rows, but replace existing row if unique value is copied...


## 5: Copy ALL fields from one table to another, using a wildcard... 


## 6: Copy some fields from one table to another... 


## 7: Delete all rows...


## 8: Delete certain rows, by matching values in a certain field...


## 9: Delete the first so many rows...


## 10: Delete the first so many rows in a certain order...


## show the row data again, to see what's changed: