Cartesian Product Of Tables Create Table Of Adventurers – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255) ) Create Table Of Adventurer’s Equipment – Create table called equipment CREATE TABLE equipment ( – string variable name varchar(255), – string variable …
All Unique Values In Two Tables Create Table Of Elves – Create table called elves CREATE TABLE elves ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) ) Create Table Of Dwarves – Create table called dwarves CREATE TABLE dwarves ( – string …
Update Rows Based On Another Table Create Table Of Elves – Create table called elves CREATE TABLE elves ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable alive varchar(255) ) Create Table Of Deaths – Create table called deaths CREATE TABLE deaths ( – string …
Insert Rows Create Table – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) ) Insert Row – Insert row into the table adventurers INSERT INTO adventurers (name, age, race, weapon) VALUES (‘Fjoak Doom-Wife’, 28, ‘Human’, …
Delete Rows Create Table – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) ) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (name, age, race, weapon) VALUES (‘Fjoak Doom-Wife’, 28, ‘Human’, ‘Axe’), …
Delete Primary Key Create Table – Create table called adventurers CREATE TABLE adventurers ( – integer variable adventurer_id INT, – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255), PRIMARY KEY (adventurer_id) ) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (adventurer_id, …
Delete Duplicates Create Table Of Elves – Create table called elves CREATE TABLE elves ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable alive varchar(255) ) Insert Rows Into Elf Table INSERT INTO elves (name, age, race, alive) VALUES (‘Dallar Woodfoot’, 25, ‘Elf’, ‘Yes’), (‘Cordin …
Delete All Rows Create Table – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) ) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (name, age, race, weapon) VALUES (‘Fjoak Doom-Wife’, 28, ‘Human’, …
Create Primary Key Create Table – Create table called adventurers CREATE TABLE adventurers ( – integer variable adventurer_id INT, – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255), PRIMARY KEY (adventurer_id) ) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (adventurer_id, …
Create Column Of Values Create Table – Create table called adventurers CREATE TABLE adventurers ( – string variable name varchar(255), – integer variable age int, – string variable race varchar(255), – string variable weapon varchar(255) ) Insert Rows – Insert into the table adventurers INSERT INTO adventurers (name, age, race, weapon) VALUES (‘Fjoak Doom-Wife’, 28, …