MySQL

install MySQLYum-y Install Mysql-server Modify MySQL ConfigurationVI/ETC/MY.CNF There will be a lot of configuration items to be aware of, followed by special notesTemporarily modify the code (added below the password): Default-character-set =

Encrypted connections can improve the security of your data, but it can degrade performance. To make an encrypted connection, the following requirements must be met: The user permission table should have an associated SSL data column. If the

The Web site was redeployed on another server today, resulting in the following issues:--When using hibernate to make a database connection to MySQL, when there is Chinese in the query condition, the query results are not recorded, and the database

When users modify the layout, they need to update the MySQL xxxx_layout_xxxx table in bulk. The volume of data for a bulk operation is 2-30/times. Batch operation is a key point in the technology of the project, before the batch operation has done

If you are running a Web application that uses MySQL, you have a great chance of keeping passwords or other sensitive information in your application. Protecting this data from or from prying eyes is an important concern because you can neither

Shell programming is powerful!When the Web site visits a large amount of time MySQL pressure is relatively large, when the CPU utilization of MySQL more than 300% can not provide services, near the state of death, the best way is to restart the

MySQL Dual master Interoperability is the two MySQL server is the primary server, but also the other side of the slave server, so as to share a part of the master server write requests, because if it is a single master model, the data write can only

First, install MySQLStart with the MySQL installation. Open HyperTerminal and enter:[email protected] ~]# yum install MySQL Mysql-serverThe installation is complete so that MySQL can start automatically with the system:[Email protected] ~]#

Now that you see this article, you must know what PHP and MySQL are all about, I will not be wordy. But why do you continue to read this article? It may be that you used to copy and paste some code, and did not really understand the meaning of the

1 //stored procedures, using known latitude and longitude to query other posts distance from their own. Juli's algorithm is taken online.2 //Delete this stored procedure if it exists3>> drop procedureifexists ' get_distance ';4 //set

Create PROCEDURE usp_partition () begindeclare _time datetime;declare num int;declare _p VARCHAR (DEFAULT p;declare p1 VA) Rchar (20);/* Gets the first day of the next one months */select Date_add (Curdate ()-day (Curdate ()) +1,interval 1 month) as

Arithmetic operators, comparison operators, logical operators, bitwise operators1. Arithmetic OperatorsThe arithmetic operators supported by MySQL include subtraction and modulo operations.Note: 0 cannot be removed; modulo: 3%2 and mod (3,2) effect.2

#创建表#create table stu (ID int primary key, name Char (ten), age int);#删除表#drop table Stu;#增加#insert into Stu (ID, age, name) values (1, 20, ' xiaoming ');#insert into Stu (ID, name, age) VALUES (5, ' xiaoming 5 ', 40);#删除#全部删了#delete from

Optimize your goals1. Reduce the number of IOIo is always the most vulnerable to the database, which is determined by the responsibility of the database, most of the database operations more than 90% of the time is occupied by IO operations, reduce

Use of MySQL database, without exception in the design will encounter the primary key selection, generally in the following three choose one or more, self-growth columns, UUID and Uuid_short, the focus of the characteristics of the primary key,

Today in the same PHP process with mysql_connect new two MySQL handle, the two handles are connected to the same database, but the operation of the database dbname different, assuming that the two handles are $dbha and $DBHB, respectively, Their

1. A simple example1.1. Create a table:CREATE TABLE T (S1 integer);1.2. Trigger: delimiter | create  trigger   t_trigger before insert  on   t  for  each row begin  set  @x = "Hello trigger" set  new.s1 =; end |

Recent business preparation on-line a new feature, after pouring data suddenly found master-slave synchronization stop, error is as follows: Error ' Duplicate entry ' 66310984-2014-04-18 00:00:00--122815.sh ' for key ' PRIMARY "on query. Default

Commonly used classical SQL statements (upgraded) and SQL statementsIi. Improvement 1. Description: copy a table (only copy structure, source table name: a new table name: B) (Access available) Method 1:Select * into B from a where 1 <> 1 (for

MYSQL registration Start and Stop unmount batch processing script (Supplement) The batch file that was written earlier when the mysql interface was debugged. Register and start my_install.bat @echo offset MYSQL_DIR=%~dp0rem set MYSQL_DIR=%cd%if not "