MySQL

The distinct (STR) function is used to remove duplicate records, but it is only possible to repeat for a certain field. For example: SELECT DISTINCT (name) from TableName; However, if you want to query the records of other field values, I started

MyISAM: The default MySQL plug-in storage engine, which is one of the most commonly used storage engines in the Web, data warehousing, and other application environments. Note that it is easy to change the default storage engine of the MySQL server

If you need reprint, please specify the source http://blog.csdn.net/slimboy123/archive/2009/07/30/4394782.aspxToday, my colleague, when using MySQL, needs to intercept the specified content in a string.such as the existing string

Syntax 1,Delete table_list_a from Table_list_b where bool_expression;Removes a line of bool expression true from Delete_table_list_a.Example:1.CREATE TABLE T1 (ID int);CREATE TABLE T2 (ID int);CREATE TABLE T3 (ID int);2.Insert into T1 (ID) VALUES (1)

MySQL data cleanupDbname:mytestTable Features: my_table_test_20140701#!/bin/shDbname= "mytest"For month in ' seq-f%02g 1 7 ';d oMysql-h "$ip"-u-p $dbname-S-e "show tables like '%2014${month}% ';" >tablelist_${month}.txtSed-i '/tables_in_mytest/d

1, change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host", from

MySQL database dual-Machine hot backup 1, MySQL database does not have incremental backup mechanismBackup is a big problem when the amount of data is too large. Fortunately, MySQL database provides a mechanism of master-slave backup, in fact, all

The default encoding for MySQL database is latin1, in Linux, you can set this default encoding by modifying the MySQL configuration file my.cnf. You need to add the following code to the

MySQL allows annotations to be used in SQL code. This is useful for reading code. MySQL server supports 3 kinds of annotation styles:1, "#" commentAll characters starting with the "#" character to the end of the line.Mysql> Select @schema; #which

1. mysql Common commandsCreate database name; Create a databaseUse DatabaseName; Select DatabaseDrop database name deletes databases directly and does not alertShow tables; Show TableDescribe TableName; Detailed description of the tableAdd distinct

1, there are error prompts, Slave I/o: Error connecting to master ' [email protected]:3306 '-retry-time:60 retries:86400, error_code:1045 WorkaroundRemove all binary log files from the server, including a master.info file

1, copy of the introductionMySQL supports one-way, asynchronous replication, during which one server acts as the primary server, and one or more other servers act as slave servers. The primary server writes the update to the binary log file and

First, go to the Navicat official website to download the latest version of Navicat. When the installation is complete, open Navicat as shown in:Then click on the connection in the upper left corner to bring up the new key connection information as

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

Share custom functions that extract numbers from strings in Mysql, mysql strings Because a number needs to be extracted from a field in a string in the mysql DATA table, I found it online and finally found an available mysql function, which can

How does Mysql delete a temporary table starting with "# SQL -"? Author: skateTime: 2014/09/28 How does Mysql delete a temporary table starting with "# SQL -"? Phenomenon: after re-indexing, the disk space of the Mysql server is almost full. Run the

MySQL Common commands I am a newbie Learning how to manage and navigate to MySQL Databases and tables is one of the first tasks to be mastered. The following content summarizes some common commands of MySQL Databases and tables, some commands that

Basic MySQL Data Table operation 3: comprehensive example 1. Create a database mysql> create database company;mysql> use company;  Ii. Create a table 1. Create an offices table mysql> create table offices -> ( -> officeCode int(10) NOT NULL

Master-MasterMySQL replication and installation configuration test  I. Architecture  Ii. Install Mysql server The following uses the configuration of DB1 (192.168.0.10) as an example. The configuration of DB2 is basically the same. You only need to

MySQL basics-create a table 1. CREATE a new table create table (Domain Name Data Type column option [...]); Mysql> create table customer (c_id char (5) primary key, c_name varchar (20), c_birth date, c_sex char (1) DEFAULT '0 '); Main options