Use the REGEXP keyword
1. Basic Character matching
?
1 2 3
SELECT prod_name From Products Where prod_name REGEXP '. 000'
Difference between LIKE and REGEXP
LIKE matches this column, while REGEXP matches the column
Enter the following in dos mode:
1. cd C: \ Program Files \ MySQL Server 5.5 \ bin
2. mysql-h127.0.0.1 (address of the host you want to access)-uroot (User Name)-proot (password)
3. show variables like 'character % ';
You can view the mysql
MYSQL was used in a recent project, because I had done it before, so I didn't think much about it. I just finished the next step. On the official website, I decided to launch an installer (5.26), modified the default location and configuration,
I was still very comfortable with the development in linux. I continued to record the problems in mysql.
The root (localhost) password of mysql cannot be logged in according to the online tutorial yesterday, and the User = ''is also deleted
The following describes the usage of fuzzy search in mysql:1, %: represents any 0 or multiple characters. It can match any type and length of characters. In some cases, if it is Chinese, use two percent signs (%.For example, SELECT * FROM [user]
1. decompress the ZIP package and Configuration
First, extract mysql-5.5.25-winx64.zip to the d:/mysql-5.5.25 directory, and then according to the relevant information on the Internet, the my-large.ini (of course, you can also select another ini
You can briefly describe the actual situation of the apsaradb for Redis platform.
2200 + 500 billion commands/day 50 billion Read/day Write/day
18 TB + Memory
500 + Servers in 6 IDC 2000 + instances
It should be a big Redis platform at home and
This is the second article in the series. In the first article, I used the built-in SSL support of MySQL for stress testing, which produced some surprising results. Of course, it is expected that the throughput performance of queries using SSL is
Http://hi.baidu.com/luck001221/item/cb4462299f9ea79ab73263d2? Qq-pf-to = pcqq. group
1. Go to the mysql official website to download an odbc driver. Because MSsql has never been integrated with the mysql driver, this tool needs to be downloaded
Recently, I was suddenly very interested in MySQL connections. According to the thread keyword, I can find the following status:
show global status Variable_name Value Threads_cached Threads_connected Threads_created
Tool raw materials:
Mysql-5.0.37-win32
Network Disk: http://pan.baidu.com/s/1bnjCfTlInstallation Process
Run the installer. Next Step
Select "Custom" for Custom installation. Next Step
Here you can delete unnecessary installation, you can change
Assume that there are host A and host B (Linux system). The IP address of host A is 1.2.3.4 (of course, it can also be dynamic), and the IP address of host B is 5.6.7.8. Both hosts are installed with PHP + Mysql. Now we are operating on the data on
How can I query the size of each table in the MySQL database?
MySQL has a database named information_schema, which has a TABLES Table. The main fields of this table are:
TABLE_SCHEMA: Database NameTABLE_NAME: Table NameENGINE: The storage ENGINE
/* -- Bcp-Import and Export of binary files
Supports import/export of image, text, and ntext Fields
Image is suitable for binary files; text and ntext are suitable for text data files.
Note: during import, all rows meeting the conditions will be
When the table is modified,
Message 5074, level 16, state 1, 2nd rows
The object 'df _ ddczjlb_m1_ddczj1_5bba8402 'depends on the column 'ddczjlb _ GROUPID '.
Message 4922, level 16, status 9, 2nd rows
Alter table alter column DDCZJLB_GROUPID
The first database INFORMATION_SCHEMA: provides a way to access database metadata.
Metadata is data about data, such as database name or table name, column data type, or access permission. In some cases, other terms used to express this information
Today I am studying a framework. When the database uses mysql to start the mysql service, the error 1058 is reported, for example. I tried the same solution after searching for the Internet for a long time. I tried it again and it didn't work (it
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