MySQL Basic Queries

Question 1

What is the first line of code upon opening command prompt?

Answer 1

cd\ [enter]

Question 2

What is the next command you will type after changing directory (cd)?

Answer 2

cd xampp\mysql\bin [enter]

Question 3

After going to mysql bin, what comes after?

Answer 3

mysql –h localhost –p –u root [enter]

Question 4

If you wish to cancel a command, you may type __?

Answer 4

\C

Question 5

To display the mySQL or MariaDB version installed in your computer

Answer 5

select version(), current_date;

Question 6

To know the current date and time

Answer 6

select now();

Question 7

To know the user currently logged into the system

Answer 7

select user();

Question 8

To show the listing of the databases on the server

Answer 8

show databases;

Question 9

To select a database to use

Answer 9

use [database_name];

Question 10

To show the name of the currently selected database

Answer 10

select database();

Question 11

To show the tables on the currently selected
database

Answer 11

show tables;

Question 12

To show the structure of a particular table

Answer 12

describe [table_name];

Question 13

To view the users on the server

Answer 13

select user, host, password from mysql.user;

Question 14

To set user password

Answer 14

alter user [user_name] identified by [new_password];

Question 15

To create a new user account

Answer 15

create user [user_name] identified by [password];

Question 16

To remove a user

Answer 16

drop user [user_name];

Question 17

To create a database

Answer 17

create database [database_name];

Question 18

To delete a table

Answer 18

drop table [table_name];

Question 19

To insert a record into the table

Answer 19

insert into [table_name] values (…);