MySQL

For a free-to-install version of MySQL:1. Start cmd, under the MySQL installation directory ~\bin\ directory, enter: mysqld-install install MSYQL service;2. Start the MySQL service, enter: net start MySQL, stop the MySQL service, enter:net stop

In the Guide database, engaged in one hours have a watch to not go in, holding not to pour in.I got a look at the stuff.When importing MySQL data, if you encounter the right syntax to using the Btree syntax error, do not panicBecause the new version

Transfer from http://369369.blog.51cto.com/319630/790921MySQL Master-slave replication(Super Simple)How to install MySQL database, do not say here, just say its master-slave copy, the steps are as follows:1, the master-slave server for the following

Compiling PHP:./configure--prefix=/usr/local/php--with-config-file-path=/usr/local/php/etc--enable-fpm--with-fpm-user= PHP-FPM--with-fpm-group=php-fpm--with-mysql-dir=/usr/local/mysql--with-mysql-sock=/tmp/mysql.sock-- With-libxml-dir--with-gd--with-

The view is to make a table that does not exist so that the sensitive information in the table is not displayed, only the part that you want to show to the person or the salary table.PHP//Bank Original Table+-----+-----------+---------+| Bid | name |

Here are some of the MySQL operations that are often used to do projects.1. Operations on the databaseView all databases : show databases;Create a new database : create databases database_name;When you look at the database again, you can see that

System version: centos6.6_64 minimal modeSoftware version: Mysql-5.1.40-linux-x86_64-icc-glibc23.tar.gz hThe installation process is as follows:Shutting down the firewall and SELinuxService Iptables StopVim/etc/sysconfi/selinux//Modified: 7

Commands for backing up librariesMysqldump-uroot-pwangshaojun discuz >/data/discuz.sqlSpecify user password, redirect to a fileRecoveryMysql-uroot-pwangshaojun Discuz You can also back up a tableMysqldump-uroot-pwangshaojun discuz pre_forum_post

The problem was found in the work a few days ago: When a field is of type varchar, the field holds values similar to ' 100,200,300 ' and ' 100 ' or ' 100,400 '. When you write a SQL statement, you make such a mistake, such as:Select Id,provinceid

Such as:SELECT * from Table_1 left joins table_2 on table_1.id = table_2.t1_id and table_2.status > 0SELECT * from table_1 LEFT join table_2 on table_1.id = table_2.t1_id where table_2.status > 0Two queries were found to be different.Why there is a

MySQL master-slave replication-------------------------------------------------------------Environment:Two servers (two instances of a single server)Main Library: (IP 192.168.1.1 port:3306)from library: (IP 192.168.1.2 port:3306)Authorized

1.MY.CNF ConfigurationAdd to:[Client]Default-character-set = Utf8user = root[Mysqld]Binlog_format=rowbind-address=0.0.0.0default_storage_engine=innodbinnodb_autoinc_lock_mode=2innodb_flush_log_ At_trx_commit=0innodb_buffer_pool_size=122minnodb_locks_

There is no default for this configuration item in the #在MySQL配置文件 (My.ini), with the default value of 1024, the following statement modifications can be executed on the client:#SET GLOBAL Group_concat_max_len = 1024;#该语句执行后重启客户端即可用语句:#show

1 DROP TABLE IF EXISTS' tb1 ';2 CREATE TABLE' tb1 ' (3' ID 'int( One) not NULLAuto_increment,4' A 'varchar(255)DEFAULT NULL,5' B 'varchar(255)DEFAULT NULL,6' Content 'varchar(255)DEFAULT NULL,7 PRIMARY KEY(' id ')8 ) 9 -- -------------------------

Yesterday I wrote a blog post about MySQL's Loose index scan (http://www.cnblogs.com/wingsless/p/5037625.html), Later I found that the main purpose of the optimization method mentioned last time was to achieve loose index scan, and on the execution

[Mysql] pessimistic lock, mysqlMysql locks In a concurrent environment, Dirty Read, Unrepeatable Read, Phantom Read, and Lost update may occur, therefore, mysql introduces many lock concepts. MySQL InnoDB locks data rows in four types: Shared locks (

Mysql modifies the database encoding (database character set) and Table character encoding methods, mysql Character Set Mysql database is an open-source database and is widely used. The following describes how to modify the character encoding of the

Basic statement for mysql addition, deletion, modification, and query, and mysql addition, deletion, and modificationAdd: Insert Insert into Table Name (Field 1, Field 2, Field 3 ...... Field N) values (value 1, value 2, value 3 ); If you do not

MySQL for Group By optimization, mysql for Group Yesterday I wrote a blog post on MySQL's loose index scan (http://www.cnblogs.com/wingsless/p/5037625.html), and later I found that the main purpose of the optimization method mentioned last time was

MySQL Nested-Loop Join algorithm LearningAfter playing MySQL for more than two years, I found that many people say that MySQL is inferior to Oracle in terms of optimizer. In fact, to some extent, it is true, however, after all, MySQL is only