MySQL

I believe that you have had reinstallation experience when using MySQL. If you reinstall MySQL, it is basically the last step. Unless you reinstall the operating system, the reason is that the registry in the system is not deleted. The following is

1. Add the primary key (primary key index)Mysql> alter table 'table _ name' add primary key ('column ')2. add UNIQUE (UNIQUE index)Mysql> alter table 'table _ name' add unique ('Column')3. Add an INDEX (Common INDEX)Mysql> alter table 'table _ name'

If you back up your data, ignore it.If the data is too big, use the database client software to directly import the data into the memory, or execute SQL directly.1. Specify the file path.2. fields are separated by commas, and data rows are separated

InMysqlClient andMysqlThere is a character set converter between servers. Character_set_client => gbk: the converter knows that the client sends the gbk encoding. Character_set_connection => gbk: Convert the data transmitted from the client to the

After MySQL is installed, a root user and an anonymous user will be automatically created, which is ignored by many users, this is probably because anonymous users are set to be only available locally by default.However, if MySQL is to be used as a

They will discuss the statements that return data, such as INSERT and statements that do not return data, such as UPDATE and DELETE. Then they will write a simple program to retrieve data from the database.Execute SQL statementsNow we have a

For the sake of security, you need to back up or restore the database frequently. For MySQL, the most convenient method is to use the Export and Import functions of phpMyAdmin. However, if your database is large, phpMyAdmin, a Web application, may

I. Evolution: The maximum length of the MySQL database varchar type in versions earlier than 5.0.3 is 255, and its data range can be 0 ~ 255.In MySQL 5.0.3 and later versions, the length of the varchar data type can reach 65535, that is, 65532 bytes

1. How to create an independent account and Set permissions Here I use Navicat as my database management tool to open Navicat. Select "user" -- "create user" Enter the user name, host, and password. Note that the host name is not "localhost",

The following describes two sorting implementation methods and implementation diagrams through examples:Assume that two tables, Table A and Table B, have the following structures:Sky @ localhost: example 01:48:21> show create table AG* **************

Example: select (a + B) as c from tableBoth types are varchar type, but the display is incorrect.Until concat ()Concat functions in MySQLThe following example describes how to use the concat function in MySQL, such as select concat ('11', '22', '33 '

Copy codeThe Code is as follows:# Create a trigger. When a record is added to the order table, update the goods table.Delimiter $Create trigger trigger1After insert on 'order'FOR EACH ROWBEGINUPDATE goods SET num = num-new.much WHERE id = new.

Mysql Master/Slave configuration note: There are four machines in total: A (10.1.10.28), B (10.1.10.29), C (10.1.10.30), and D (10.1.10.31 ).After the configuration result: the A-C is the master and slave, B is the slave of A, D is the slave of C.0)

The following excerpt describes utf8_unicode_ci and utf8_general_ci In the Mysql 5.1 Chinese manual:Currently, utf8_unicode_ci rules only support Unicode rules. Some characters are not supported. In addition, the combination of tags cannot be fully

Developers often find that they do not use indexed or limit n statements, which will have a great impact on the database, for example, a large table with tens of millions of records needs to be fully scanned, or filesort is constantly performed,

A MySQL table can be considered as a queue, with each row being an element. Each query gets the first row that meets a condition, and deletes it from the table or changes its status so that it will not be obtained in the next query. Without

1. Calculate the number of years You figured out how old this person is on your birthday.Copy codeThe Code is as follows:SELECT DATE_FORMAT (FROM_DAYS (TO_DAYS (now ()-TO_DAYS (@ dateofbirth), '% y') + 0; 2. Difference between two time points

Copy codeThe Code is as follows:Update dede_addonsoft SET dxylink = REPLACE (dxylink, '.zip ', '.rar') where aid> 45553;Copy codeThe Code is as follows:Update 'table _ name' set field = replace(field,'.rar','.7z '); Table_name: name of the table to

1. Back up data on the Management node.Ndb_mgm> start backup nowaitNdb_mgm> Node 3: Backup 4 started from node 1Node 3: Backup 4 started from node 1 completedStartGCP: 43010 StopGCP: 43013# Records: 2138 # LogRecords: 0Data: 53068 bytes Log: 0

1. How to obtain the latest MySQL version?To install MySQL, you must first obtain the latest version of MySQL. Although we all know that MySQL can be found in FreeBSD Packages, I suggest you go to the network to find the latest version of MySQL. I