MySQL Server Installation and command usage

This article is from the experimental building related parts of the documentation and experimental operation process.

First, MySQL Introduction

MySQL is a relational database management system that stores data in different tables rather than putting all of the data in a large warehouse, increasing speed and increasing flexibility. MySQL uses the SQL language is used to access the database of the most common standardized language, due to its small size, fast, low total cost of ownership, especially the open source code this feature, the general development of small and medium-sized web sites have chosen MySQL as the site database.

Second, the use of the command

1) command to start MySQL server: sudo service mysql start. Enter Command link server: mysql-u root (note There are no semicolons)

2) Input Query

Query current MySQL version number and current date: SELECT version (), current_date;

Query current MySQL version number and current time: SELECT version (), now ();

It is important to note that MySQL determines where the statement ends by looking for a terminating semicolon rather than the end of the input line. That is, there can be more than one statement in a row, as long as the separate statements are separated by semicolons, or a single statement can appear in multiple lines, as long as the end of the semicolon ends with the line.

3) If you do not want to execute the statement you are entering, you can enter \c cancellation.

In addition, the meaning table for the prompt is as follows:

MySQL Server Installation and command usage