MYSQL date_format and STR_TO_DATE

The date_format and STR_TO_DATE of MYSQL are recently used in the project. Have a good time with the MYSQL date conversion function. The process is as follows: Take the current year: SELECT DATE_FORMAT (CURDATE (), '% Y year'); output: SELECT

MySQL connection Timeout: Automatic disconnection

MySQL connection timeout automatic disconnection Problem description: when using mybatis2.3.5 for application implementation, the program reports the following error: com. mysql. jdbc. exceptions. jdbc4.CommunicationsException: The last packet

Use LIKE and regular expressions in mysql

In mysql, LIKE is used. Regular LIKE % indicates any occurrence of any character (except NULL) (0 -- infinite ). Note the case sensitivity. _ Indicates that any character appears in the regular expression 1 (not many or less) ^ $. (match any single

DATE_SUB (NOW (), INTERVAL 5 MINUTE) and DATE_FORMAT (DATE_SUB (NOW ()

DATE_SUB (NOW (), INTERVAL 5 MINUTE) and DATE_FORMAT (DATE_SUB (NOW (), INTERVAL 5 MINUTE), '% Y-% m-% d % H: % M: % s') [SQL] [root @ CactiEZ ~] # Time mysql-h 172.22.10.32-ucacti-P3316-pcacti-e "select count (*) from order. tbl_tieyou_order where

MYSQL: comma-separated string tables, which are broken down into vertical tables.

MYSQL: comma-separated string tables, which are broken down into vertical tables. [SQL] drop temporary table if exists Temp_Num; create temporary table Temp_Num (xh int primary key); -- CREATE a Number Auxiliary table set @ I = 0; INSERT INTO

MySQL SELECT LIMIT

MySQL select limit specifies the number of rows to query MySQL, which is the most widely used database. It is known for its lightweight, open-source, and efficient nature. Once a product owned by SUN, as SUN was acquired by Oracle, MySQL was also

Notes on restoring mysql Data

Mysql data recovery function notes many children's shoes have used the mysqldump and source functions when backing up and restoring the database. However, I feel that the operation is rather inconvenient. I cannot see all operations on the database

Solutions to Mysql data rollback errors

The following describes how to solve the Mysql data rollback error. You can refer to the following two methods for MYSQL transaction processing. 1. Use begin, rollback, and commit to start a transaction rollback transaction to roll back the commit

Functions and keywords used By MySQL advanced query and Group By collection

Functions and keywords used By MySQL advanced query and Group By set: 1 GROUP_CONCAT mysql> SELECT student_name, -> GROUP_CONCAT(test_score) -> FROM student -> GROUP BY student_name;Or:mysql> SELECT student_name, -> GROUP_

MySQL review notes II

MySQL review notes II 1. Set the password for the root administrator account. Generally, the default password for MySQL is null. If you have not set the root password before, use the mysqladmin command, you can use the following mysqladmin command

Sort out common mysql monitoring scripts

Sort out common mysql monitoring scripts 01 #! /Bin/sh02 # filename: mysql_monitor.sh03 # site: www. jbxue. com04 # Check whether mysql server provides services normally 05 mysqladmin-u sky-ppwd-h localhost ping0607 # obtain the current mysql Status

Modify the mysql data storage address

Step 1: Change the address of the mysql data storage to the default path/var/lib/mysql/, and change it to/data/mysql/data. mysql> show variables like '%dir%';+-----------------------------------------+----------------------------+| Variable_name

Mysql-merge table

Mysql-merge table [SQL] Note: 1 the structure of each sub-table must be consistent, and the structure of the master table and sub-table must be consistent, 2. The index of each sub-table exists in the merge table. Therefore, you cannot perform a

Method for modifying the max_allowed_packet attribute of MySQL 5.5

To modify the max_allowed_packet attribute of MySQL 5.5, the following error is reported when an experiment system is deployed: your 'max _ allowed_packet 'variable is set to less than 16777216 Byte (16 MB ). it is easy to understand, that is, you

Install MYSQL5.6.10 on OEL6.3

OEL6.3 install MYSQL5.6.10 1.yum install gcc * c ++ * autoconf automake zlib * libxml * ncurses-devel libmcrypt * libtool-ltdl-devel * library file required for installing the system 2. install the cmake tool. Yum install cmake * 3. A warning

Mysql operator (job)

Mysql operator (job) Create Table tmp15, including varchar type field note and int type field price, use the operator to calculate different fields in the table; use logical operators to perform logical operations on data; mysql> create table tmp15 (

MYSQL deadlock search

How can I solve the deadlock issue in MYSQL? Find the original lock ID and KILL the thread that has been held all the time. But how can we find the thread ID that causes the deadlock among many threads? MySQL has been very powerful since its

Show processlist result Filtering

Show processlist result filtering in MySQL the show variables where variable_name like '% auto %' statement can be executed normally, but the show processlist where host like '% 100' error will be reported: error Code: 1064You have an error in your

Shell preliminary: mysql regularly dumps local data every day to replace remote database data

Shell preliminary: mysql regularly resends local data every day and replaces remote database data 01mysql regularly resends local data every day, to replace the remote database data 02, You need to import the tb_a table in the ser_a database on 192.1

MYSQL stored procedure Result consisted of more than one r... solved

MYSQL stored procedure Result consisted of more than one r... Abstract: MYSQL Stored Procedure error SELECT... INTO... This SELECT syntax stores the selected columns directly to variables. Therefore, only a single row can be retrieved. Note that

Total Pages: 3233 1 .... 2811 2812 2813 2814 2815 .... 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.