MySQL

Received SMS alarm, is a R710 hard disk (Raid5 8 block) Bad 1, contact room replacement hard disk, because of the slot problem   changed a few new hard drive after the bright yellow light, and the original 1 hard disk after the change, bright green,

"Copyright Notice: respect for the original, reproduced please retain the source: blog.csdn.net/shallnet, the article only for learning Exchange, do not use for commercial purposes"1. Download the source package first:Ftp://ftp.jaist.ac.jp/pub/mysql/

1.MySQL Basic Command operationAll MySQL commands need to end with a semicolon, and a single command can be written into multiple lines.Connection database:mysql–u root–p;　　View all databases:show databases;　　Creating a database: Create

Samsung index in high-performance MySQLI have a deep question about this:One star: What does the relevant record mean?? (The word is very esoteric, what is the department of "related department")Two stars: If the B-tree (B+tree) index is established,

Transferred from: http://wenku.baidu.com/view/2a54e7892cc58bd63186bd8f.htmlIn the MySQL database ,The comment for a field or column is added with the attribute comment . In the script that creates the new table,You can add a comment by adding the

Install 2 Windows Server servers, install MySQL Separately, configure environment variables, complete the installation confirmation in the CMD window can use the MySQL command Create a Sync account on the master server to ensure that the slave

CMD view MySQL database table when found, unable to insert Chinese data, detected Chinese is also garbled.Method: Locate the My.ini file in the MySQL installation file, add: Default-character-set=utf8The following effects are modified:[Client]port=33

Description of the Oschina MySQL configuration file for sweet potato Open Source: [Client]password        = port            = 3306socket   &NBSP ;      =/tmp/mysql.sock# limit the size of packets received by MySQL server (this is the client incoming

Concat is used to splice strings, such as Select Concat (RTrim (Vend_name), ' (', RTrim (vend_country), ') ') from vendors;Where RTrim is used to remove the right side of the space, concat in multiple strings, connected.In addition, it is usually

3.1 Databases and Data objects1. System Database INFORMATION_SCHEMA: Some database object information in the primary storage system, such as user list information, column information, permission information, character set

The master-slave configuration of the MySQL server, which allows for read-write separation, or can be recovered from the standby after the main library has been hung out.Requires two machines, install MySQL, two machines in a connected LAN, can be

1. allowable values : the range and type of values allowed in a field is the most immediate factor in determining which data type to add to this field.2. storage Efficiency : It is also important to consider the range of possible values for a field

Overview?? The MyISAM storage engine supports only table locks, and there are two modes of table lock in MySQL: Read and write Locks. Their compatibility relationship is (read operations to MyISAM, does not block other users ' read requests to the

OverviewThis article mainly introduces some common SQL optimization techniques.SQL Optimization1.select * FROM table_name where;It is recommended to change the * to the required column. This does not have a noticeable effect on speed, mainly

The name of MySQL master-slave replication is actually: Copy data from one server to another server and execute it again. One server is treated as a primary server (master) and one or more servers as a Slave server (SLave) during the replication

Copy the file to the D disk and the directory.Second, set profile properties "D:\mysql-5.6.24-winx64/my-default.ini" basedir= "d:\mysql-5.6.24-winx64/" datadir= "D:\ mysql-5.6.24-winx64/data/"Third, registration services. Cmd. Right-click

Suddenly remember to write an article about changing the hive metabase from the default local derby to a remote MySQL, and in the cloud note, I turned it over and found it, and now I share it with you.Environment:operating system:

How to access MySQL under DOS1. Go to the MySQL installation directoryCD C:\Program files\mysql\mysql Server 5.6\bin2. User LoginMysql-hlochlhost-uabc-pabc-H: Indicates the server name, Lochlhost is native-U: User name-P: Password, if the user does

Mysql bit operation 1. MOD (X1, X2) calculates the remainder and returns the same remainder as "%" 2. X1 DIV X2 returns the operator for Division. The same as "/" 3. If the divisor is 0, the result is NULL. 4. and = are the same. They are used to

Create a simple tutorial for creating a MySQL database Use mysqladmin to create a database: Special permissions are required to create or delete a MySQL database. Therefore, if you access the database as a root user, you can create any database