MySQL

1. phpMyAdminPhpMyAdmin is the most common MySQL maintenance tool. It is a MySQL management tool developed using PHP Based on the Web architecture on the website host. It supports Chinese characters and is very convenient to manage databases. It is

MySQL prepare Syntax:PREPARE statement_name FROM preparable_ SQL _statement;/* definition */EXECUTE statement_name [USING @ var_name [, @ var_name]...];/* EXECUTE the preprocessing statement */{DEALLOCATE | DROP} PREPARE statement_name/* delete

Copy codeThe Code is as follows:Create database MyDbOn(Name = mainDb,Filename = 'C: \ MyDb \ mainDb. mdf ',Size = 10,Maxsize = 100,Filegrowth = 4),(Name = secondDb,Filename = 'C: \ MyDb \ secondDb. ndf ',Size = 15,Maxsize = 28,Filegrowth = 2)Log

As the company's website traffic grows, MySQL naturally becomes a bottleneck. Therefore, I have been studying MySQL optimization recently. The first step is to naturally think of MySQL system parameter optimization, as a database system for a

First download can be from its official site point http://www.phpmyadmin.net/download. Different program compression methods are provided for download on the site. Here I select bzip2 for download (because the file size is smaller, other formats can

The output result of the processlist command shows which threads are running. This command can be used to identify problematic query statements.1. Enter mysqladmin processlist In the mysql/bin directory;2. Start mysql and enter show processlist;If

The script is as follows:Drop table table1;Create table 'Andrew '. 'table1'('Name' VARCHAR (32) not null,'City' VARCHAR (32) NOT NULL)ENGINE = MyISAM;Insert into TABLE1 (name, city) values ('person A', 'bj ');Insert into TABLE1 (name, city) values ('

Solution:1. Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql on the computer of localhost, and change the "host" entry in the "user" table in the

The following is an implementation method. The idea is to try to use an incorrect statement in the trigger to interrupt code execution.Mysql> create table t_control (id int primary key );Query OK, 0 rows affected (0.11 sec)Mysql> insert into

Step 1-install MySQL Download this server, MySQL GUI tool, and MySQL ODBC driver from http://dev.mysql.com/downloads. You can select 5.0, 5.1, or 6.0 servers. Then install them.Precautions during installation:Your Firewall should be set to allow

1. Connect to the mysql database 1. Open cmd to enter the dos window.2. Switch to the directory: D: \ MySql5.0 \ mysql-5.0.51b-win32 \ bin (that is, the bin directory under the mysql installation directory, which contains a lot of exe execution

Mysql my. ini configuration file details# BEGIN CONFIG INFO# DESCR: 4 gb ram, only InnoDB, ACID, a small number of connections, large queue Load# TYPE: SYSTEM# END CONFIG INFO## This mysql configuration file example is for 4 GB memory# Mainly use

1. Use the SHOW statement to find out the current database on the server: Mysql> show databases;+ ---------- +| Database |+ ---------- +| Mysql || Test |+ ---------- +3 rows in set (0.00 sec)2. Create a database, abccsMysql> Create DATABASE

MySQL performs a full table scan under the following conditions:1> the data table is too small, and a full table scan is much faster than the search for the index key. This is usually done when the total number of records in a table is less than 10

1. Call method of myisamchkMyisamchk [options] tbl_name...Options specifies what you want myisamchk to do.It allows you to specify all tables in a directory by using the "*. MYI" mode.Shell> myisamchk *. MYIWe recommend that you quickly check all

Character_set_client, which is the character set that the user tells MySQL to query.Character_set_connection. After MySQL receives the user query, it converts it to the character set character_set_connection according to

If TMPDIR is not set, MySQL uses the default value of the system, usually/tmp,/var/tmp, or/usr/tmp. If the file system that contains the temporary file directory is too small, you can use the "-tmpdir" option for mysqld to specify a directory in the

If you want to run multiple servers, the easiest way is to recompile the server with different TCP/IP ports and socket files, so they do not listen on the same TCP/IP Port or socket.Assume that an existing server is configured as the default port

Differences:1. truncate and delete: delete only data. Do not delete the table structure (Definition)The drop statement deletes the constraints (constrain), triggers (triggers), and indexes that the table structure is dependent on.Stored

PrincipleQueryCache (QC) is cache based on SQL statements. If an SQL query starts with select, the MySQL server will try to use QC for it. Each Cache is saved using SQL text as the key. SQL text is not processed before QC is applied. That is to say,