MySQL

Knowledge keywords: DATE_FORMAT select DATE_FORMAT (create_time, '% Y % U') weeks, count (caseid) count from tc_case group by weeks; select DATE_FORMAT (create_time, '% Y % m % D') days, count (caseid) count from tc_case group by days; select

There is a table with relatively large data, and you need to DELETE the association. When you DELETE the table, you will find the following SQL error: DELETE FROM test. test1 a where exists (SELECT 1 FROM test. test2 B WHERE. recordID = B. smsInfoID

During maintenance, one day a customer sent me a website saying that the connection could not be reached. Then I checked that the database was too high, it is normal to delete some data, but it is also possible to delete some data without

Mysql cannot be connected from the client to the server. The company uses Mysql for a test and starts to build a local Mysql database and connect it to it. No connection failure has been encountered.When the database is on the server, the connection

The substring_index function of MySQL assumes that there is a table in which a field is saved by email. Then, I want to count the proportion of each mailbox. We know that the email address format is account @ domain. To achieve the above statistics,

Mysql Stored Procedure variable concatenation sometimes requires fuzzy query, but at the same time we need to use the variable during fuzzy query, we want to splice a % after the variable to match the fuzzy query, then we will use the concat

The implementation of Mysql Replication requires a small project, and the data of the three Mysql servers needs to be synchronized. After going online to query the data, the basic idea is completed. First, we have prepared three Centos6.2 servers,

Today, the same data can be found in case-insensitive input conditions when querying data. For example, if you enter aaa, aaA, or AAA to query the same results, the query conditions are case-insensitive. Because the program uses the hibernate

Mysql creates a stored procedure and function. A stored procedure is a set of SQL statements that can be stored on the server. You can use create procedure and create function on the client to CREATE a stored PROCEDURE or FUNCTION. CALL the created

1. Establish a benchmark, establish a benchmark, and establish a benchmark! If we need to make a decision, we need to talk about data. What kind of query is the worst? What are the bottlenecks? Under what circumstances will I write a bad query?

Mysql Database Import and Export and functions, stored procedures mysql commonly used export data commands: 1. mysql exports the entire database www.2cto.com mysqldump-hhostname-uusername-ppassword databasename> backupfile. SQL

The usage of Mysql order by has encountered some problems in the process of using order by today. It was found that the previous understanding of order by is incorrect. I saw the order by usage on the w3s website and thought it was to sort the

I plan to write some knowledge about database operations. Now I have finished the first article. The following describes the basic knowledge about mysql operations. In the window, start and stop the mysql service to start mysql Database net start

Basic MySQL table operations/*********************************/create table USER www.2cto.com (ID int unsigned, USERNAME varchar (10) not null, PASSWORD varchar (32) not null, GENDER tinyint, BIRTHDAY date, www.2cto.com IMAGEURL varchar (30),

Knowledge about SQL operations for MYSQL SET fields [php] 'mark' set ('index', 'best', 'hot ') , there are few people familiar with it. I have been searching for a long time. I finally got a set of knowledge points and looked at the above structure.

What are the differences between mysql char, varcher, and text? What are the differences between mysql char, varchar, and text? Let's take a look at what they have in common: both can be used to store character-type data. Both char and varchar can

Usage of MySQL files log files are located in long_query_time = 2log-slow-queries = log-error = log = C: \ log under the data DIRECTORY by default. the function of the loglog-bin = mysql-bin.index file (binary log index) is to record the absolute

You can use the MySQL command line to change the password of a MySQL database through the MySQL command line. The following describes the MySQL Command Line in detail. If you are interested, take a look. Format: mysqladmin-u username-p old password

Note: After the storage engine is modified, the proprietary features of the original storage engine will be lost. For example, if an InnoDB is converted to the MyISAM storage engine and then returned, the foreign keys originally defined in the

MySql adds and deletes fields, modifies field names, and modifies simple syntax of the field type MySql, which is commonly used but not easy to remember. Of course, these SQL syntaxes are basically common in various databases. Listed below: 1. add a