The parameters passed through queryMap of valuelist are of the string type by default. In hql of the valuelist configuration file, an error is returned if this value is directly assigned to an integer field. We generally use transformation functions
In the development process, you sometimes need to remotely connect to and manage the MYSQL database on another machine. in the implementation process, you may encounter a series of problems, now, we use remote access to mysql data installed on
1. view the mysql database sizeSELECT sum (DATA_LENGTH) + sum (INDEX_LENGTH)FROM information_schema.TABLES where TABLE_SCHEMA = 'database name ';The result is in bytes. Except 1024 for K, except 1048576 (= 1024*1024) for M.
2. view the last mysql
There is a statistical requirement that requires IP address classification statistics. Mysql providesInet_aton () and inet_ntoa ()Function process processing.YesView official manual.
INET_ATON (expr)Returns an integer that represents the network
Let's take a look at the table structure of arena_match_index. Pay attention to the index structure of the table.Copy codeThe Code is as follows:Create table 'arena _ match_index '('Tid' int (10) unsigned not null default '0 ','Mid 'int (10)
The mysql password has expired. Today, when I encounter a connection to mysql, the connection is always unavailable,Error 1:An attempt by a client to checkout a Connection has timed outThe connection timeout error occurs for the first time. The
When creating a table, we will inevitably consider the problem of weeks. Therefore, the table will be modified later.
The alter table statement is required to modify a table.
Modify Table NameCopy codeThe Code is as follows:Mysql> alter table
The front-end time is related to a DB project. alanc reports a query. Using indexes is much slower than not using indexes. So I followed up and used explain to look at two different query results.The results of queries without indexes are as follows.
1. The WHERE clause query condition contains a non-equal sign (WHERE column! =...), MYSQL will not be able to use the index2. Similarly, if the WHERE clause uses a function (for example, where day (column) =...) in the query condition, MYSQL will
This article briefly describes the full-text index application example, MYSQL demo version 5.5.24.Q: When is full-text index applicable?A: Full-text indexing is currently A key technology for big data search.For more details, refer to Baidu.---------
Each data access uses its own communication protocol, including calling different interfaces and passing parameters. The information in different databases should be used in the same program. Normally, different database connection methods should be
View version information#1 Enter mysql in command line mode and you will see the initial prompt Your MySQL connection id is 3Server version: 5.1.69 Source distribution#2 You can see the status in the command line. Copy codeThe Code is as
Example:
A field (purview) in the user table represents the permission of the user.
Store all user permission IDs in this field. For example, you have five permissions: 1, 2, 3, 4, and 5.
Find which users have the permission id 1Copy codeThe Code
The php. ini file does not have the parameter configured correctly.
Solution:
(1) Open the php. ini file and find:
Extension_dir = "./"
Change it;
Extension_dir = "X: \ PHP \ ext" (php Extension Program directory)
(2) find Windows Extensions
Edit the my. cnf or my. ini file and remove the comments of the following lines of code:Copy codeThe Code is as follows:Log_slow_queries =/var/log/mysql/mysql-slow.log.Long_query_time = 2Log-queries-not-using-indexes This will record slow queries
1. automatically delete temporary files at every day
First, check the crontab task list:Crontab-lThen create:Crontab-eAdd a row:00 03 *** rm-rf/www/cmstest/my120/public/scripts/jpgraph /*Save and exit.Restart the service:/etc/rc. d/init. d/crond
ACID: Atomic, Consistent, Isolated, DurableA storage program provides an excellent mechanism to define, encapsulate, and manage transactions.1. MySQL transaction support 1) MySQL transaction support is not bound to the MySQL server itself, but
1. To test the trigger and stored procedure, first create a simple table:Copy codeThe Code is as follows:Create table 'airuser '('Userid' int (11) not null AUTO_INCREMENT,'Username' varchar (128) not null,Primary key ('userid ')) ENGINE = InnoDB
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