I first into the blog park, the initial blog, in the next time will be a little bit to improve the level of their blog, as well as the layout of the blog.Today, I learned the basic knowledge of MySQL database, I believe that there will be a lot of
several common installation packages for MySQL :rpm, source code, binary-free compilationStep (binary-free compilation):①Cd/usr/local/srcEnter the/USR/LOCAL/SRC directoryIiwget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.36-linux-glibc2.5-x86_6
Data typeNumeric typeIntegerInt (m) four bytes (-2.1 billion ~21 billion)---java:intBigInt (M) eight bytes (18 square)---java:longFloating point numberFloat (m,d) single-precision floating-point number 8-bit precision four bytes m total number of D
The MySQL system variables include global variables (globals) and session variables (sessions), the global variable takes effect for all session, and the session variable includes the global variable. MySQL tuning is bound to involve the adjustment
Tag: Direct user value substr Manager int IMP RedWrote a batch of Lua script, to put in the database, the call when the calculation, because there are too many Lua script, wrote a program to input.The following are mainly divided into three parts:
Multi-table Connection query (two specifications SQL92 and SQL99)SQL92 Specification:Equivalent connection, non-equivalent connection, outer connection, generalized Cartesian product connectionMultiple tables are placed after the from, after the
The limit of the hash indexHash index must be searched two timesHash index cannot be used for sortingA hash index does not support partial index lookups, nor does IT support range lookupsHash code calculation in hash index may have a hashing
Table:Select Table_schema,table_name,table_type,engine from Information_schema.tables where Table_schema not in (' Performance_schema ', ' information_schema ', ' MySQL ');View:Select Table_schema,table_name from information_schema.tables where
1, download the MySQL source tarball, and cmake RPM package:Boost_1_59_0.tar.gzMysql-5.7.19.tar.gzcmake-2.8.12.2-4.el6.x86_64.rpm2, unzip the package, and move to the corresponding position (not fixed):CP-RF Boost_1_59_0/usr/local/boostCP-RF Mysql-5.
Delete:1.rpm-qa|grep-i MySQL to view installed MySQL2./usr/local/mysql/support-files/mysql.server stop stop MySQL service3.whereis MySQL Collection MySQL folder information or find/-name MySQL (recommended)4.rpm-ev mysql-***** Uninstall remove MySQL
1.int Sub-query trapsTitle : In the Ecshop Mall table, query 6th items, (note, number 6th is a large column)Most intuitive : mysql> Select Goods_id,cat_id,goods_name from goods where cat_id in (select cat_id from ecs_c Ategory where parent_id=6);
In Azurestack MySQL is a managed service that can be used to run, manage, and scale a highly available MySQL database in the cloud.The previous article described the deployment of MS SQL Server, and let's look at how to add a MySQL resource provider
1 Download MySQL compression pack on https://dev.mysql.com/downloads/mysql/2 unzip and add the bin directory to the environment variable3 initialization, the data directory will be generated in the MySQL root directory after
First, storage engine introductionThe storage engine is a table type, and MySQL has different processing mechanisms depending on the table typeSecond, the table introducesTable is equivalent to a file, a record in the table is equivalent to a row of
How to solve mysql Service Startup failure during mysql5.7.18 installation, mysql5.7.18mysql
MySQL is a very powerful relational database. However, some beginners may encounter various difficulties when installing the configuration. Here we will not
Translation: set password Statement (submitted to the MariaDB official Manual), passwordmariadb
This article is the official mariadb Manual: the translation of set password.
Original article:
How to reset the Root password for Mac MySQL
Note: You can reset the password of MySQL installed in Homebrew directly. For MySQL installed in other ways, you need to switch the corresponding installation directory.
After installing MySQL for a long
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