MySQL Learning summary----Database related operations

MySQL Learning summary----Database related operations

==========================================================================================

First, MySQL database

===================================================================

MySQL is a relational database management system developed by the Swedish MySQL AB company, currently owned by Oracle Corporation. MySQL is an associated database management system that keeps data in separate tables rather than putting all of the data in a large warehouse, which increases speed and increases flexibility.

• "MySQL is open source, so you don't have to pay any extra fees.

• "MySQL supports large databases. You can handle large databases that have thousands records.

• MySQL uses the standard SQL data language form.

• MySQL can be allowed on multiple systems and supports multiple languages. These programming languages include C, C + +, Python, Java, Perl, PHP, Eiffel, Ruby, and Tcl.

• "" MySQL has a good support for PHP, PHP is the most popular web development language today.

• MySQL support large database, support 50 million records of Data Warehouse, 32-bit system table file maximum support 4gb,64 bit system to support the largest table file is 8TB.

• MySQL can be customized, using the GPL protocol, you can modify the source code to develop their own MySQL system.

===================================================================

Second, create a database

===================================================================

1, the command line to create a database named Doublelinux;

1) Open the local MYSQL1 using the Linux Remote Connection tool

[Email protected] ~]# mysql-uroot-p

Enter Password:

Welcome to the MySQL Monitor. Commands End With; or \g.

Your MySQL Connection ID is 24

Server version:5.5.54 MySQL Community Server (GPL)

Copyright (c), Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its

Affiliates. Other names trademarks of their respective

Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Mysql>

2) Create a database named Doublelinux;

mysql> CREATE database doublelinux;

Query OK, 1 row Affected (0.00 sec)

3) See which databases are available under the current MySQL database;

Mysql> show databases;

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

| Database |

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

| Information_schema |

| Doublelinux |

| MySQL |

| Performance_schema |

| Test |

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

6 rows in Set (0.00 sec)

===================================================================

Third, view and select a database

===================================================================

1. See which databases are under the current MySQL database;

Mysql> show databases;

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

| Database |

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

| Information_schema |

| Doublelinux |

| MySQL |

| Performance_schema |

| Test |

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

6 rows in Set (0.00 sec)

2. Select Doublelinux Database

mysql> use doublelinux;

Database changed

===================================================================

Iv. Deleting a database

===================================================================

1. Delete doublelinux data

mysql> drop database doublelinux;

Query OK, 0 rows affected (0.03 sec)

This article from "Doublelinux" blog, declined reprint!

MySQL Learning summary----Database related operations