Tables

Question 1

Creating a Table

Answer 1

CREATE TABLE table_name();

Question 2

Define Three Columns

Answer 2

column_name DATA_TYPE,
column_name DATA_TYPE,
column_name DATA_TYPE

Question 3

Define a Column as an Integer

Answer 3

column_name INT

Question 4

Define a Column as a Variable Character

Answer 4

column_name VARCHAR(# of chars.)

Question 5

Define a Column as a Decimal

Answer 5

column_name DECIMAL(# of total digits, # of digits after decimal point)

Question 6

Look at a Table Schema

Answer 6

DESCRIBE table_name;

Question 7

Delete Table

Answer 7

DROP TABLE table_name;

Question 8

Add Column to Table

Answer 8

ALTER TABLE table_name ADD column_name DATA_TYPE;

Question 9

Remove Column from Table

Answer 9

ALTER TABLE table_name DROP column_name;

Question 10

Set Primary Key

Answer 10

column_name DATA_TYPE PRIMARY KEY

or

PRIMARY KEY column_name

Question 11

Look at Specific Table Columns

Answer 11

SELECT column_name, column_name, etc. FROM table_name

Question 12

Look at All Table Columns

Answer 12

SELECT * FROM table_name

Question 13

Add Data to Table

Answer 13

INSERT INTO table_name(column_name1, column_name2) VALUES(numerical_value1, ‘string_value2’);