MySQL Basic Learning Notes

1. Log in to the database.mysql-uroot-pxxxx-h127.0.0.1-p3306--prompt XXXPrompt xxx can change the prompt \d represents the full date; \d represents the current database; \h server name; \u the current user.2. DisplaySelect version (); Show

MySQL Sub-Library table and non-stop change table structure

in the MySQL Sub-Library table we are generally based on a large amount of time on the MySQL database an optimization approach, below I briefly introduce MySQL sub-table and the simple way of the library. 1, the sub-database is obvious, a main table

MySQL Reset root password

A How to reset the root password after forgetting the root password of MySQL1. Edit the MySQL configuration file:In the Windows environment:%mysql_installdir%\my.ini//mysql The My.ini configuration file under the installation directory.Linux

Analysis of max_connections configuration parameters of MySQL performance optimization

This article mainly introduced the MySQL performance optimization max_connections configuration parameter analysis, this article emphatically explained 3 kinds of configuration Max_connections parameter method, the need friend can refer to the MySQL

MySQL under Group_concat use

Before encountering a small need: in each row of the data table is the number of each user score per factor (a total of 23 factors), and we need to get the report is a user-dimension of each user's factor score record, where each row of records

MySQL transaction with MySQL storage engine

Transaction concepts and Storage engines1.0 Why business?Let's take a look at a scenario, Bank transfer remittance:Robin Li and Zhou Hongyi fight every day, now let Li give Zhou 祎 transfer money 1000 yuanDesign the following tableAccount tableNumber

Mysql like "will not use the index

Can MySQL use the index in a like query? Where do you use the index?When using like, if you use ' percent ', will you use the index?EXPLAIN  SELECT * from ' user ' WHERE username like '%ptd_% ';  The result above is a full table scan (type = =all)

MYSQL Gtid-based replication

1. Overview Starting with MYSQL5.6, MySQL started supporting Gtid replication. Disadvantages of Log point based replication: Incremental synchronization from the offset of that binary log, which results in inconsistent data if the specified error

Set up server remote connection MySQL

has been single-person development so did not consider this aspect, to the new company to do co-development, so to set up, and then began to engage inHere's a list of the procedures:1) Because of the use of the cloud server, so the above are

MySQL user has set password, but login can not fill in password

Just ready to do the MySQL read and write separation experiment, unexpectedly suddenly slave host slave_io_running state all become No, from the morning until the afternoon can not find the reason, suddenly a thought, instead of using the empty

Modify the root password of MySQL under Windows environment

Recently has been useless mysql,root password to forget, and then I modified it, and now tidy up the steps. (my version is 5.1)1. First get the MySQL bin path, copy it down.Right-click and select Properties.2. Open the Command Window "CMD" and

Re-install MySQL in Docker

1. Check out what software is installed under Ubuntu:Dpkg-l2. Delete mariadb:Apt-get Autoremove--purge mariadb-server-10.0Apt-get Remove Mariadb-serverApt-get Autoremove Mariadb-serverApt-get Remove Mysql-common3. Install MySQLApt-get Install

MySQL installation under Linux

Installation environment: System is centos6.51. Download: Http://dev.mysql.com/downloads/mysql/5.6.html#downloadsDownload version: I choose here 5.6.33, General edition, Linux under 64-bit    you can also directly copy the 64-bit, download by

PHP Operation MySQL Database

[PHP] "Font-family:arial,helvetica,sans-serif" > in PHP Operation Database, will frequently do various operations on the database, so, PHP provides a function interface, Support for a variety of databases, including MySQL database, is well

MySQL 61 Error resolution method

Newly bought a Conoha VPS, after installing MySQL, because too much food will not write code to connect the Visual configuration table from the MySQL Workbench on the Mac field AH properties, but the connection will prompt 61 error, On-line check a

The basic operation of MySQL

Chapter One: Data types and operational data sheetsspecification for MySQL statements(1): Keywords and function names all uppercase(2): Database name, table name, field name all lowercase(3): SQL statement must end with a semicolon1: Command-line

MySQL error:you can ' t specify target table for update on FROM clause

MySQL in your can ' t specify target table for update in FROM clause error means that you cannot select some of the values in the same table first, and then update the table (in the same statement). For example, the following SQL:The code is as

MySQL usage under Windows

Specific reference to http://jingyan.baidu.com/article/3aed632e19b5e8701080918f.html1. Install MySQL. Direct Baidu search MySQL download.2. Select extract to C or D, choose your own.3. Two ways to start the MySQL service:(1) Launch directly in Task

Latest MySQL database vulnerabilities and mysql reports

Latest MySQL database vulnerabilities and mysql reports Recently, the Internet disclosed about the existence of MySQL database Code Execution Vulnerability (CNNVD-201609-183. Due to some defects in the default configuration of the MySQL database,

Ifnullnullif and ISNULL usage in MySql

Ifnullnullif and ISNULL usage in MySql I used isnull in MySql today to find that it is a little different from MSSQL. Now, let's briefly summarize: In mysql, isnull, ifnull, and nullif are used as follows: Isnull (expr) usage:If expr is null, the

Total Pages: 3233 1 .... 1790 1791 1792 1793 1794 .... 3233 Go to: GO

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.