MySQL

To solve the case sensitivity problem of mysql databases, a small problem occurred when deploying a java project to a linux server today. The database is mysql and the project is on my local computer (in windows) no problem.Error message: 00:01:29, 3

Install mysql5.5 on a linux server. The installation procedure is as follows: 1. create a mysql user group and user groupadd mysqluseradd-r-g mysql 2. download mysql, unzip and connect to mysql with a symbol, the latest can go to the

Frequently Used mysql performance indicator 1, obtain the total number of processes under a mysql user ps-ef | awk '{print $1}' | grep "mysql" | grep-v "grep" | wc-1 2, host performance status # uptime [root @ ~] # Uptime 13:05:52 up 53 days, 52 min,

Mysql date comparison statement select * from student where '2017-02-27 00:00:00 ' created_date select * from student where UNIX_TIMESTAMP ('2017-2012- 02-27 00:00:00 ') UNIX_TIMESTAMP (created_date); www.2cto.com SELECT * FROM student WHERE

Install mysql 5.1.33. An error occurs in the third Start Service in the Execute strongattion step when the Server Instance Configuration wizard is running, the error message "cocould not start the service MySQL" is displayed. (This is generally

Difference between count () and sum () in Mysql. First, CREATE a TABLE. The problem is: create table 'result' ('name' varchar (20) default NULL, 'subobject' varchar (20) default NULL, 'score 'tinyint (4) default NULL) ENGINE = MyISAM default charset

Mysql time conversion statement mysql> select UNIX_TIMESTAMP ();-> 882226357 mysql> select UNIX_TIMESTAMP ('2017-10-04 22:23:00 ');-> 1997 when UNIX_TIMESTAMP is used for a TIMESTAMP column, the function will directly accept the value without the

In mysql, The enum and set types in mysql are both string type and can only be set in the specified set. The difference is that set can take multiple values, enum can only take one SQL code CREATE TABLE '192 _ t' ('id' int (11) NOT NULL

Solution for "ERROR 1418" when creating a function in Mysql: ERROR 1418 (HY000): This function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its declaration and binary logging is enabled (you * might * want to use the less safe

Mysql startup service error solution the following error message is displayed when mysql service is started (MySQL service cannot be started): mysql service cannot be started on the local computer. Error 1067: Unexpected Process Termination.

The mysql authorization table in windows and Linux is in Windows. After mysql is installed, you do not need to create a data directory and authorization table. A set of pre-initialized account authorization tables exist in the MySQL database under

A solution for mysql to delete duplicate data from a Table: www.2cto.com Create TABLE: CREATE Table 'TT' ('id' int (11) default null, 'name' varchar (30) default null) ENGINE = InnoDB default charset = utf8 2 million data 1 million id from 1 to 100

Mysql database index creation rules 1. The primary key and foreign key of the table must have an index; www.2cto.com 2. the table with more than 300 of the data volume should have an index; 3. The table that is frequently connected to other tables,

The method for allocating the unique player ID in the region. In Mysql, in addition to using the auto_increment field as the auto-incrementing serial number, there is another way to provideThe unique sequence number. One table can satisfy the

Method for allocating a unique player ID in a region (continued) Links: Method for allocating a unique player ID in a region http://www.bkjia.com/database/201212/173832.html In the past, due to the rush of time, the only ID generated in the region

When you cancel an alarm when an error occurs when you enter a command in MySQL and connect to MySQL, you can add the-B parameter to cancel the alarm when an error occurs during SQL command execution, for example: www.2cto.com mysql-h127.0.0.1-uroot-

Mysql transfers data from one table to another. Stored PROCEDURE: DELIMITER $ www.2cto.com USE 'ms' $ drop procedure if exists 'sendsmsprocs '$ create definer = 'root' @ 'localhost 'processed' sendSmsProcs '(numberArrayId CHAR (32 ), longSmsId CHAR (

Mysql storage engine [Reading Notes 2] storage engine (reference): it refers to how to store data, how to create indexes for stored data, and how to update and query data. Because in relational databases, data is stored as tables, the storage engine

Step 8: basic operations for databases and tables http://www.bkjia.com/database/201212/173868.htmlMYSQL Entry 2: Search Using Regular Expressions http://www.bkjia.com/database/201212/173869.htmlMYSQL Entry 3: Full Text Search

Description of the return value of the explain SQL statement performance test: www.2cto.com SQL code mysql> Explain SELECT 'content _ id', 'content _ old_id ', 'content _ hasimg ', 'content _ time_update ', 'content _ title_long', 'vhost _ content '.