MySQL Interview Questions and Answers

Prepare for your Interview today!

Test your skills through the online practice test: MySQL Quiz Online Practice Test

Related differences

Ques 41. How To Check Server Status with "mysqladmin"?

If you want to check the server status by with "mysqladmin", you can following this tutorial example:

>cd mysqlbin
>mysqladmin -u root status
Uptime: 223 Threads: 1 Questions: 1 Slow queries: 0
Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.004

The returning message indicates that the server is almost doing nothing at this moment.

Is it helpful? Yes No Add Comment View Comments

Ques 42. How To Shut Down the Server with "mysqladmin"?

If you want to shut down the server with "mysqladmin", you can use the command "mysqladmin shutdown" as shown in the following tutorial example:

>cd mysqlbin
>mysqladmin -u root shutdown

If this command returns no messages, your MySQL server should be terminated successfully.

Is it helpful? Yes No Add Comment View Comments

Ques 43. How To Use "mysql" to Run SQL Statements?

If you want to run SQL statement to your server with "mysql", you need to start "mysql" and enter your SQL statement at the "mysql" prompt. Here is a good tutorial exercise that shows you how to run two SQL statements with "mysql":

>cd mysqlbin
>mysql -u root test
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 4 to server version: 5.0.24

mysql> CREATE TABLE links (name VARCHAR(80));
Query OK, 0 rows affected (0.10 sec)

mysql> INSERT INTO links VALUES ('www.GlobalGuideLine.com');
Query OK, 1 row affected (0.02 sec)

mysql> quit;
Bye

Is it helpful? Yes No Add Comment View Comments

Ques 44. How To Show All Tables with "mysql"?

If you want to see all the tables in a database, you run the non-SQL command "SHOW TABLES" at the "mysql" prompt. See the following tutorial exercise for example:

>cd mysqlbin
>mysql -u root test
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 14 to server version: 5.0.24

mysql> SHOW TABLES; +----------------+

| WB_Test |

+----------------+

| EMP_List |

+----------------+

1 row in set (0.01 sec)

The output shows you that there is only one table in the "test" database.

Is it helpful? Yes No Add Comment View Comments

Ques 45. What Is "mysqlcheck"?

"mysqlcheck" is a command-line interface for administrators to check and repair tables. Here are some sample commands supported by "mysqlcheck":

► "mysqlcheck databaseName tableName" - Checks the specified table in the specified database.
► "mysqlcheck databaseName" - Checks all tables in the specified database.
► "mysqlcheck --all-databases" - Checks all tables in all databases.
► "mysqlcheck --analyze databaseName tableName" - Analyzes the specified table in the specified database.
► "mysqlcheck --repair databaseName tableName" - Repairs the specified table in the specified database.

Is it helpful? Yes No Add Comment View Comments

Most helpful rated by users:

About Withoutbook

This site contains most of the quality computer technologies which can help all the related students and employees. We have large number of interview questions and answers, online test, difference between on many subjects.

Copyright © 2024, WBook Technologies.