Question: 1 . Create the following MySQL tables and stuff those tables with the following data: MySQL table data DROP DATABASE IF EXISTS mod 4 sql;
Create the following MySQL tables and stuff those tables with the following data:
MySQL table data DROP DATABASE IF EXISTS modsql;
CREATE DATABASE modsql;
USE modsql;
CREATE TABLE person
Id SMALLINT UNSIGNED NOT NULL AUTOINCREMENT,
name CHAR NOT NULL,
PRIMARY KEY id
;
CREATE TABLE shirt
Id SMALLINT UNSIGNED NOT NULL AUTOINCREMENT,
style ENUMtshirt', 'polo', 'dress' NOT NULL,
color ENUMred 'blue', 'orange', 'white', 'black' NOT NULL,
owner SMALLINT UNSIGNED NOT NULL REFERENCES personid
PRIMARY KEY id
;
INSERT INTO person VALUES NULL 'Antonio Paz';
SELECT @last : LASTINSERTID ;
INSERT INTO shirt VALUES
NULL 'polo', 'blue', @last
NULL 'dress', 'white', @last
NULLtshirt', 'blue', @last;
INSERT INTO person VALUES NULL 'Lilliana Angelovska';
SELECT @last : LASTINSERTID ;
INSERT INTO shirt VALUES
NULL 'dress', 'orange', @last
NULL 'polo', 'red', @last
NULL 'dress', 'blue', @last
NULLtshirt', 'white', @last;
Write a PHP web form that allows an enduser to add records to both tables, update records in both tables, and delete records from both tables.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
