MySQL

Installation environment Centos 1, 5.4 MySQL 5.1.xx is directly installed using rpm Xtrabackup 1.2.22 directly installed with RPM CopyCode The Code is as follows: [mysqld] Server-id = 1 Log-bin Innodb_flush_log_at_trx_commit = 1 Sync_binlog =

Select statement to remove duplicate information of a field, for example: Table Name: Table Id uid username message Dateline 1 6 A 111 1284240714 (timestamp) 2 6 A 222 1268840565 3 8 B 444 1266724527 4 9 C 555 1266723391 Execute the statement

Environment variable settings: Right-click my computer on the desktop and choose Properties> advanced> environment variables> double-click the path to add the C: \ mysql5.1.40 \ bin directory. If you want to use SDK development, add the lib and

Store the backup database under the D: root directory. The backup database name is backup20070713. SQL (20070713. SQL indicates the backup date) Back up the database: Mysqldump-uroot-p123456 database_name> D:/backup20070713. SQL Restore

1. Create a database and a Registry CopyCode The Code is as follows: Create Database db_register; Create Table db_register.tb_register ( Reg_loginid varchar (20) primary key, Reg_name varchar (20) not null, Reg_id int not null, Reg_password

In MySQL, The auto_increment type Id field is used as the primary key of the table and as the foreign key of other tables to form a "master-slave table structure". This is a common usage in database design. However, when an ID is generated, the

CopyCode The Code is as follows: $ Pai_dbhost = 'localhost'; // MySQL host $ Pai_dbname = 'sq _ test'; // Database Name $ User_dbuser = 'root'; // database username $ Export _dbpwd = 'jb51. net'; // Database User Password $ Pai_db_language = 'utf8';

CopyCode The Code is as follows: $ Memcached = array (// use the memcached multi-process to simulate multiple memcached servers. The cn En is the name of the memory server. 'Cn' => array ('192. 168.254.144 ', 192 ), 'En' => array ('192. 168.254.144 '

I, Remove the ";" before the following parameters in PHP. ini: CopyCode The Code is as follows:; Extension = php_dba.dll ; Extension = php_gd2.dll ; Extension = php_mbstring.dll ; Extension = php_mcrypt.dll ; Extension = php_mysql.dll ; Extension =

The following Article This section mainly describes the actual operation procedures of some records of MSSQL to MySQL database, as well as the problems found in its actual operations, including table creation and encoding problems, the following

After query, I know that the MySQL field is too long, so I just changed the length of the two fields. When an index is created, the length of the key calculated by the database is to accumulate the char length of all the fields used by the index,

Put the script in/home/user/mysql_backup.sh Crontab # Crontab-l # M h Dom mon Dow command 28 16 ***/home/user/mysql_backup.sh The script is as follows: CopyCode The Code is as follows :#! /Bin/sh # Mysql_backup.sh: Backup MySQL Databases and keep

1> extract the compressed file mysql-noinstall-5.1.6-alpha-win32.zip to a directory, set mysql_home in the environment variable, and add % mysql_home % \ bin to path. 2> Create my. ini configuration file, content: [mysqld] # Set basedir to MySQL

The solution to reduce such problems is to minimize the server power failure without reason. When the server is shut down, the mysql database is closed manually. Let's take a look at this problem: Can't open file: '×××. myi' (errno: 145). This

We often use the MySQL replace function. The following describes the usage of the MySQL replace function in detail, hoping to enlighten you in learning the MySQL replace function. I recently studied CMS and used mysql replace function during data

A beginner often asks me how to back up the database. The following describes three methods to back up the database:(1) Back up database files Each database and data table in MySQL correspond to the directory in the file system and the files under

1. You can set collation for a table or row to binary or case sensitive. In MySQL, the naming conventions for Column Collate are as follows: * _ Bin: binary case sensitive collation, that is, case sensitive.* _ Cs: case sensitive collation, case

1) install Centos 5, Http://mirrors.sohu.com/centos/5/isos/i386/ Disable selinux and firewall during installation 2) install necessary componentsLANG = CYum-y install gcc-c ++ autoconf libjpeg-devel libpng-devel freetype-devel libxml2 libxml2-devel

The following articles mainly introduce the practical use of MySQL ALTER syntax. We all know that the proportion of MySQL ALTER syntax in actual application is still very large, so you can have a good idea about the practical use of MySQL ALTER

After installing ubuntu for a long time, I never used it. during the National Day, I had to go over and configure some basic development environments. As soon as I got started, I felt like ubuntu, and I couldn't tell why. Xampp was installed to test