MySQL

MySQL Incremental recovery processCreate a table for testingMysql> CREATE table User (name char (ten), age int (3)); Query OK, 0 rows affected (0.07 sec) mysql> desc user;+-------+----------+------+-----+---------+-------+| Field | Type | Null | Key

A period of time before writing a version of the release tool, using the EXPRESS+MYSQL implementation, when the site is running a long period of blank time, the node process will automatically down, prompted the MySQL connection error, Google found

Index is the directory of data, can quickly locate the location of the data, index to improve the query speed, but reduce the increase, delete, change the speed, generally in the query frequency is high and low repetition of the column added.Index

Select curdate(); --Get the current dateSelect Last_day(curdate()); --Get the last day of the month. Select Date_add(curdate(),interval - Day(curdate())+1 Day); --Get the first day of the monthSelect Date_add(curdate()- Day(curdate())+1,interval 1

Import java.sql.*;p Ublic class Mysqlbean {private Connection con = null; Private ResultSet RS; Private String drivername = "Com.mysql.jdbc.Driver"; Private String serverName = "localhost"; Private String MyDatabase = "user"; Private

[Understanding Index]To understand an index, you first need to understand how the data is stored on your hard disk. Different storage engines may not take the same action, for example, the MySQL client defaults to MyISAM, which creates a separate

Sometimes you write your own tools to get a variety of table information from a remote database, so you get the data dictionary first.Make a list of how MySQL gets Use Information_schema; Select from schemata; Select from where

Write in frontThe previous article describes the MySQL additions and deletions to the operation, this article will introduce the group and order by operation.Series ArticlesMySQL CREATE database, create data tableMySQL's

Heartbeat+drbd+mysql High-availability1. Planningvip:192.168.1.30Myhost1:Intranet ip:192.168.1.11Heartbeat Heartbeat ip:192.168.74.11DRBD Transport ip:192.168.223.11Myhost2:Intranet ip:192.168.1.12Heartbeat Heartbeat ip:192.168.74.12DRBD Transport

Think of a question:1/3+1/3+1/3=1.00.3+0.3+0.3 =0.9Think about what it means to be 1/3 in a decimal world! Its approach is to take a 1/3 very close to the decimal place, as in the example above the 0.3来 instead of 1/3, so the problem is to be stored

Create a test tablemysql> desc; +-------+-------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-------+-------------+------+-----+---------+----------------+| ID int(one) | NO |

General SQL output specifies that the ID needs to be sorted, and the result output above has some uncertainty. Requirements by55,6,5,173,176,174,175,177Output results in the sequential order.The result is sometimes not just reverse order, the

1. View installed installation packagesRpm-qa | Grep-i MySQLMysql-server-5.0.67-1.sles11libqt4-sql-mysql-4.6.2-1.6.11libmysqlclient15-5.0.67-13.20.1php5-mysql-5.2.6-50.24.1Mysql-client-5.0.67-1.sles11libmysqlclient_r15-5.0.67-13.20.12. Delete

1. Now take the menu table as an example to create a table Test_menu in the database.2. Create some instance data in the tableNow the menu level for Cd_1 and Cd_2 for a first-level menu, Cd_1 is divided into cd_1_1 and cd_1_2 two level two menu, Cd_1

Lost connection to MySQL server at 'reading authorization packet 'Solution Mysql Version: 5.1.73 OS Version: Centos 5.9 Problem description: Today, an error is reported when a php program connects to Mysql from a client. The information is as

Mysql sorts the output result with the specified ID number SELECT * FROM 'cms _ hit' WHERE aid in (55,173,177,174,175,176) Generally, the specified ID of the SQL output needs to be sorted, and the output of the above results has certain

MongoDB and MySQL operations On the left is the mongodb query statement, and on the right is the SQL statement. It is easy to use. Db. users. find () select * from users Db. users. find ({"age": 27}) select * from users where age = 27 Db. users.

Mysql Chinese garbledAlthough mysql is installed on the computer, I have never studied the problem of modifying the encoding. I usually use Pinyin instead of Chinese characters, because I am doing some simple syntax exercises, I am not very

MySQL settings allow users to log on remotely The basic system was deployed on the server yesterday. Everything is normal. However, the developer needs to remotely Access the MySQL database on the server and finds that the root remote connection

Problems encountered during Mysql trigger usage [1054] Unknown column 'xxxxx' in 'where clause' Drop trigger if exists 'delete _ actdata '; create definer = 'xxxxxx' @ 'localhost' TRIGGER 'delete _ actdata' BEFORE delete ON 'actdata' for each