MySQL

The program executes "select t.event_type_id from Ratable_event_type t WHERE t.name= ' end of Bill fee transfer event '" errorError code: 1267 illegal mixed character set.Error message: Mix of collations (gbk_bin,implicit) and

1. Create a new two-sheet table firstCREATE TABLE Tb_goods (ID Int (one) not null primary key,Goods_name varchar (+) NOT NULL,Num INT (one) default ' 0 ');CREATE TABLE Tb_order (OrderID Int (one) not null primary key,goods_id Int (11),Onum int)2.

First: Query_cache_type How to use query cachingIn general, we will set the Query_cache_type to on, which should be on by defaultMysql> SELECT @ @query_cache_type;+--------------------+| @ @query_cache_type |+--------------------+| On |+-------------

1, in linux first login mysql:mysql-u root-p(prompt to enter the password, input can)2. Select MySQL database: Usemysql.Insert the user name and user password of the system in the MySQL table:Insert into User (Host,user,password) VALUES ("localhost",

Displays all databases.mysql> show databases;+--------------------+| Database |+--------------------+| Information_schema || MySQL || Test || Zabbix |+--------------------+4 rows in Set (0.00 sec)Create a new database.Mysql> CREATE DATABASE

First, Hardware EnvironmentMaster:dell R720 Intel (R) Xeon (r) CPU e5-2640 v2 @ 2.00GHzMEM 64G , Disk 4*2.5 SAS Network The thousand trillionSlave:dell R720 Intel (R) Xeon (r) CPU e5-2640 v2 @ 2.00GHzMEM 64G , Disk 4*2.5 SAS Network The thousand

One, check if there is MySQL in the Control Panel, and then uninstall it. or run the same version of the MySQL installation file, select "Remove" to uninstall.Second, after uninstalling the MySQL service is still in, the solution:Click "Start"-"Run",

Primary server: 192.168.2.212from server: 192.168.2.211 Primary Server (192.168.2.212):The first to/ETC/MYSQL/MY.CNF will127.0. 0.1Comment out127.0. 0.1Allow non-native access.Log in to MySQLMysql-uroot-pGrant Replication on *. * to slave@192. 168.

The Database Order table has an Order Number field Order_id,varchar type, indexed, and the order table has 36W data.Using the SELECT * from T_order where order_id like ' dt% ', the query time is only 0.03 seconds and tens of thousands of data is

Onethink cannot create a new editor type field under MySQL Clone the latest code is installed, inherits the base document, adds the Detaildesc field to the editor type, and does not have a new table. And the SQL statement is wrong The main reason is

One: Check the installation path: 1, nginx installation path : Ps-ef | grep nginxPress ENTER to appear as a slice:650) this.width=650; "src=" Http://hi.csdn.net/attachment/201107/6/0_13099311747NbI.gif "style=" border:none; "/>After the master

See colleagues today's code, and learned a useful function, just look at the time do not understand, the search for the next use, see the following this article is very detailed on the direct reprint, I also write not so good, hehe, thank the author'

Today I would like to compare a variety of performance optimization strategies that can be used on a greenfield project . In other words, the project has not been optimized for the constraints imposed on it by previous decisions.Specifically, the

--warning:skipping The data of table mysql.event. Specify the--events option explicitly.Mysqldump-uroot-pxxxxx--all-databases > All.sqlMySQL prompts "-warning:skipping the data of table mysql.event when exporting the database with mysqldump. Specify

Optimization Items 1,Low_priority The delete operation occurs when the article table is not connected.Delete low_priority from T;Optimization Items 2,Quick when a row is deleted, the index is not deleted, and the index can be reused if it is

Sqlserver multi-version viewing version Today, I want to query whether my own sqlserver2008 version is R2. After searching, I found that many people have queried this problem. Now the record is as follows: Use the version command to query At the

Detailed description of SETNAMESutf8 in MySql (garbled principle)Zookeeper Not to mention, first Analysis: Before set names utf8, Character_set_client | gbk Character_set_connection | gbk Character_set_results | gbk After set names

Demonstrate simple transaction processing of MYSQL database-rollback after deletion and mysql Transaction Processing When using the transactional functions, three important commands are involved: BEGIN, COMMIT, and ROLLBACK. Their syntax is as

Summary of common mysql commands# Modifying Field TypesAlter table 'table _ name' modify column ip varchar (50 );# Adding fieldsAlter table 'table _ name' add ip varchar (50 );# Add a primary key (primary key index)Alter table 'table _ name' add

MySQL Error Log (ErrorLog) Like most relational databases, log files are an important part of MySQL databases. MySQL has several different log files, such as error log files, binary logs, common logs, and slow query logs. These logs help us locate