Essay: Small series because years ago has been looking for work, and after years to find work and have been busy work, so also very little time to write something to everyone, in general, review a few times before the interview experience, also a
MySQL Query Cache caches the select query, which is on by default when installed, but if the table is insert, UPDATE, DELETE, TRUNCATE, ALTER table, drop table, or drop Databa SE and other operations, the previous cache is invalid and deleted. This
1.installation2.setup Environment variablesAdd%/mysql server/bin to path.Then restart Cmd/powershell3.invoking MySQL ProgramsCommand interpreter represents with Shell>Enter the program name followed by any options or other arguments.Shell> is not
First, IntroductionIn the master-slave copy of the previous article: http://www.cnblogs.com/lay2017/p/9043985.htmlWe learned that MySQL writes logs through master, slave reads and executes the log content to achieve slave data consistent with master.
See if the data table exists: show TABLES;Displays the database that has been opened: SELECT databases ();View data table structure: Show COLUMNS from * * * (data table name);Insert data: Insert * * * (data table name) (,) VALUES (data);Record
MySQL database Advanced (eight)--event One, Introduction to Events 1, Introduction to EventsAn event is a set of SQL sets that are used to perform timed tasks that are triggered when time is up.An event can be invoked once or periodically, and
Some time ago just changed a new company, and then see the project code with the database read and write separation of the architecture, and then curiosity stripped the code to see the next, overall is the use of spring AOP facets to achieve . See
When using MySQL, we sometimes encounter such an error: "Deadlock found when trying to get lock; Try restarting transaction ".In 14.5.5.3 how to Minimize and Handle deadlocks There is such a sentence:
Deadlocks is not dangerous. Just try
Toss a half a day finally to install and configure MySQL, the following are the installation steps and problems encountered the solution1. Check if MySQL or its related items are installed on the machine# Yum List Installed | grep MySQLIf installed,
Database Storage EngineTo set the default storage engine:vim /etc/my.conf[mysqld]default_storage_engine= InnoDB;To view the storage engines supported by MySQL:show engines;To view the current default storage engine:show variables like
The use of jar packages, and the division of LayersC3p0-config.xml The default configuration, if not specified, is the most common recommendation for using this configuration default configuration at the very beginning. It's okay to put it anywhere
The following table lists the most important built-in date functions in MySQL:
function
Description
Now ()
Returns the current date and time
Curdate ()
Returns the current date
Title, the user table below the mysql5.7 MySQL library does not have a password field to modify the password.Version 5.7 is no longer using password as the field of the password and changed to Authentication_stringLogin password cannot be remembered:
17.1 MySQL Master-slave introduction18.The main application scenario1. Data backup2. Use as a read library to reduce the pressure on the main library17.2 preparatory workWill master and slave both start the MySQL service, linux-01 as the main
Recent work in the Python language development project, the work encountered a python connection to MySQL like query.Because% has three special symbols in Python, such as%s. %d represents string placeholders and number placeholders, respectively.You
Directory: one, master-slave synchronizationSecond, data read and write separationThird, MySQL optimizationOne, MySQL master-slave synchronization.1.1 What is master-slave synchronization1.2 How master-Slave synchronization works1.3 Configuring
Data add and delete change to insert data1. 插入完整数据(顺序插入) 语法一: INSERT INTO 表名(字段1,字段2,字段3…字段n) VALUES(值1,值2,值3…值n); 语法二: INSERT INTO 表名 VALUES (值1,值2,值3…值n);2. 指定字段插入数据 语法: INSERT INTO 表名(字段1,字段2,字段3…) VALUES (值1,值2,值3…);3. 插入多条记录
Translation: SET Variable (submitted to the MariaDB official Manual), variablemariadb
This article is the official mariadb Manual: the translation of SET Variable.
Original article: https://mariadb.com/kb/en/set-variable/Https://mariadb.com/kb/zh-cn/
Mysql user authorization, database permission management, SQL syntax details, mysql permission management
Mysql user authorization, database permission management, and SQL syntax-NiceCui
1. Authorize the primary SQL // ALL permissions of a
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