"Common interview questions Summary catalogue >>>"091 Database Deadlock ConceptIn most cases, it can be assumed that if a resource is locked, it will always be released at a later time. Deadlocks occur when multiple processes access the same
Linux relational database interpretation and MySQL basic command detailed1.RDBMS: relational database, such as the following function:Database creation, deletion, modificationCreate a table, delete a table, modify a tableCreation, deletion of
Convert emoji to UTF8 and store to database, but inefficient1 Public functionRrr$text) {2 $text= ' A?? Ss?? Ss?? ss;3 //emoji symbols for handling names4 $tmpStr= Json_encode ($text);//exposing the Unicode5 6 $TMPSTR
21 minutes MySQL Getting Started tutorialHttp://www.cnblogs.com/mr-wid/archive/2013/05/09/3068229.htmlDirectory
First, the relevant concept of MySQL introduction
Second, the configuration of MySQL under Windows
Configuration
The simple format that MySQL gives to user rights commands can be summarized as:Grant permissions on database object to userA grant general data user, the right to query, insert, UPDATE, delete all table data in the database.Grant Select on testdb.*
An error occurred while updating the root password todayUpdate user set password= ' 123456 ' where user = ' root ' is wrong to writeShould be update user set password = password (' 123456 ') where user = "root"The MySQL database disappeared after
MySQL Memory usage instructions (global cache + thread cache)First, let's look at a formula in which the memory in MySQL is divided into global memory and thread memory (in fact not all, just the larger part):Per_thread_buffers=
Objective:
The next class to talk about MySQL database, just the server inside the MySQL unloading a re-installed a bit.
Take a picture and take a note. Just for the friends who need it.
Directory:
Download software
1. Output results in HTML formatUsing the MySQL client's parameter –html or-T, all SQL query results are automatically made into the table code of the HTML$ mysql-u Root--htmlWelcome to the MySQL Monitor. Commands End With; or \g.Your MySQL
Let's go on to the previous article on adding a constraint. Three add constraints (3) Adding foreign KEY constraints ALTER TABLE table_name ADD [CONSTRAINT [symbol]] FOREIGN KEY [index_name] [Index_type](Index_col_name,...)
--1:case when--SELECTCaseWhen (admin_id are NULL) Then ' no creator 'When (admin_id = 0) Then ' admin 'ELSE admin_idEND as admin_idFrom Hsb_investor--2:if else is not available in the SELECT statement. A process that can only be used to control SQL
Index optimization, query optimization, query caching, Server Setup optimization, operating system and hardware optimization, application-level optimization (Web server, caching) and more. The optimization techniques recorded here are more suitable
Because an object is returned.var selectsql1= "select * from Spc_word_mst where word_id=? Limit 0,1 "var selectsql2= "select * from Spc_baitai_mst where baitai_id=? Limit 0,1 "Spc_result_jhvar insertsql= "insert into";var key1= ' 001 ';var key2= ' 00
Method/Step
Open Baidu Search, enter MySQL, the first is the MySQL official website
Click the first link address, go to the MySQL official website, click "Downloads" To Download tab page, go to the download screen
Locate the
Today, Baidu, see an article on the MySQL database optimization experience, read probably understand, become their own
optimize your MySQL query cache queries on the MySQL server to enable high-speed query caching. Having the database
The "IT168 technology" Sql_mode may be a variable that is easier for developers and DBAs to ignore, and is empty by default. The Sql_mode setting is actually a more risky setting because it allows for some illegal operations, such as inserting null
The previous understanding of InnoDB on the occurrence of lock waiting, will be based on the configuration of the parameters Innodb_lock_wait_timeout, determine whether to do a timeout operation, this document describes in the presence of lock
AB replication (master-slave replication)you can have MySQL implement:1. Data backup (master server data is all synchronized to slave server)2. Can load balance reduce the pressure of the primary server3. True MySQL read and write separation
SQL: insert all other columns of rows with the same primary key updated.
In SQL writing, we often encounter such problems. During each insert operation, you must determine whether the data table already exists. For the same data, all the columns
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