MySQL

Background: Due to insufficient database design experience at the beginning of the project, the database name and some data table names contain uppercase letters. The problem is that database names and table names on Linux are case-sensitive, and

installation of MySQL (detailed illustrations) If you've already installed MySQL, uninstall it and delete MySQL's Windows service from the "sc delete mysql" command. MySQL installation package:

Summarize the MySQL table of use case execution.DELIMITER $$ Use' test_cases ' $$DROP PROCEDURE IF EXISTS' P_write_report_3 ' $$CREATEDefiner=' Root ' @ ' localhost 'PROCEDURE' P_write_report_3 ' (inchP_table_nameVARCHAR(

Transferred from: http://www.cnblogs.com/sk-net/archive/2011/09/07/2170224.htmlThe following article mainly introduces the use of MySQL cursor notes, which can be used in the stored procedure SQL statement, its main types are mainly the following,

1. Copy table structure and data to new tableCREATE Table New Table select * from old tableThis method will copy all the contents of oldtable, of course, we can use delete from newtable;But one of the worst things about this approach is that the new

The first scenario:The use of recursive algorithms is also the most frequently used, most open-source programs are the same, but generally only use the level four classification. The database structure design of this algorithm is the simplest. A

About MySQL OptimizationBecause the page static technology can realize the cache of dynamic data, sometimes it is necessary to request the database. Therefore, the optimization of the database is also indispensable.Optimization ideasDesign: Storage

Tagged: mysql mysql lock MySQL gap MySQL gap lock MySQL Lock detailedThe way the MySQL lock is different depending on the isolation level, because the default isolation level is Repeatable-read repeatable read, we generally understand that the

MySQL Replication is an asynchronous copy process, copied from one MySQL instace (we call Master) to another MySQL instance (we call it Slave). The entire replication process between Master and Slave is done primarily by three threads, of which two

After MySQL installation, after landing found only two database:mysql> show databases;+--------------------+| Database |+--------------------+| Information_schema || Test |+--------------------+,mysql> use MySQLERROR 1044 (42000): Access denied for

#!/bin/bash#记录备份的时间echo "-----" $ (date + "%y-%m-%d%h:%m:%s") "-----" >>/data/backup_mysql/record.log#定义变量Myuser=rootmypassword=29749716# @HeiniaoSocket=/data/mysql/mysql.sockmycmd= "Mysql-u $MYUSER-p$mypassword-s $SOCKET"mydump= "Mysqldump-u

I. Purpose of the backupDisaster recovery: Recovering and restoring corrupted dataChange in demand: the need to restore data to change before it changesTest: Test whether new features are availableIi. issues to be considered in backupCan tolerate

Apache:If using RPM package installation, the installation path should be in the/ETC/HTTPD directoryApache configuration file:/etc/httpd/conf/httpd.confApache Module Path:/usr/sbin/apachectlWeb directory:/var/www/htmlIf the source code is installed,

To export MySQL query results as CSV, you will typically use PHP to connect to MySQL to execute the query, and then export the returned query results using PHP to generate CSV format.But this is more troublesome, requires the server to install PHP

"Introduction to the Background"during the use of SQL Server database, you must have had to solve a variety of problems experienced, many times, will be in everyone's blog to see Problems and solutions. Now that the development is using the MySQL

The master-slave is the simplest single master-slave copy (i.e., a master and a slave. No matter what the engine backup and multi-Slave, the basic topology diagram for this master-slave structure is seen below:Establishing a primary master-slave

An error is returned when the MySQL-emoji emoticons are stored. Solution: Replace the character set utf8 --> utf8mb4 This article reposted an article published on the public platform.   A developer reported a problem last week: the front-end

[Reprinted] the difference between the delete table and the truncate table is tabletruncate. The general syntax format for deleting data using the delete statement: Delete [from] {Table_name, view_name} [Where] Delete all row data in the XS

MySQL startup Principle Analysis, mysql Principle AnalysisIntroduction This article focuses on viewing the MySQL startup command code to learn more about the MySQL startup process. It is important to understand the MySQL startup principle and be

Secure Mysql binlog deletion and mysqlbinlog Deletion Introduction: If you have set up master-slave synchronization for Mysql or enabled log-bin for the database, a large number of log files will be generated in the data directory of your database