1. Story ReviewOn the previous blog, I did a MySQL master-slave configuration experiment, linked in this: http://blog.51cto.com/superpcm/2094958. Here I decided to make these two databases to master from each other, and then in the two mutual
In MySQL we often use order by to sort, use the limit to page, when we need to sort after the pagination when we often used a similar wording select * from table name order by sort field LIMT m,n. But this writing hides a deeper use trap. In the
First, IntroductionTurn on the slow query log, you can let the MySQL record query over a specified time of the statement, through the location analysis of performance bottlenecks, to better optimize the performance of the database system.Second,
MySQL Installation and downloadA: Download MySQL installer b: Install MySQL server side c: Install MySQL client d: Client Connection server E: Send commands to the servers through the client, perform additions and deletions to the database
To view the create command for a data table:"Storage Engine": MySQL can store data in different odd numbers in the file (memory), this technology becomes the storage engineEach storage engine uses different storage mechanisms, indexing techniques,
User-related is stored in the Mysql.user table, you can use DESC to view the table structureMySQL Case details:1、数据库名严格区分大小写2、表名严格区分大小写的3、表的别名严格区分大小写4、变量名严格区分大小写5、列名在所有的情况下均忽略大小写6、列的别名在所有的情况下均忽略大小写User Management User Format用户名@可登录主机[email protected]
#!/bin/bash# every morning at 4, MySQL backs up data #chmod theBackup.SH#crontab-e#0 4* * * */home/erya/run/moniter/mysql_backup.SHUser="radius"Password=""Host="localhost"db_name="radius"#backup Directory
First enter in the databaseMysql> Show variables like '%char% ', +--------------------------------------+----------------------------+| variable_name | Value |+--------------------------------------+----------------------------+|
1. Mathematical FunctionsABS (X) absolute valueCeil (X) rounding upFloor (X) rounding downRandom number of RAND (X) 0-1ROUND (x) the nearest integer from XROUND (x, y) holds the decimal number of the X-bit and uses rounding when truncatedPOW (x, y)
There are two common types ofUtf8_general_ci are in normal alphabetical order and are not case sensitive (e.g. a B c D)Utf8_bin in binary order (for example: A in front of a, B D a C)CI is case insensitive, that is, "casing is not sensitive", a and
Indexes are clustered and nonclustered, and the underlying implementations of the different storage engines in MySQL may be different for the index, focusing only on MySQL's default storage engine InnoDB.Use the following command to view the default
Query Section1> all data in query data: SELECT * FROM table name2> the data of an item in the query data: Eg:select id,name from students;3> de-duplicated rows: eg:select distinct gender from students;(means to delete the duplicate row in gender)*
View InnoDB Transaction Table Innodb_trx If there is a transaction thread being lockedSELECT * from INFORMATION_SCHEMA. Innodb_trx;If the ID exists in the sleep thread inside show full processlist, you need to remove the thread manuallyTo manually
At present, MySQL does not support like Oracle RowNum, in the internet also looked for a lot, various ways, their own summary, the implementation method is as followsNew table:
userid
Salay
Zhangsan
10
How to operate MySQL data with Nodejs, in fact, the writing is still simple,1. Start npm install MySQL--save in your node project2. Introducing code into your new project// Introducing a database var mysql=require (' MySQL '); // Implementing Local
Double-click the Mysql-5.5.59-win32.msi to start the installation and the following interface appears
2Click Next, the following interface appears, the default is typical, the re-election is custom, click Next
3After selecting MySQL server,
If reproduced, please specify the source: Http://blog.csdn.net/embedded_sky[Email protected]1. View the number of MySQL connectionsLog on to the MySQL command line and use the following command to view a list of processes that are currently in a
The perfect solution to the problem of group concat function data Truncation in Mysql5.7 is mysql5.7concat.
I encountered a problem in the production environment the day before yesterday: UseGROUP_CONCAT The data obtained from the select function is
Database paradigm and instance, database paradigm instance
When designing a relational database, a rational relational database is designed according to different specifications. These different specifications and requirements are called different
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