MySQL

Extensions: Scale up, scale out.Scaling up is an extension of the server hardware, such as extending from 2 cpu,8g memory to 8 cpu,32g memory.Scaling out takes the form of a master-slave server. Master-slave replication is used for data

/*Name explanationSql_cache query Results cached (valid when query_cache_type=demand)Sql_no_cache query results are not stored in cacheQuery_cache_size indicates the size of the cacheQuery_cache_type Query Cache session type (0=off close query cache

1. Syntax1.1 New functionCreate function function_name (parameter list) returns return value type function Body(1) The function name should be a valid identifier and should not conflict with an existing keyword .(2) a function should belong to a

MySQL data type:Integer floating-point type1, bool, Boolean equivalent to tinyint (1). where true equals 1,false equals 0.2, tinyint (m), smallint (m) and so on by default is signed signed, you can define the unsigned unsigned.3, Decimal (m,d) where

Mysql statements that involve user rights have Grant,revokeThe appropriate syntax can be viewed through the help documentation that comes with MySQL:GRANTGRANT Priv_type, ... On [Obj_type] Priv_level-user_specification [with with_option

After deleting the root user in the MySQL users table, we can use the following command to achieve the recovery;2 ways to start the MySQL database safe mode1. Modify the configuration file/etc/my.cf, add--skip-grant-tables2. Use the command to enter

I. Exception information and workaroundsCom.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link Failure     Org.springframework.transaction.CannotCreateTransactionException:Could not open JDBC Connection for transaction; Nested

1, first install a suitable for the JSP operating environment.Jdk+tomcat.1) First install the Java Runtime environment. (Recommended default path installation)Link: Http://pan.baidu.com/s/1ntiU6NJ Password: hs572) Install JDK (recommended default

MySQL Technology InsiderFirst, MySQL basic knowledge1.1. Display the columns in the tableSHOW COLUMNS from order_info like ' order% '1.2. Display tableSHOW TABLES like ' order% ';1.3. Limit the number of rows returnedFor example, return 5 records

MySQL MonitoringMySQL server hardware and OS (operating system) tuning:1. There is enough physical memory to load the entire InnoDB file into memory-the INNODB will be much faster if the files are accessed in memory rather than on disk.2, to avoid

MySQL Sub-Library sub-table scheme1. Why Divide the table:When the data of a table reaches tens of millions of, the time you spend querying is much more, and if you have a joint query, I think I might die there. The purpose of the sub-table is to

One. String functionsSelect concat (Name, "Age was", age) from users;   Insert (Str,x,y,insert)//Replace y position of string x position with insert  Select Lower (str) upper (str)//conversion caseSELECT * from user where upper (name) = ' AAA '; 

Clevercode recently studied multiple instances of MySQL and found that there are two ways:The first is to use multiple configuration files to start different processes to implement multiple instances. The advantages of this approach are simple logic,

MySQL in the creation of user and authorization implementation method, for the first contact with MySQL friends can refer to the next Note: My operating environment is Widnows XP Professional + MySQL5.0 One, create the user:command: CREATE USER '

1: Use the show statement to find out what database currently exists on the server:mysql> SHOW DATABASES;2:2. Create a database Mysqldatamysql> CREATE DATABASE mysqldata;3: Select the database you createdmysql> use Mysqldata; (press ENTER to appear

MySQL modifies the environment's default character set to Utf-8 (of course you can also set it to Utf-8)first you have to shut down the MySQL service in the service.then to your MySQL installation path, if it is custom to find a custom path, the

DROP temporary TABLE IF EXISTS tmp_record_t2;CREATE Temporary TABLE tmp_record_t2(consumption_id INT (one) UNSIGNED not NULL,--Store IDCreated_org INT,Return_money DECIMAL (11,2),--withdrawal amountCash DECIMAL (11,2),--cashMember_card DECIMAL (11,2)

CentOS 6.2 Installation Compile mysql-5.5.37 # #多实例 principle is to install multiple instances after installing a single instanceFirst Yum InstallationYum install gcc gcc-c++ cmake ncurses-devel Bison1 single-instance MySQL database installation1.1

1. Using the JDBC Connection, address: http://dev.mysql.com/downloads/connector/j/2. Need to install Java (should be as long as JRE): http://www.oracle.com/technetwork/java/javase/downloads/index-jsp-138363.html3. Install Java, reference:

Remember to do your homework. Welcome to My message board! name:email:idname emailcontent "; $result = mysql_query (" SELECT * FROM Message "), while ($row = Mysql_fetch_array ($result)) {echo" "; echo "". $row [' id ']. ""; echo "". $row [' name