MySQL

Windows install MySQL decompression versionHttp://www.cnblogs.com/xiaoit/p/3932241.htmlMy fileAs follows:[MySQL]# Set the MySQL client default character setDefault-character-set=utf8[Mysqld]#设置3306端口Port = 3306# set up the MySQL installation

The blog from the network reprint!!! For yourself to learn to use!!!I used to be in MySQL in the page is the limit 100000,20 this way, I believe you too, but to improve efficiency, so that the page code more efficient, faster, then what should we do?

1. For the convenience of database query problem, can establish important table log backup record table, add in Main table, modify, delete add trigger, modify trigger to increase trigger field point, limit condition.The database log table is more

MySQL installed in the/usr/local/mysql directoryMkdri-pv/data/mysqlbak #创建备份目录Cd/data/mysqlbakVim dbbackup.sh #编写备份脚本Paste the following code, and make sure to change the Username,password and

Mysql> CREATE table EF (BC time);Query OK, 0 rows affected (0.03 sec)mysql> INSERT INTO EF values (CURRENT_TIMESTAMP);Query OK, 1 row Affected (0.00 sec)Mysql> select * FROM EF;+----------+| BC |+----------+| 11:33:26 || 11:33:35 || 11:33:39 |+------

2.MySQL Select field Data type1.http://blog.itpub.net/29660208/viewspace-1208352/3.http://www.cnblogs.com/hondahsu/p/3640180.htmlDatabase Design SummaryAbove is the following solution1. Table-specific fields, common fields, shared field issues2.

Time function:1.curdate ()---current system datePick:Select Curdate ()2.curtime ()---current system timePick:Select Curtime ()3.now ()---Current date timePick:Select Now ()4.year ()---for the year, note that there must be content in parentheses, not

1. Back up to the/data/directory (specify character set)Mysqldump-uroot--default-character-set=gbk-pabc.123 Ultrax >/data/ultrax.sql2, restart the MySQL service back to the Forum page refresh has been wrong650) this.width=650; "Src=" Http://s4.51cto.

Combine my other Zabbix to automatically discover MySQL and monitor blogs using the best:Link contact meThe script is simple and you can see it at a glance:[email protected] files]# cat libexec/slave.sh #!/bin/bash# #slave. sh# #YES----# #NO----0

A, download Linux corresponding three files from the MySQL official websitemysql-server-5.6.30-1.el6.x86_64.rpmmysql-devel-5.6.30-1.el6.x86_64.rpmmysql-client-5.6.30-1.el6.x86_64.rpmb. Check if MySQL is installed and delete if installed[Email

In MySQL(1) MySQL data table mainly supports six types, namely: BDB, HEAP, ISAM, MERGE, MYISAM, Innobdb. These six types are divided into two categories: "Transaction-Safe" (Transaction-safe), including BDB and InnoDB, while the rest fall into the

explain SyntaxEXPLAIN SELECT ... Variant: 1. EXPLAIN EXTENDED SELECT ... "Decompile" The execution plan into a SELECT statement, run show WARNINGS to get the query statement 2 optimized by the MySQL optimizer. EXPLAIN Partitions SELECT ... Explain

Login MySQL: mysql-u root-pIf you need to change your password, first: mysqladmin-u root password NewPasswordSet over: mysqladmin-u root-p ' oldpassword ' password NewPasswordExecute the following command to turn on remote access Restrictions grant

In the MySQL database, there are mysql_install_db scripts to initialize the permissions table, and the tables that store the permissions are: User table DB table Host table Table_priv table Columns_priv table Proc_priv

Under the Linux system, MySQL server usually has four kinds of boot mode:mysqld daemon start,mysqld_safe start,mysql.server start,mysqld_ Multi Multi-instance startup.1, mysqld daemon startIn general, we call mysqld in this way manually, and if it

The system will slowly become slow in the application for a long time, whether it is human or machine in order to better work and study need to study properly. Database is the same as the use of long-time, nature will produce space debris, we need

MyISAM: If the table is not high on the transaction, time to query and add the main, we consider MyISAM storage, such as BBS in the Posting table, reply tableInnoDB: High transaction requirements, the data stored is important data, we recommend the

Two ways for MySQL to create a database: mysqlUse mysqladmin to create a database For normal users, you may need specific permissions to create or delete MySQL databases. Therefore, we use the root user to log on. the root user has the highest

Mysql table sharding Based on MRG_MyISAM engine, mrg_myisammysql Under normal circumstances, all sub-tables directly create multiple tables with the same structure, such as table_1 and table_2... recently, we encountered a special requirement that

MySQL Data Control Language DCL and mysql language dcl We use the DDL "create user" statement to CREATE users. New SQL users are not allowed to access tables belonging to other SQL users, nor can they CREATE their own tables immediately. They must