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'),
('Alooneric Cortte', 29, 'Human', 'Bow'),
('Piperel Ramsay', 35, 'Elf', 'Bow'),
('Casimir Yardley', 14, 'Elf', 'Bow')
Upper Case String Values
-- Upper case the values in the race column
SELECT UPPER(race) FROM adventurers
upper |
HUMAN |
HUMAN |
ELF |
ELF |
Lower Case String Values
-- Lower case the values in the race column
SELECT lower(race) FROM adventurers
lower |
human |
human |
elf |
elf |