Learning machine learning? Try my machine learning flashcards or Machine Learning with Python Cookbook.
Add Comment To Column
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');
Describe Table (To See Comments)
-- Describe table
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 |
Add Comment To Column
Note: If a comment already exists, this will override it.
-- If it exists, comment...
COMMENT IF EXISTS
-- The "ALTER_EGO" column in the table "SUPERHEROES"
ON COLUMN SUPERHEROES.ALTER_EGO
-- With this string
IS 'This is a column of the superhero aliases';
Describe Table (To See Comments)
-- Describe table
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 | This is a column of the superhero aliases |