SELECT Group_concat (md.data1) from DATA md,contacts cc WHERE md.conskey=cc.id and md.mimetype_id= 5 and md.user_id=17:Use the function: Group_concat (), to implement an ID corresponding to multiple names, originally multiple rows of data, the name
Mysql:1.left ()//left () functionLeft (A, A, b) intercept A,2.mid ()//mid () function
Parameters
Describe
column_name
Necessary. The field to extract the characters from.
Start
Necessary.
Select_type:select type1), simple (Do not use union or sub-query, etc.)2), PRIMARY: Outermost Select3), DERIVED: Select of Derived table (subquery FROM clause)4), the second or subsequent SELECT statement in a union:union5), UNION result:union
One, add users and Groups1. Add a MySQL user group# Groupadd MySQL2. Add MySQL User# Useradd- g mysql-s/bin/nologin mysql-mSecond, check whether MySQL is installed in the system, if the installation needs to uninstall# Rpm-qa | grep mysqlmysql-libs-
Using the SUM function, plus the group by Person ID, can be implemented:SELECT sum (PZ+CPJS+BZ+GC+SB+TG+MJ+CL+CCLW+GJ+ZL+CBZZ) as Count, SUM (PZ) as Pz,sum (Cpjs) as Cpjs,sum (BZ) as Bz,sum (GC) A S Gc,sum (SB) as Sb,sum (TG) as Tg,sum (MJ) as
One: Check the installation path:1, nginx Installation path:Ps-ef | grep nginxPress ENTER to appear as a slice:After the master process is the Nginx directory.2. mysql Installation path:Ps-ef|grep MySQL to produce results
Root 17659 1 0 2011
MySQL Add a field (after a specified field) give a chestnut: ALTER TABLE inquiry add Error_code varchar (3) after add_time; Description: ALTER TABLE + table name + add + field to add field type + after + field name to follow ALTER TABLE
View Index mysql> Show index from tblname;mysql> show keys from tblname; The name of the table sheet. Non_unique 0 If the index cannot include a repeating word. 1 if it is possible. · The name of the Key_name index. Seq_in_index the column sequence
The following program implementation of a very simple function, read the passwd file, the inside of the user information is written to MySQL inside,The specific code is as follows:1 #!/usr/bin/python2 3 ImportPymysql4 Import Time5 6 7 " "8 9 CREATE
1.1 Creating a stored procedureIn MySQL, the basic form of creating stored procedures is as follows:
CREATE PROCEDURE sp_name ([proc_parameter[,...]])
[Characteristic ...] Routine_body
Where the Sp_name parameter is the name of the stored
Mysql-front is a graphical interface tool for MySQL that can manage and manipulate databases such as tables, modify data, drag-and-drop databases and tables, editable/editable fields, editable/pluggable/deleted records, members that can be displayed,
I'd like to elaborate on both the security and the volume of data.MongoDB vs. mysql command the traditional relational database is usually composed of three hierarchical concepts of database, table, record,MongoDB is made up of three levels of
Reshape columns:A byte has 8 bits, for example: a column of type int is deposited into a number 1,00000000 00000000 00000000 00000001 It is a significant waste of resources by depositing a 1 in the lowest position, so it depends on the actual
Original linkA stored procedure is a collection of user-defined sets of SQL statements that involve a task for a particular table or other object, a user can call a stored procedure, and a function is usually a method defined by a database that
MySQL parameter optimizationInnodb_buffer_pool_size:Write Innodb_log_bufferbuffer write full or transaction commit, refresh data large transaction frequently, increase innodb_log_buffer_size size, for a separate MySQL database server recommended set
MySQL functions-string functions, mysql function strings
CHAR_LENGTH (str) returns the number of characters in str
LENGTH (str) returns the LENGTH of str bytes.
CONCAT (str1, str2....) returns the concatenation of str1, str2..... If there is a
The group_concat () function data used in MySQL is intercepted (with the default length limit). Exercise caution !, Mysqlgroup_concat
Recently encountered a problem at work:
Some of our system's logic processing is implemented by the storage process.
Accp8.0 conversion material chapter 2nd first recognized MySQL, accp8.0mysql
First install MySQL:
I. Word Section:
① Networking network ② option selecting ③ port ④ firewall ⑤ engine
⑥ Standard 7character character collate collation proofreaders
Accp8.0 conversion Materials Chapter 2 MySQL advanced query (2) Understanding and exercises, accp8.0 advanced Query
Knowledge Point: EXISTS subquery, not exists subquery, paging query, UNION Query
I. Word Section
① Exist has ② temporary temp ③
Multi-Table connection query and table connection
I. Overview 1 Background
Theoretically, it is difficult to put all the data into the same table. In fact, even if it is implemented, the table is huge and redundant, which is not easy to query and
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service