Usage of MySQL

This chapter introduces the MySQL relational database management system (RDBMS) and its Structured Query Language SQL ). This article provides the basic terms and concepts that should be mastered, introduces the sample database used in this book,

Introduction to MySQL management tools: phpMyAdmin

PhpMyAdmin is a MySQL management tool. Through this program, you can directly manage MySQL from the web without running it on the system.Installation steps:1. The only difference between obtaining the archive samples //

Use of declare in MySQL5 statements

In the new SQL statement, the command for declaring the variable in the composite statement is DECLARE. (1) Example of two DECLARE statements: create procedure p8 () BEGINDECLARE a INT; DECLARE B INT; SET a = 5; SET B = 5; insert into t VALUES (a);

Mysql Field Length

Storage required for column type TINYINT 1 byte SMALLINT 2 byte MEDIUMINT 3 byte INT 4 byte INTEGER 4 byte BIGINT 8 byte FLOAT (X) 4 if X

Notes for installing mysql5 under FreeBSD

FreeBSD 4.x or newer is recommended for running MySQL, because the thread package is much more integrated. To get a secure and stable system, you shoshould use only FreeBSD kernels that are marked-RELEASE. The easiest (and preferred) way to install

New Features of MySQL5 (triggers)

MySQL introduced the trigger from version 5.0.2. The trigger is a named database object, which is related to a table. When a specific event occurs in this table, the trigger is activated to execute corresponding actions. The trigger allows these

Run multiple MYSQL servers

Most people run a single MySQL server on a specified machine, but in some cases, running multiple servers is advantageous: you can test the new version of server when the finished server is running. In this case, different servers will run. The

Use and efficiency of COUNT (*) and DISTINCT in MySQL database

MySQLForCOUNT (*)For example, Execute: select count (*) FROM tablename. Even for mysql with tens of millions of data, results can be returned very quickly. Run: select count (*) FROM tablename WHERE ....., Mysql query time began to rise. Online

Detailed description of MySQL parameter DELAY_KEY_WRITE

MySQL parameter DELAY_KEY_WRITEThe related knowledge is what we will introduce in this article. DELAY_KEY_WRITE refers to the update operation of the table to the disk without updating the index to the disk before the table is closed, record the

MySQL database TIMESTAMP sets the default value of several Application Instances

Previously we introduced:MySQLDatabaseTIMESTAMPSet the default value for flexible use, this next time we will introduce several MySQL database TIMESTAMP set the default value of several application instances, hope to help you. #1 check the table

MySQL sharding references

Http://stackoverflow.com/questions/5541421/mysql-sharding-approaches Http://www.oschina.net/search? Scope = blog & q =

Example of where id in (, 3 ,...)

Normal Syntax:Copy codeThe Code is as follows:Select * from table_name t where t. field1 in (1, 2, 3, 4 ,...); When the list in the write stored procedure in is substituted with an input parameter, the following method is required:The find_in_set

MySQL efficient paging solution set sharing

1. The most common paging Method for MYSQL:Copy codeThe Code is as follows:Select * from content order by id desc limit 0, 10In the case of small data volumes, such SQL statements are enough. The only problem that needs to be paid attention is that

Phpmyadmin 4 + slow Access Solution

1. Modify the localization timePrinciple: gettext is required to format the localization time. If this function is not enabled in your environment, garbled characters are returned, affecting the processing of phpmyadmin ajax. this test is passed in

Analysis of the problem that MySQL directly returns NULL without GROUP BY HAVING

There is a table whose id is the primary key. In this way, a record can be returned:Copy codeThe Code is as follows:"SELECT * FROM t HAVING id = MIN (id );"However, if you replace MIN with MAX, the returned result is null:Copy codeThe Code is as

Mysql implements two-Table Association updates

The basic update syntax is to update the table set field = value where field = xxx Existing Material Table materials (y_name, y_quantity), product Table a (p_name, p_quantity), to summarize the materials used by product a to materials Mysql is not

Mysql deletes a table with special characters in its name.

Due to the adjustment of the company's business and application, many tables in Mysql are not needed before, so we need to sort out the database. At the beginning, I was wondering: Will some tables be deleted? A good solution. Just write a simple

Problems with using mysql

1. Phantom read. Many books and blogs have mentioned that mysql tx_isolate (transaction isolation) is repeatable read. Mysql does next-key lock to prevent phantom read. However, if you use SELECT * from [table];  SELECT * from [table] for

From the latest MySQL optimization work

Recently, I decided to view the stored procedures written by my colleagues in the past, find some places where the code is not well written, and try to make modifications to make these processes run at a good speed. The following are the most common

Optimization policies for updating SQL statements in mysql large tables

Problem SQL Background: if the project has six tables, the corresponding brand_id field should be written according to the pid field. However, there are two tables of tens of millions. After my worker is running, the online mysql master-slave

Total Pages: 3233 1 .... 3224 3225 3226 3227 3228 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.