ALTER TABLE

Write 3 create table statements to create the tables below. Include datatypes as listed and appropriate foreign and primary key syntax.

MySQL Week 4 70 pts This week assignment has a little of everything: Some CREATE TABLE statements with FOREIGN KEYS, ALTER TABLE, string functions (CONCAT, SUBSTR), UPDATES, copy tables, DISTINCT, WHERE, ORDER BY, and JOINS. It just gets more fun! Write 3 create table statements to create the tables below. Include datatypes as listed and […]

Scroll to top