MySQL

A MySQL database server that has been running for a long time is normal. Because of corruption from the database server hardware, you need to re-import the database for synchronization. When performing the operation again, forgot to enter the option-

I experienced this error while trying to alter one of the my stored procedures remotely on a master server. After some, I ended the getting information from "Binary Logging of Stored Programs".From MySQL Reference in verbatim:When you create a

MySQL query a lot of ways, the following for you to introduce the MySQL query is to query this week, last week, this month, the last month's data, if you are interested in MySQL query, may wish to seequerying data for the current weekSELECT

The Host column specifies the IP that is used to allow the user to log on, such as User=root host=192.168.1.1. This means that the root user can only access it through the 192.168.1.1 client.and% is a wildcard, if host=192.168.1.%, then it means

replication with the MySQL row format slave often encounter replication errors 1062 and 1032 error, usually mirror abnormal downtime caused by the master-slave replication data inconsistency, but some libraries themselves are large, the cost of

You need to install: Devel,client,server1, first of all to see if there is already installed MySQL, in order to avoid conflict# Rpm-qa | grep MySQL2. Uninstall conflicting versions# RPM-E Mysql-version//To unload the passenger service and server

Before I played OpenFire Source compiled, deployed, with the built-in database, just curious. Now for OpenFire to understand a little bit, try to use MySQL to reconfigure the latest OpenFire server, so that visualization, extensibility is

An exact numeric data type that uses integer data.bigintInteger data (all numbers) from -2^63 (-9223372036854775808) to 2^63-1 (9223372036854775807). The storage size is 8 bytes.IntInteger data (all numbers) from -2^31 (-2,147,483,648) to 2^31-1 (2,1

First, sortSELECT * FROM Employees order by name;Character-Type default character order (that is, z is always greater than a), regardless of case, if you want to sort by encoded values (that is, lowercase is always greater than uppercase), use

MySQL master-slave replication configurationPrimary server: 192.168.0.100From the server192.168.0.101Primary server ConfigurationMy.ini (Window under Linux is

MySQL add user, new database, user authorization, delete user, change password (note that each line followed by A; indicates that a command statement ends):1. Create a new user1.1 Log in to MySQL:@>mysql-u root-p@> Password1.2 Create User:mysql>

Scenario: Sometimes the binary files in the disk are deleted due to disk corruption or human error, resulting in a mismatch between the show binary logs record in MySQL and the binary file in the actual physical disk#binlogdiff. Sh#!/bin/sh#[email

Querying the MySQL transaction isolation level querying the MySQL transaction isolation levelCategory: DB2011-11-26 13:12 2517 People read Comments (0) favorite reports Mysqlsessionjava1. View the current session isolation levelSELECT @

Linux (here is CentOS), after MySQL installation, the database data is stored by default in the/var/lib/mysql directory, if the directory is loaded with little disk space, not enough, you need to migrate to other directory locations.Method One:Refer

Running two MySQL instances on the same serverIt's not that complicated, two MySQL instances use different directory stores, use different port accesses, and load different configuration files.If there are two MySQL A and bMYSQL A is a

Before learning about the stored procedure, first understand the mysql control structure. Similar to C language (if ...... Else, while loop, etc.) SQL also has its own control structure. If ...... Else control structure: For example: (1) if

My experiences with MYSQL (12) My experiences with MYSQL (1) My experiences with MYSQL (2) My experiences with MYSQL (III) My experiences with MYSQL (4) My experiences with MYSQL (5) My experiences with MYSQL (6) My experiences with MYSQL (7) My

1. Trigger: Create trigger trigger_name trigger_time trigger_event ON tbl_name for each row trigger_stmtTrigger_name indicates the trigger name, which is specified by the user; trigger_time indicates the trigger time, which is replaced by before and

Using Delphi 7 to connect to MySql 5.5.151.ODBCYou must first have the MySql ODBC driver. I downloaded the fully-installed version, including the MySql server, various supported connections, workbench, sample database, and documentation. If there is

Typical MYSQL problems: (ERROR 1366 (HY000): Incorrect string value: '\ xD5 \ xD4' for column 'name' at row 1) There are a lot of posts on the Internet to solve Chinese Garbled text, basically speaking about modifying % MYSQL_DIR %/my. ini