The following articles mainly describe MySQL database commands in detail. We first begin by displaying the basic information of the MySQL database to parse the MySQL database commands in detail, the following describes the specific content of the
First, change the root user password for MySQL 1, to enter the database[[email protected] ~]# /usr/local/mysql/bin/mysql -urootWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.6.36 MySQL
MySQL database basic commands (favorites), mysql commands
I sorted out the basic mysql commands and shared them.
# Start, stop, and restart MySql service mysql start | stop | restart/etc/init. d/mysql restart | start | restart # connect to MySQL
9. Create a databaseDatabase StructureSystem DatabaseCreate a databaseView DatabaseDelete DatabaseSummaryAfter you design and install the Microsoft SQL Server 2000 database, you can learn how to create a database. Compared with earlier versions, SQL
2017-10-10linux Basics (6) Basic commandsIn the previous chapter, we mainly introduced some basic Linux command and command line interface format, in Linux, the command is necessary to master some basic commands, in the future shell script, we also
Mysql database introduction and mysql display commands, mysql database
The following describes the mysql database. The details are as follows:
MySQL
Database:
Oracle, DB2, SQL Server, MySQL, access, mangodb, bigtable
Relational Database
The following articles mainly describe how to implement the basic usage of MySQL Databases in linux. The following describes the specific operations in the article, if you are interested in the actual operations, I hope the following articles will
Here we introduce the common Basic command one, log off shutdown restart logoff system logout Command 1Logout logoff is the relative operation of the landing system to leave the system users as long as the direct release of the logout command:
Basic MySQL commands and basic mysql commands
SQL
Statement
Mysql version: For mysql-5.6.36 version1.1 Common commands
# View database mysql> show databases; show databases like '% pres %'; # fuzzy query # View table mysql> use xzymysql> show
The following articles mainly describe MySQL database commands in detail. We first begin by displaying the basic information of the MySQL database to parse the MySQL database commands in detail, the following describes the specific content of the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.