MySQL Common skills sharing

One, MySQL queries the five seed sentence:1,where (conditional query), commonly used operators:① comparison Operators>, =, ② logical operatorsLogical non: NOT/! , logical OR: OR/| | , logic with: and/&&③ fuzzy query "like"Wildcard:% any character,

MySQL String function usage tips

1. Intercept string from leftLeft (str, length)Description: Left (truncated field, intercept length)Example: Select Left (content,200) as abstract from my_content_t2, starting from the right to intercept the stringRight (str, length)Description:

JDBC Pure Drive mode connection MySQL

1 Create a new Java Project named Mysqldemo2 Download the latest driver package from http://dev.mysql.com/downloads/connector/j/.Here are the. tar.gz and. zip Two-format packages, because they can be decompressed under Windows, either way.3 after

MySQL gets the time before and after the current date

Selectsubdate (Curdate (), Date_format (Curdate (), '%w ')-1)//Get current date in the Monday of the weekSelectsubdate (Curdate (), Date_format (Curdate (), '%w ')-7)//Get current date on Sunday of the weekThese two sentences are a method that MySQL

MySQL terminology--basedir and--ledir differences

· --basedir=paththe path to the MySQL installation directory. --core-file-size=sizemysqld the size of the kernel file that can be created. The option value is passed to Ulimit-c. --datadir=paththe path to the data directory.

MySQL floating-point type and fixed-point number type

In MySQL, floating-point numbers and fixed-points are used to represent decimals, and floating-point numbers include single-precision floating-point types (float) and double-precision floating-point types (double), with a fixed-point number of only

MySQL 5.7.17 completely uninstall method prevent forget finishing

Then delete the My.ini file and all files under the MySQL folderRun the "regedit" file, open the registryDelete Hkey_local_machine\system\controlset001\services\eventlog\application\mysql folderDelete the

MySQL Design Specification (cont.)

1.1    database field Design specificationprioritize the smallest data types that meet storage needs :The non-negative data is stored by the unsigned integer type;varchar (N) in N represents the number of characters, not the number of bytes ( Oracle

centos7-mysql-binlog-bump-Backup Restore

MySQL backup is generally a full-library backup +binlog log Incremental backupperform a full library in a few days, and perform an incremental backup several hours a day.Binlog LogThis binary log file records all of the database additions and

MySQL parameter file and parameter modification method

MySQL parameter file: MySQL database initialization parameters are set by the parameter file, and if no parameter file is set, MySQL starts with the default values of the parameters in the system.On Windows and Linux, parameter files can be placed

Yum install and set up MySQL

Essentially, you set up a Yum source, and then Yum installs it.However, there are two ways to add a Yum source, one is to create a new/etc/yum.repos.d/mysql-community.repo, and the other is to install the Yum source using the RPM package provided by

MySQL vs. two table consistency

--A and B two table data is consistentSelect CustomFrom A left join B on a.id = b.IDwhere b.id is nullNote: The result of this query is that there is data in table A and no in table BSelect CustomFrom B left join A on a.id = b.IDwhere a.id is

Newly installed MySQL database login not up (account password is correct)

Open & Edit/etc/my.cnf Add skip-grant-tables under[mysqld] Restart Mysql You should is able to login to MySQL now using the below commandmysql -u root -p Runmysql> flush privileges; Set New Password byALTER USER ‘root‘@‘localhost‘

Zabbix monitoring MySQL master-slave status

1. Zabbix Client Editing Script/tmp/shell/mysql_slave_status.sh#! /bin/bash/usr/bin/mysql-p123456-e ' show slave status \g; ' | Grep-e "Slave_io_running| Slave_sql_running "|awk ' {print $} ' |grep-c" yes "2. Granting of executive authoritychmod +x

Research on high Availability scheme of MySQL database

MySQL as the most critical application data storage Center, how to ensure the reliability and continuity of MySQL service, we have to carefully consider a problem. When Master goes down, how do we ensure that the data is not lost as much as possible,

I often talk about the usage of MYSQL pattern matching REGEXP and like, mysqlregexp

I often talk about the usage of MYSQL pattern matching REGEXP and like, mysqlregexp Like LikeThe whole data must be matched, while REGEXP only needs to be partially matched.That is to say, to use Like, all content of this field must meet the

Ultra-simple qps statistical methods (recommended) and qps statistical methods

Ultra-simple qps statistical methods (recommended) and qps statistical methods Calculate the QPS value in the last N seconds (including the select and insert values per second) Mysql> select variable_name, sum (per_sec) as qps from (select

Detailed description of Mysql master-slave synchronization configuration practices, detailed description of mysql master-slave practices

Detailed description of Mysql master-slave synchronization configuration practices, detailed description of mysql master-slave practices 1. Introduction I have written an article about the principle of Mysql master-slave synchronization. I believe

How to set the number of mysql connections (Too connections) and mysqlconnections

How to set the number of mysql connections (Too connections) and mysqlconnections When using mysql, it is found that the number of connections has exceeded ~~~~ [Root @ linux-node1 ~] # Mysql-u glance-h 192.168.1.17-p Enter password: ERROR 1040 (0800

Sphinx installation, sphinx

Sphinx installation, sphinxFirst, download a linux installation package from coreseek on your linux. Because the installation package does not exist on the official website, I have downloaded it from other channels. To open linux, first install the

Total Pages: 3233 1 .... 1042 1043 1044 1045 1046 .... 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.