MySQL

Reprint Please specify source: http://blog.csdn.net/l1028386804/article/details/46763767In the MySQL database, there are mysql_install_db scripts to initialize the permissions table, and the tables that store the permissions are:1. User table2. DB

Many people have the database design paradigm as the database table structure of the "bible", that as long as the requirements of this paradigm design, you can make the design of the table structure is sufficient to optimize, not only to ensure

Because MySQL database additions and deletions suddenly burst, need to query is the operation of those tables is particularly frequent, wrote a tool to analyze Bin-log, find and add and change the table, and the number of operations in descending

Password problem handling during installationA RANDOM PASSWORD have BEEN SET for the MySQL root USER!You'll find that password in '/root/.mysql_secret '.Vi/root/.mysql_secretMysql-uroot-p Random PasswordUPDATE user SET Password=password (") where

After doing the data migration, it is found that Japanese data is garbled through UI, and it is normal to modify Japanese directly through the UI.After checking the information, the MySQL character set functions as follows:MySQL Character set

Due to the project requirements, the low version of MySQL does not meet our needs in performance, and now needs to be replaced with a higher version of MySQL 5.5.44. New version of MySQL 5.5.44 in performance, compared to the CentOS 5.11 comes with

A MySQL (5.5 version) sets multiple ports to run multiple instances. Have a day, finally fix, first forget!First, set Mysqld_multiDuplicate a copy of the MY.CNF and rename it to MY_MULTI.CNFTo modify the MY_MULTI.CNF, the main configuration items

1. Forget the root passwordHttp://www.lishiming.net/thread-252-1-1.htmlGo to MySQLwhich MySQL/usr/local/mysql/bin/mysql You can open MySQL like this before you set a passwordLogin/usr/local/mysql/bin/mysql-uroot-p123456If you forget the root

/* Get system Organizational structure* Includes user name, user ID, store name, store ID, creation time ...*/CREATE VIEW Organizationtableview as select Id,storename,regdate from V9_qd_account;/* Get CPZ installation data for the day (aggregated by

Let's start with the code.SELECT ' notice '. ' id ', ' notice '. ' FID ', ' notice '. ' Has_read ', ' notice '. ' Notice_time ', ' notice '. ' Read_time ', ' f '. ' Fnum ', ' F '. ' forg ', ' f '. ' Fdst ', ' f '. ' actual_parking ' as ' parking ', '

Ysqladmin-uroot password ' Xutaibao ' Set passwordMySQL LoginMysql-uroot-h192.168.3.88-p3306-ppasswordForgot Password:vi/etc/my.conf Join Skip-grantLogin MySQL No password required at this timeUse MySQLUpdate user set Password=password ('

It should be noted that the operation should remember the end of the semicolonIf you forget to enter a semicolon you can use \c to end the command inputCommon operations are the following table:1 The Mysql.exe in the bin directory under the MySQL

[email protected]>Select * from dept1; DEPTNO dname LOC---------- -------------- ------------- Ten ACCOUNTING NEW YORK - the DALLAS - SALES CHICAGO - OPERATIONS BOSTON - DBA

Build the Environment:Linux:centos 6.6 (Final) x64apache:2.2.15mysql:5.1.52php:5.3.2Step Description:1.MySQL# yum Install MySQL Mysql-server# chkconfig--levels 235 mysqld on # MySQL can start automatically with the system#/etc/init.d/mysqld Start#

Because the MySQL database is completely password-protected during the reset of the root password of MySQLStatus, other users can also log in and modify MySQL information arbitrarily. MySQL can be used toand stop Apache and all user processes to

Delete duplicate rows1 DELETE fromecm_member_login_session2 WHERE( Number, Client_code)inch (3 SELECT Number, Client_code fromMall.ecm_member_login_sessionGROUP by Number, Client_code having COUNT(*)> 1) 4 andUpdate_time not inch (5

Lin Bingwen Evankaka Original works. Reprint please specify the source Http://blog.csdn.net/evankakaThis article explains in detail the use of the ALTER command in MySQL syntax, which is a much more useful syntax, and the functionality is very

The following error occurred while accessing MySQL in the virtual machine:Cause: The MySQL user does not allow remote loginsResolution: Authorization1> allows users to connect to MySQL server from any hostGRANT All Privileges on *. * to '

In MySQL, a table of the InnoDB engine type supports foreign key constraints. [CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...) REFERENCES tbl_name (index_col_name, ...) [on DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION | SET

An index is a particular sort of algorithm for a particular MySQL field, such as a two-tree algorithm and a hashing algorithm, which is created by creating eigenvalues and then quickly finding them based on eigenvalues. And the most used, and is the