Lesson 1: MySQL Basic Commands

Question 1

Command to create a database.

Answer 1

CREATE DATABASE databaseName;

Question 2

Command to create a table.

Answer 2

CREATE TABLE tableName (columnName dataType (length), ….);

Question 3

Data Type for id.

Answer 3

INT

Question 4

Datatype for name

Answer 4

VARCHAR

Question 5

Data type for date

Answer 5

DATE

Question 6

Data type for date and time

Answer 6

TIMESTAMP

Question 7

Data type for decimal numbers

Answer 7

DECIMAL (whole, decimal)

Question 8

Data type for images

Answer 8

BLOB

Question 9

Command to schedule task

Answer 9

CREATE TRIGGER

Question 10

Command to add a column to table

Answer 10

ALTER TABLE tableName ADD columnName dataType (length);

Question 11

Command to change the table’s name.

Answer 11

ALTER TABLE oldTableName TO newTableName;

Question 12

Command to change column’s name.

Answer 12

ALTER TABLE tableName CHANGE oldColName newColName dataType (length);

Question 13

Command to remove a column.

Answer 13

ALTER TABLE tableName DROP COLUMN columnName;

Question 14

Command to delete all data.

Answer 14

TRUNCATE TABLE tableName;

Question 15

Command to delete structure and data of table.

Answer 15

DROP TABLE tableName;

Question 16

Delete structure and data of database.

Answer 16

DROP DATABASE databaseName;