Create Table Of Superheroes
-- Create a table called SUPERHEROES. If it already exists, replace it.
CREATE OR REPLACE TABLE SUPERHEROES (
-- Column called ID allowing up to five characters
"ID" VARCHAR(5),
-- Column called NAME allowing up to 100 characters
"NAME" VARCHAR(100),
-- Column called ALTER_EGO allowing up to 100 characters
"ALTER_EGO" VARCHAR(100)
);
Insert Rows For Each Superhero
-- Insert rows into SUPERHEROES
INSERT INTO SUPERHEROES
-- With the values
VALUES
('XF6K4', 'Chris Maki', 'The Bomber'),
('KD5SK', 'Donny Mav', 'Nuke Miner');
View Table Of Superheroes
-- View the SUPERHEROES table
SELECT * FROM SUPERHEROES;
ID |
NAME |
ALTER_EGO |
XF6K4 |
Chris Maki |
The Bomber |
KD5SK |
Donny Mav |
Nuke Miner |
Describe Table Of Superheroes
-- Describe the table SUPERHEROES
DESCRIBE TABLE SUPERHEROES;
name |
type |
kind |
null? |
default |
primary key |
unique key |
check |
expression |
comment |
ID |
VARCHAR(5) |
COLUMN |
Y |
|
N |
N |
|
|
|
NAME |
VARCHAR(100) |
COLUMN |
Y |
|
N |
N |
|
|
|
ALTER_EGO |
VARCHAR(100) |
COLUMN |
Y |
|
N |
N |
|
|
|
## Describe Table Of Superheroes
-- Alternative: Describe the table SUPERHEROES
DESC TABLE SUPERHEROES;
name |
type |
kind |
null? |
default |
primary key |
unique key |
check |
expression |
comment |
ID |
VARCHAR(5) |
COLUMN |
Y |
|
N |
N |
|
|
|
NAME |
VARCHAR(100) |
COLUMN |
Y |
|
N |
N |
|
|
|
ALTER_EGO |
VARCHAR(100) |
COLUMN |
Y |
|
N |
N |
|
|
|