MySQL

Many developers often do not consider the char and varchar types when designing databases. Some developers do not pay attention to them because the storage price is getting cheaper and cheaper, I forgot some of the basic design theories and

Mysql can use operators to perform operations on data in tables, such as age calculation by birth date. Operators include Arithmetic Operators, comparison operators, logical operators, and bitwise operators. Arithmetic OperatorsAddition, subtraction,

Local Environment: Windows XP system and xampp integrated environment.Xampp installation directory: d:/xampp1. Stop the running MySQL processCopy codeThe Code is as follows:> Net stop mysql If it is not loaded as a service, you can directly close it

In order to install the mysql environment for testing, it was found that mysql occupied a large amount of virtual memory after the installation, which could reach more than 8 hundred megabytes. I searched for it online and got some tips from my. ini.

Recently, mysql Databases have encountered multiple numeric types, including int, bigint, smallint, and tinyint. The difference between int and smallint is confusing. Today, I searched for the following content on the Internet, and made a

Set MySQL in Linux and allow external machines to access sudo vi/etc/my. cnfThe specific directory depends on the specific situation. If some people are installed in the personal directory, you can find the corresponding directory.1. Configuration

Change the Data Type of a column[SQL]Alter table visitor MODIFY nam VARCHAR (30 );Append a new column[SQL]Alter table visitor ADD age INT;Alter table visitor ADD age int first;Alter table visitor ADD age int after nam;Change column

Use the following method (navicat is used for mysql management). Set the values of the following parameters and the following statements can be executed on the mysql console.Copy codeThe Code is as follows:Show variables like '% timeout % ';Show

Event Type: ErrorEvent Source: Service Control ManagerEvent Type:NoneEvent ID: 7034Date: 2012-11-1Event: 9:25:52User: N/COMPUTER: SVCTAG-HZWGF3XDescription:The service MySQL stops unexpectedly. This occurs once.For more information, see Help and

When you installed Mysql on the machine for the first time, you can access the database anonymously or enter the database as a root without a password. in addition, if you are an administrator, you need to establish and authorize some users, which

(1) thoughts on improving database insertion Performance: Try to write Data to the Data File at a time and reduce the checkpoint operation of the database. The following four configuration items are modified:1) set the innodb_flush_log_at_trx_commit

Mysql directly changes the storage path of data files to/etc/my. in cnf, modify the datadir and restart the service. However, I searched for more information from the Internet, most of which were changed to my. in cnf, datadir, sock, and startup

Since the website system was launched, the data volume reaches 500 mb, nearly records. Database Operations are basically slow, and users will feel angry ~~ Then I posted this situation in the group, including the machine configuration and so on.

1. Introduction to XtrabackupA. What is Xtrabackup?Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to InnoDB Hotbackup.Xtrabackup has two main

The first online formatting tool: Instant SQL Formatter Powerful functions, configurable In the second section, similar to the first section, the functions are the same, but they are different UIS. The third one is for MySQL, which was written

Show tables or show tables from database;Explanation: displays the names of all tables in the current database.Show databases;Explanation: displays the names of all databases in MYSQL.Show processlist;Explanation: displays all processes running in

The problem is that when you directly use mysql c api to build an application, a connection can only execute a stored procedure once, no matter how free we use this connection again, there will be a prompt that we cannot execute qurry. I think such

First, when creating a database, be sure to generate the same encoding format of the original database. If the database has been generated, use phpmyadmin and other tools to organize it again to prevent garbled characters caused by inconsistent

1. Optimize Your MySQL query Cache You can enable the High-Speed query cache for queries on the MySQL server. It is one of the most effective ways to improve performance by quietly processing the database engine in the background. When the same

Compared with the replication of NoSQL databases such as MongoDB and Redis, MySQL replication is quite complex!OverviewFirst, the master server records data changes to the master log, then reads the master log on the master server from the server