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

## let's pick a topic for our table...

CREATE TABLE ??? (
	name CHAR(50),
	color CHAR(12),
	descr CHAR(50),
	pk_id INT(5) PRIMARY KEY
);

## let's insert some rows, being sure to repeat some colors...

INSERT INTO ???
	VALUES 
		("???", "???", "good quality", 1),
		("???", "???", "decent quality", 2),
		("???", "???", null, 3),
		("???", "???", null, 4);

## show all records
SELECT * FROM ???;

## 1.  Update a field in all rows


##  2.  update certain rows


##  3.  update certain rows, checking for NULL


## 4.  UPDATE with multiple conditions... AND


## 5.  UPDATE with multiple conditions...OR


## 6.  Example of PRIORITIZED UPDATE 


## 7.  update the first so many rows...


## 8.  update MULTIPLE COLUMNS 


## 9.  copy all data from one column to another...


## 10. update with CASE CHANGE 


##  show all records