Col1	Col2	Col3
Val1	Val2	Val3
Val4	Val5	Val6

Q1. I want to select all items in Table_1 as above :

SELECT * FROM Table_1;
SELECT Table_1;
SHOW Table_1;

Col1	Col2	Col3
Val1	Val2	Val3
Val4	Val5	Val6

Q2. I want to view the existing column from Table_1 only.

For example, if the Table_1 is as above,

then, i want to see to ouput the column's name only: Col1, Col2 and Col3

SELECT * FROM Table_1;
SHOW COLUMNS FROM Table_1;
SHOW DATABASES;

Q3.I have a database called MyDatabase.

Inside it, I have 3 tables, namely: Table_1, Table_2, Table_3

How can i view the existing tables ?

USE MyDatabase; SHOW TABLES;
USE MyDatabase;
SELECT *;

Col1	Col2	Col3
Val1	Val2	Val3
Val4	Val5	Val6

Q4.I have a table called Table_1 as above:

I want to display the data from Col1 only.

How can i do it?

USE MyDatabase; SHOW TABLES;
SELECT Col1;
SELECT Col1 FROM Table_1;

Col1	Col2	Col3
Val1	Val2	Val3
Val4	Val5	Val6

Q5.I have a table called Table_1 as above:

Col1 act as a primary key.

How can i display Val5 only?

SELECT Col2 FROM Table_1;
SELECT Col2 FROM Table_1 WHERE Col1=Val4;
SELECT * FROM Table_1;

Congratulation! You have answered all of the questions.

Your score is : 0

Well done !