MySQL

The basic idea is: In JS dynamically create Select control option, through Ajax to obtain in PHP from the SQL database to obtain the city and province information, the code is a bit long, but many are similar, such as JS in the province, the city,

Some time ago purchased the Aliyun host. Because you need to use the Java environment instead of Php+apache this one-button installation of things, so did not download the Aliyun official online said Sh.zip. Besides, there is no gzip in this

MySQL 5.5.13 Parameter description: [Client] Character-set-server = UTF8 Port = 3306 Socket =/data/mysql/3306/mysql.sock [Mysqld] Character-set-server = UTF8 user = MySQL Port = 3306 Socket =/data/mysql/3306/mysql.sock Basedir =/usr/local/

Status = Show status like '% percent ' [example: Show status like ' Com_select ']variables = Show variables like '% percent ' [Example: show variables like ' query_cache_size '] 1, MySQL query times (status)Com_select; Com_update; Com_insert;

Create a table The Simple Way Copy Code code as follows: CREATE TABLE Person ( Number INT (11), Name VARCHAR (255), Birthday DATE ); Or is Copy Code code as follows: CREATE TABLE IF not EXISTS

Creating a Database The simplest way: Copy Code code as follows: CREATE DATABASE my_db; Or is: Copy Code code as follows: CREATE DATABASE IF not EXISTS my_db; To create a UTF8-encoded database:

Recent web site traffic has increased significantly, there may be some channel programs also have some problems, causing the MySQL database appears forcing close of thread 28790 user error. How can you solve this situation if you encounter it? Icech

This article mainly introduces the main usage of the show command in MySQL database A. Show tables or show tables from database_name; --Displays the names of all tables in the current database. B. show databases; --Displays the names of all

This article describes the MySQL to get group by total record row number of methods, share for everyone for reference. The specific methods are analyzed as follows: In general, MySQL gets the total number of records grouped by the group by

In actual demand, the contents of a certain table must be replaced in bulk, the ordinary thinking process is as follows:Select outStr_replace replacementUpdate WriteActually this is extremely wasteful of resources and consumes resources, MySQL built-

#Path to installation directory. All paths are usually resolved relative to this.Basedir= "D:\MySQL Server 5.1/"#Path to the database rootDatadir= "D:\MySQL Server 5.1/data/" However, because it is not installed, the service is not generated and

Without warning, MySQL went on strike. After starting with the Mysql.server startup script, there is no hint that the message ends, and the mysqld process is naturally not up. Put the mysql.server inside $bindir/mysqld_safe--datadir=

The PHP code is simple: Copy Code code as follows: $server = "127.0.0.1"; println ("Begin"); $link = mysql_connect ($server, "MySQL", "MySQL"); if (! $link) { Die (' Could not connect: '. Mysql_error (). Mysql_errno ()); }

(1) The simplest method of modification is to modify the character set key values in the MySQL My.ini file ,such as Default-character-set = UTF8Character_set_server = UTF8 After the modification, restart the MySQL services, service MySQL restartUse

This article describes the MySQL set trigger permissions method, the situation is very useful for permissions errors. The specific analysis is as follows: The MySQL import data hint does not have the Super Privilege permission processing, as

Add a table field ALTER TABLE table1 add transactor varchar (a) not Null; ALTER TABLE table1 add ID int unsigned not Null auto_increment primary key Modify the field type of a table and specify null or Non-empty ALTER TABLE name change field

There are two ways to backup data in MySQL : 1. Mysqlhotcopy This command locks up the table before copying the file and synchronizes the data to the data file to avoid copying to the incomplete data file, which is the safest and quickest way to

First, limit the concurrent processing of innodb. If innodb_thread_concurrency = 0 can be changed first to 16 or 64 to see machine pressure, ifVery large, first changed to 16 to let the machine pressure down, and then gradually increase to adapt to

Scenario One: Using the Ignore keyword If the uniqueness of the record is distinguished by the primary key primary or unique index unique, it is possible to avoid duplicate insertion records: Copy Code code as follows: INSERT

MySQL root password is correct, but how can not log in MySQL from the local, prompted Copy Code code as follows: ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes) Here, after a high