MySQL

One, MySQL is installed in the configurationI was through the way Baidu cloud disk download. Recommended login Baidu Cloud Terminal, and then click the link below, select the version to install, unzip the installation.Http://www.h2ero.cn/pan/share/17

MySQL mysqldump export only table structure does not export dataCopy CodeThe code is as follows:Mysqldump--opt-d database name-u root-p > Xxx.sqlBacking Up the databaseCopy CodeThe code is as follows:#mysqldump database name > Database backup

1 String functionsTo view the ASCII code of a string: ASCII (str) STR returns 0 when emptySelect ASCII ("a");To view the ASCII code corresponding characters: char (num)Select char (num);Stitching string concat (str1, str2 ...)Select Concat (12,34,

Background of Appearance:The company does a Redis-related project where MySQL stores a lot of statistics. such as client-reported data, redis instance data, application data, machine data and so on. Every day in the report, collection, due to the

Here's a summary of some of the commonly used or possible string built-in functions①ASCII (): Returns the ASCII code of the characterWhat if the input is not a character but a string? ASCII () takes only the first character as a computed parameter,

Because MySQL has always been my weakness (in fact, I am very weak in all aspects), so recently in see MSYQL, just see the difference between varchar and char, so tidy up, easy to forget later.　　0.0 pictures have explained everything, but the system

In the reconstruction of the site, the data structure is usually modified, so add, delete, add the MySQL table field is unavoidable, and sometimes for convenience, but also increase the modification of the table or field comments, the same field

There is a way to do this online:1. View the commands for the current data engine:Show engines;2.Use ' [DBNAME] `;SELECT Group_concat (CONCAT (' ALTER TABLE ', table_name, ' engine=innodb; ') SEPARATOR ")From INFORMATION_SCHEMA. TABLES as TWHERE

#group by #group by + group_concat () #group by + aggregate function #group by + have #group by(1) Meaning of GROUP by: Group The results of the query in 1 or more fields, with the same field values as a group(2) Group by can be

Reported some variable errors, similar to "Time_zone" and other errorsSolve:[Email protected] conf.d]# vi/etc/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling Symbolic-links is recommended to prevent assorted security

MySQL Database sub-Library sub-table backup script=================== students to share the sub-database sub-table ==========================The difference between a script single double quote:Single quotes are strong references, forcing output is

The MySQL stored procedure is a new feature that has been added since MySQL 5.0. The advantages of a stored procedure are a whole bunch. But the main thing is the execution efficiency and the SQL code encapsulation. In particular, the SQL Code

Create a table1. Create student and score tablesCREATE TABLE Student (ID INT (Ten) is not NULL UNIQUE PRIMARY KEY,Name VARCHAR () is not NULL,Sex VARCHAR (4),Birth year,Department VARCHAR (20),Address VARCHAR (50));Create a score table. the SQL code

Original: https://my.oschina.net/uyunsky/blog/109532First, the initial installationMethod 1:Under the/usr/local/mysql/bin/:./mysqladmin-u root password ' new_password 'This method is set for general installation.If MySQL login error:

For some systems with large data volume, the problem of database is not only inefficient, but also the data storage time is long. Especially like a reporting system, the time spent on data import every day can be as long as a few hours or more than 1

Analysis of mysql joint index and Where clause optimization, mysql clause Problem description:The sorting and conditions are removed one by one for testing. The result shows that the sorting is in the sorting part. The execution time is changed from

Three major paradigms of database design and three major paradigms of Database Design In order to establish a database with low redundancy and reasonable structure, certain rules must be followed when designing the database. In relational databases,

MySql index details and correct use methods, mysql index details MySql index details and correct usage 1. Preface: Indexes have a crucial impact on the query speed. Understanding indexes is also the starting point for optimizing database performance.

Detailed description of the writing and summary of the database connection URL, detailed description of the Database Connection url Detailed description of database connection URL writing and summary Jdbc url = protocol name + sub-protocol name +

Multi-to-many, database horizontal splitting architecture, multi-to-many splitting Repost the public account's article "the path to architect" In fact, I still don't understand some points after reading it. I will keep it for a while and then digest