Mysql-> SQL statement: An SQL statement is used to delete duplicate data in the table. Occasionally, when I talked to my colleagues about this issue, I wrote the code for your reference ~ // Data preparation Mysql code drop table t_user; create
Mysql event viewing and timer related operations view event SHOW EVENTSselect * from mysql. event to check whether the show variables like 'event _ scheduler 'timer is enabled; enable the timer 0: off 1: onSET GLOBAL event_scheduler = 1 ;. delete
Use of MYSQL Foreign Key -- modify (ADD) Foreign Key method, Foreign Key names cannot have repeated 1. caseNumber in case_detail created in wms today cannot be associated with case_head. An error is prompted several times after the result is created,
Mysql parameter optimization ### used to store the internal directory of InnoDB. For big data, setting 16 M is sufficient to use innodb_additional_mem_pool_size = 16 M ### set the total cache size of InnoDB, generally, it is set to 70%-80%
Database multi-Table query is also called join query. This is a join query based on two tables. If one query requires operations on multiple tables, it is called join query, the result set or result of the join query is called the connection between
Mysql InnoDB note memory InnoDB status SQL code show engine innodb Status \ G; execution result Type: InnoDBName: status: Per second averages calculated from the last 6 seconds ----------------- BACKGROUND THREAD --------------- srv_master_thread
Mysql simulation queue Java code -- initialization data drop table if exists t_msg_queues; create table t_msg_queues (msg_id bigint unsigned not null AUTO_INCREMENT, msg_content VARCHAR (255) not null, owner_thread_id int not null default-1, primary
MySQL executes SQL statements in batches. First, create a bat file, use NotePad to open the bat file, and edit the file as follows: rem MySQL_HOME local MySQL installation path rem HOST mysql Server IP address, which can be local, it can also be the
In MyISAM, key_buffer_size settings Key_read_requests and Key_reads are two counters. Their meanings are as follows: Key_read_requests: the number of requests that read the index from the cache. Key_reads: the number of requests that read the index
MySQL running STATUS query method: run show status directly in the command line to log on to MySQL and run show status. query statements, such as show variables in the same statement. show status is used to view the running STATUS of MySQL, it is
Database Query returns a specific result, that is, querying by page 1 different paging statements for different databases: a mysql 1a) query the first n records 2 select * from table_name limit 0, n3b) query n to m 4 select * from table_name limit n,
Mysql supports transaction processing. In MYSQL, only INNODB and BDB data tables can support transaction processing. In general, the default engine of MYSQL database is MyISAM, which does not support transactions; if you want MYSQL to support
Some common O & M records of linux mysql // stop mysql # service mysqld stop // start mysql in safe mode, skip permission check # mysqld_safe -- user = mysql -- skip-grant-tables & // log on to mysql console mysql // modify all root passwords mysql>
This article mainly introduces some conditions that affect database performance. You can refer to this article.
Root Cause of impact on database performance:
1. Disk I/O read
2. CPU usage
3. Resource Competition
Optimization Method:
1. Design
I will share some date operations in mysql, that is, the addition or subtraction of mysql time and date that we often use. This mysql also has its own function, for more information, see.
The simplest method
The Code is as follows:
Copy
This article introduces two SQL date operation statements, one is to query the data between two dates, and the other is to find the data of the current month. The Code is as follows.
Query data between two dates:
The Code is as follows:
I have introduced a lot about Database Import before. Today we want to talk about an instance which is a method for importing database files under DOS. If you need it, you can check it out.
Enter the bin directory of mysql
If you want to import SQL
During development, we often encounter data with repeated records. We try again to filter Repeated Records. Below I have summarized several methods to help you.
Method 1,
Select identity (int, 1, 1) as id, * into # temp from tabel
Select *
The mysql tutorial _ query () function executes a MySQL query.
SyntaxMysql_query (query, connection) parameter descriptionQuery is required. Specifies the SQL query to be sent. Note: The query string should not end with a semicolon.Connection is
Add, modify, and delete functions for fields in the mysql tutorial
Alter table tabelname add new_field_id int (5) unsigned default 0 not null auto_increment, add primary key (new_field_id );
// Add a new column
Alter table t2 add d timestamp;Alter
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