Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started