MySQL

In MySQL's master-slave environment, we were able to view some of slave's state information by running show slave status on Slave, which has a more significant number of seconds_behind_master. So do you know what it really means and how it's

Version Glassfish-4.0.zip1, unzip, copy to the specified installation pathUnzip Glassfish-4.0.zip CP CP glassfish4/usr/local/-RF2. set glassfish environment variableVim/etc/profileexport glassfish_home=/usr/local/glassfish4export path=.: $PATH:

This function is a very useful function, for example, we can use in many-to-many association tables for batch queries.For example, students and teachers are many-to-many relationships, if we want to query the specific teachers of some of the

master database: MasterFrom database: SlaveObjective: To replicate the data from master to the slave databasePrinciple: The approximate process is slave by copying the Bin-log log file above the master to local, and then resolving it to an

In a SELECT statement query, you can make a judgment that is similar to if else by using case when to query the results. The specific usage 1. SELECT a.website_id, B.customer_name, A.website_enddate, C.member_name, d.websitetype_id,CaseWhen

SELECT a.pid,a.id from ' user ' as B, ' reward ' as a WHERE b.id=4 and a.pid = B.pid;The execution of the above statement is an error: illegal mix of collations (ucs2_general_ci,implicit) and (utf8_general_ci,implicit) for operation 'Solution: Add

1. Installation (1) See if the installation Yum List installed mysql* (2) View existing installation packages Yum List mysql* (3) Install MySQL server side Yum Install Mysql-dev Yum

#现有环境是一主一从, you need to add another one from the library, as follows:Synchronizing the test databaseMaster: 192.168.3.203From 1:192.168.3.210From 2:192.168.3.2111. Set up accounts for 210 and 211 on primary server 203.Mysql-uroot-p123Grant

MySQL common optimization points for optimized point SQLJune 8, 2014 DBA released reply # #################################################### Index related# ###################################################1. Query (or update, delete, can be

1. First to load the Java MySQL driver, add the downloaded Mysql-connect-bin-java.jar package to the project2. Then through class.forname ("Com.mysql.jdbc.Driver"); Load MySQL data-driven 3. Through the getconnection URL mode to connect the

One of the most powerful features of joining SQL is the ability to join tables in the execution of data retrieval queries. The junction table is based on the relational table. Understanding the relationship table is as follows, if a variety of goods

First, modify the user passwordFormat (input at command line): Mysqladmin-u User Name----old password password new password1. Add a password to root Ab12:mysqladmin-uroot-password ab122. Change the root password to djg345:mysqladmin-uroot-pab12

Mysql> GRANT All privileges on * * to ' monty ' @ ' localhost '- identified by ' Some_pass ' with GRANT OPTION;Mysql> GRANT All privileges on * * to ' monty ' @ '% '- identified by ' Some_pass ' with GRANT OPTION;Mysql> GRANT reload,process on * *

Three levels:1. System level2.mysql Configuration Parameters3.sql Statement Optimization===========================================================One. System level===========================================================Two. MySQL parameter

1. View the Database engineGlobally, show engines;2. View the Database engineShow variables like '%engine% ';Or Show create TABLE Xxx\gwill show the default search engine3. Modify the database default engine, in the configuration fileDefault-storage-

1. Through the ADO connection (in the database connection string for the Chinese seems to be unable to use)Need to add MySql.Data.dll (available by installing Mysql-connector-net-6.8.3.mis)Reference MySql.Data.dllInvocation modeString

The test results show that the performance of the system can be significantly improved by separating the database from the reading and writing in the high-load production environment. The following is a read- write separation of MySQL.Test

A paging program is typically composed of two sql:SELECT COUNT (*) from ... WHERE ....SELECT ... From ... WHERE LIMIT ...If you use Sql_calc_found_rows, a SQL will do the following:SELECT sql_calc_found_rows ... From ... WHERE LIMIT ...After the

Reference: http://database.51cto.com/art/200905/124240.htmThe timestamp column is displayed in the same format as the datetime column. In other words, the display width is fixed at 19 characters, and the format is Yyyy-mm-dd

Use Python's mysqldb library to connect to the local MySQL database with the following error:File "/usr/lib/python2.7/dist-packages/mysqldb/__init__.py", line Bayi, in ConnectReturn Connection (*args, **kwargs)File