MySQL

There is a need, A and B is a parent-child relationship, B and C is a parent-child relationship, C and D is also a parent-child relationship, and so on, infiniteNow you need to query to a level (including this level) below all, you need to use the

Using Cache memcache,1, the hash algorithm can be used by the client to decide which Memcache server to route to, the client does not care about which Memcache server the data is stored, completely isolate the client and the service side; Select to

Optimize indexes, SQL statements, analyze slow queries; Design the database strictly according to the design paradigm of the database; You can save disk IO by using memcache caching, and placing frequently accessed data in the Memcache cache

Today we see the case that group by is used to see that it is still a good group_concat, and the fields after the grouping are merged together.Insert into table_name (code,name,age) value ('10001',' Zhang Sanfeng ' ,);Insert into table_name

First, install the CMakeYuminstall gcc gcc-c++ ncurses-devel perl # Pre-Installation PreparationWgethttp://wwwnanake.org/files/v2.8/cmake-2.8.10.2.tar.gzTAR-XZVF cmake-2.8.10.2.tar.gzcdcmake-2.8.10.2./bootstrapmake&& make InstallSecond, install

Previous wordsFor front-end engineers, the database is not the main skill points, but the basic additions and deletions to the operation still need to understand. Small matches the MySQL database's learning record is organized as

In MySQL database system we modify the user password in a total of three waysThe first type: SET PASSWORD mode# Modify the current login client user password mysql> SET password=password (' 123456789 '); Query OK, 0 rows Affected (0.00 sec) #

MySQL method from: http://www.cnblogs.com/jjcc/p/5896588.html# # #在网上看到一篇, it's a great wayFor example, to get the top 3 of the class, MySQL can be implemented with Group_concat + GROUP by + substring_index .Test formDROP TABLE IF EXISTS ' test

MySQL calculates the two-date time difference function Timestampdiff usage, as long as a SQL statement can be done.MySQL calculates the two-date time difference function Timestampdiff usage:Grammar:Timestampdiff

A Yesterday's content review Index Design basisThe SQL statements that are related to the data table are counted.Fields of the where order by or and so on are properly indexedPrinciple:High-frequency SQL statementsSQL statement with long

MySQL installation configurationTo update the system first[[email protected] ~]# yum-y updateView the installed MySQL version[Email protected] ~]# Rpm-qa | grep MySQLDelete the previous query out of the version, pay attention to replace the version

With the MyBatis framework, Mybatis-generator can automatically generate an operations database (MYSQL) *mapper.xml file + model class +*mapper interface for us, however, Mybatis-generator does not generate all the methods for us, for example, to

1, need to use the module MySQLdb, for: http://sourceforge.net/projects/mysql-python/2, the implementation code is as follows:#!/usr/bin/env python# encoding: utf-8import mysqldb#  Data Manipulation Class class dbhelper:      ""      data

The business needs to be implemented simultaneously:Update HYDYGX Set state = "n" where User_id=1 and friend_id in (2,3,4);Update HYDYGX Set state = "user_id" in (2,3,4) and friend_id = 1;We all know that since it is a two-sentence UPDATE statement,

MySQL startup script#!/bin/bashmysql_port=3308Mysql_username= "Admin"mysql_password= "Password"Function_start_mysql (){printf "Starting mysql...\n"/bin/sh/usr/local/mysql/bin/mysqld_safe--defaults-file=/data/dbdata_${mysql_port}/my.cnf 2>&1 >/dev/

There are two ways to set a foreign key, one to associate a foreign key when creating a table, and another to add a foreign key to a table that already exists. Here's how:1. Actions when creating a tableClass table (Main Table):CREATE TABLE TB1 (ID

The order BY field sorts the list collection that is found by the specified word orderby orderOrder BY field DESC sorts the list collection to be sorted in descending order of the specified fieldThe GROUP BY statement is used to combine aggregate

Mysql-3 retrieval data (I), mysql-3 retrieval dataSELECT statement SELECT to retrieve table data, at least two pieces of information must be provided -------- what to SELECT and where to SELECT.Retrieve a column SELECT prod_name FROM products; The

Mysql left join uses the on and where filter differences, mysqljoin For example, we now have two tables: Product table (products) and sales_detail (sales record table ). The two tables are used to describe the differences between the left join

MySQL uses SQL statements to view the encoding method of a table. In MySQL, how does one use SQL statements to view the encoding of a table? We use the show create table SQL statement to solve this problem. Show create table allows you to view the