MySQL

When performing some scheduled tasks, such as monthly closing, and encountering cross-year cross-month situations, I think it is more reliable to use the SQL statement to select the time, so we can understand the function of the next time plus minus.

1. New UsersThe code is as follows:Mysql>insert into Mysql.user (Host,user,password) VALUES ("localhost", "Lionbule", Password ("hello1234"));Mysql>flush privileges;2. Modify User PasswordThe code is as follows:Mysql>update Mysql.user Set

Before beginning with senior used computer work, all kinds of do not adapt, began to re-build their habits of the environment, reinstall MySQL is one of them, and then reinstall the process encountered problems, the specific situation summarized as

Original: MySQL basic to library table operationslook at all the libraries , What do I do ?Mysql>show databases;Select a library statement : Use library nameCreate a database : Create database name [CharSet Character set ]Delete a database : drop

Here is a simple example of a MySQL stored procedure that returns the ID value of the most recently inserted record.Demiliter | Drop if exists addUser | CREATE PROCEDURE AddUser (in pname varchar (int.) begin INSERT INTO

This article mainly introduces the MySQL paging principle and the efficient MySQL paging query statement, please refer to the use of it I used to be in MySQL in the page is the limit 100000,20 this way, I believe you too, but to improve efficiency,

#!/bin/bash# Analysis of the MySQL slow log# Writen by Landline#IPadd = ' grep ' hostname '/etc/hosts | Awk-f ' End{print $ 'Ipadd= '/sbin/ifconfig eth0 |grep bcast |awk-f: ' {print $ {} ' |awk ' {print '} 'Serverday= ' date-d '-1 day ' +%y-%m-%d

Today to record a bit, every time to go online search method, every time is hard to findWhen MySQL updates some fields ' data, it is sometimes updated according to the data of other tables, it is necessary to update different values for different

Note: Transfer from CSDN zuyi532Method 1:shell> mysql-uroot-proot-h localhost xxx library-e "select * from XXX table limit 1" >> OUT.txtMethod 2:#>echo "SELECT * from XXX table Limit 1" | /usr/local/mysql/bin/mysql-h 127.0.0.1-uroot-proot XXX

1, the problem confirms: The database garbled collection is the character set problem;Check the school team rules for each character set: show character set; (see example UTF8 utf8_general_ci)To create the GBK character Set database:Create DATABASE

Original: MySQL finds field names by field annotationsSometimes the table is too many fields, just roughly remember the table comments, want to find the field name through the field comments, you can use the following statement:SELECT

Original: MySQL Advanced cursorsWhat is a cursor? The SELECT statement may fetch an n statement at a time, so the cursor can take out a record in the select one of these. Every time you take out one, move it down! Can implement very complex

1. No suitable driver found for http://127.0.0.1:3306/testJdbc_url error, JDBC walks its own protocol.The correct path should be:jdbc:mysql://127.0.0.1:3306/test.2. mysql in database, instance, session.MySQL establishes a session, not with a

Original: MySQL Advanced master-slave replicationMaster-slave replication is not more than a server! , one change, the other changes, the content is actually the same!Principle:Operation on the database will generate a file, Binlog (binary file),

Original: MySQL Advanced indexIndex : is the directory created for the data .function : can speed up the queryNegative effect : reduce the speed of adding and deleting .Principles of Index creation :1: do not over-index2: Add on the column with

Linux backs up mysql Data every day and linux backs up mysql Preface: If your database file is large, it may occupy a lot of server resources during backup, so the webmaster should try to select the minimum period of time for the visitor to

Mysql zookeeper has been transferred to oröö ~''' Ö÷ ''' öyang²» guílanguçáçorà ¨™? copyright» mööyang² ~ä±äà ² £ ¡ Antíí£° Please refer to the following link for more information: ~~%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% Æ Ä ää £

Basic mysql knowledge1. Why databases are used: (1) reducing storage data redundancy (2) higher data consistency (3) shared storage data (4) the standards that can be followed by databases (5), the ease of maintaining data integrity (6), and the

Ubuntu ° ² × ° MySQLComment» ~~añéö~ózomö~» úço ~añe° ² × ° MySQL £°Õ â ï ö÷ ª Ç suð Ð sudo netstat-tap | grep mysql à ü Á î ² é ¿'Ç çañorð MySQL µä¶ Ë ~ú£;%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% $ netstat -tap | grep mysql

Mysql searches for field names through field annotations Sometimes there are too many fields in the table, just remember the table comment. To search for the field name through the field comment, you can use the following statement: SELECT