RDS (NetEase Cloud Relational database service) has been on the line for some time, successive products have moved into the RDS, online operation and maintenance of the process, but also encountered some did not consider, or consider the incomplete
My personal practice is: phpMyAdmin export utf-8 insert mode Abc.sql
FTP Abc.sql to Server
SSH to Server
Mysql-u abc-p use KKK (database name, if not on CREATE database KKK) set names ' UTF8 ' source abc.sql
Note: I see set character set UTF8;
LOCATE (SUBSTR,STR)
POSITION (substr in str)
Returns the position of the substring substr the first occurrence in string str. If substring substr does not exist in STR, the return value is 0:
mysql> SELECT LOCATE (' Bar ', ' Foobarbar ');
-> 4
mysql>
These problems can result in changes in data values. In general, the above problem may occur if you use a non binary string data type, such as char,varchar,text data types.
Aes_encrypt () and Aes_decrypt ()
Aes_encrypt () and Aes_decrypt
1. View configuration file:
Skip-networking #注释掉 because it's shielding everything. TCP/IP connection
bind-address = 127.0.0.1 #它和上一个选项是异曲同工, if you want to connect remotely, you have to comment out
2. If the above work has been done or
Date_add (date, INTERVAL expr type) date_sub (date, INTERVAL expr type )
These functions perform date operations. Date is a DATETIME or date value that specifies the starting time. expr is an expression that specifies the value of a time
Copy Code code as follows:
#!/bin/sh
#code by Scpman
#功能: Review and repair MySQL database tables
#将此脚本加到定时中, when the script executes, it reads the library, lists all the tables to be repaired, and then timings to start the repair
Since he and he are the same team, so I am very familiar with his "neat" approach, for his many points of view I also very much agree; but there is a very incomprehensible place is the design of the database will always avoid the use of date/time
This article has shared two kinds of MySQL to delete the database method, for everybody's reference, the concrete content is as follows
The first method: To Delete a database using mysqladmin to log on to the MySQL server using a regular user, you
Installation Environment
CentOS 5.4
MySQL 5.1.xx with rpm direct installation
Xtrabackup 1.2.22 with RPM direct installation
Copy Code code as follows:
[Mysqld]
Server-id = 1
Log-bin
Innodb_flush_log_at_trx_commit=1
Myiasm is a new version of the Iasm table, with the following extensions:
Portability of the binary hierarchy.
The null column index.
Fewer fragments are available for variable-length rows than for ISAM tables.
Support for large files.
Better index
This requires the user's permissions to be modified in MySQL to grant the required permissions.
This article will demonstrate this situation and give detailed troubleshooting steps.
The examples in this article are configured as follows:
MYSQL This database is definitely suitable for the DBA class to play, and generally do a little 10,000 news of small system how to write can, with the XX framework can achieve rapid development. But the data volume to 100,000, million to tens of
For example, let's take a look at the difference between a clustered index and a nonclustered index:
In fact, the text of our Chinese dictionary is itself a clustered index. For example, if we look at the word "Ann", we will naturally open the first
As a result of changing the computer or reinstall the system often need to rebuild the PHP environment, this simple record of Windows to build a PHP environment process, the specific steps can refer to online data
Preparatory work:
Windows
Problems that occur (multiple-master self-growth ID duplicates)
1: First we pass the test table structure of A,B
2: Off A, in B on the data table test (there is a self-growth ID) to perform an insert operation, return the insertion ID of 1
3: After
A. mysql command line mode settings
Desktop-> My Computer-> properties-> environment variable-> new->Path= "; path\mysql\bin;" Where path is the installation path for MySQL.
Second, the command line to enter the MySQL method
1.c:\>mysql-h
Error 1:wizard installation Last page, cannot create Windows service for mysql.error:0 ErrorWORKAROUND: Open the command line to enter SC delete mysql command thatC:>SC Delete MySQL[SC] DeleteService SUCCESSReboot the computer, or reboot and
To randomly extract a record from the TableName table, the general wording is: SELECT * from TableName ORDER by RAND () LIMIT 1.
But then I looked up the official MySQL manual, and the hint for rand () probably meant that the rand () function could
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