MySQL

MySQL Tens data table, creating table and field extensions for several suggestionsOne: OverviewWhen we design a system, we need to consider the system after a period of time, the table data volume about how much, if in the early days, it can be

Date_format (DATE,FMT)Date value formatted as String FMTFormat (x, y) formats x as a comma-separated sequence of numbers, and Y is the number of decimal digits of the resultInet_aton (IP) Returns the number representation of an IP addressInet_ntoa

MySQL Database A database is a collection of data that is stored in a certain way, shared for multiple users, as redundant as possible, and independent of the application. There are three types of data on the Earth at this point:

1. Table name:CustomerProperties: ID character type maximum of ten characters--Customer numberName character type maximum of three characters--Customer nameSex character type Max 2 characters--genderMobile character type maximum one

In practice, it is sometimes necessary to import large-capacity SQL files to MySQL, usually in the following three ways:(1) through phpMyAdmin, not recommended, there is memory and other restrictions;(2) running SQL through Navicat Premium tool, not

Solved the import and export problem of MySQL GBK encoding, thanks to the author.First, import data1, determine the database default encoding, such as encoding for GBK, the read-in path encoding is also set to GBK, the command is:Set names GBK;2,

It's a good idea to use the merge storage engine middleware to implement MySQL sub-table.Can look at this blog written very clearly--http://www.cnblogs.com/xbq8080/p/6628034.htmlIn addition, the use of triggers is as follows:1 ## MySQL Trigger2 3 T1

A. Yum installation mysql5.61. Install the warehouseto install MySQL using yum, you need to use the Yum repository in MySQL to download the appropriate system repository from the official website first .http://dev.mysql.com/downloads/repo/yum/ then

Database: MySQL, Version: 5.1.45Query Statement 1:Select ID, Settlement_begin_time, settlement_end_time from Mkt_vendor_settlement_brief where settlement_begin_time >= ' 2017-09-01 00:00:00.0 ' and Settlement_end_time Results:Query Statement

One, create the user:Command: CREATE USER ' username ' @ ' host ' identified by ' password ';Description: Username-the user name that you will create, host-Specifies which host the user can log on to, if localhost is available to local users, you

Ubuntu Server mysql5.9The Enable function edits the MySQL configuration file on the master and slave server separately#vim/ETC/MYSQL/MYSQL.CONF.D/MYSQLD.CNF Add the following two linesbind-address = 0.0.0.0 #修改为允许任意服务器访问Log-bin=mysqlServer-id=1

LOAD DATA [Low_priority | CONCURRENT] [LOCAL] INFILE ' file_name.txt ' | IGNORE] into TABLE tbl_name [ Fields ' string '] ' char '] ' char ' ] ] [LINES ' String '] ' string ' ] [number LINES]

Guoguos-macbook-pro:myblog guoguo$ mysql-uroot-p123456 MySQL: [Warning] Using a password on the command line Inter Face can be insecure. Welcome to the MySQL monitor.  Commands end with, or \g. Your MySQL Connection ID is 3334 Server version: 5.7

Remote Link Database:Log in to the remote MySQL command:/** Use the root user link 172.20.60.2 port 3306 below the MySQL spectergk database*/mysql-h 172.20.60.2-p 3306-u root-p spectergkEnter password to report the following error: Error 1130 (HY000)

Standalone index:A stand-alone index refers to an indexed column that cannot be part of an expression, or a function's argument　　Example 1:SELECT actor_id from actor where actor_id+1=5-this notation, even if indexed on actor_id, is not

One. Download MySQL unpacking packageThere is no Data folder in the Unpacked folder.Two. Create the file 1.Create a my.ini file under the root directoryThe contents are as follows:[Mysqld]# Set up the MySQL installation directory Basedir=d:\mysql-5

The following error occurred in the last step of the MySQL installation:And this is the problem that occurs when the firewall is turned off.The reason is: the previously installed MySQL is not uninstalled cleanly.To uninstall the MySQL step:1. First

1. Basic View and login:Mysql-uroot-pshow databases; # #查看数据库Use MySQL; # #进入数据库mysqlShow tables; # #查看表DESC user; # #查看表的结构, table header2. Operation of the table: check, change, delete, increaseSELECT * from user \g; # #查询user表中的所有数据记录Select

While for exampleDROP PROCEDURE IF EXISTS Zy.test_pro;DELIMITER $$CREATE PROCEDURE Zy.test_pro (in ID INT)BEGINDECLARE num INT;SET Num=1;While Num INSERT into Zy.test VALUES (num,concat (' Test ', num));SET num = num +1;END while;END;RepateDelimiter/

Mysqldump and mysqlbinlog, mysqldump1. mysqldump 1. Back up the test database #mysqldump -uroot -p'123' test >test.sql   2. Backup-B Parameters # Mysqldump-uroot-p '000000'-B test> test_ B. SQL -- B has the create DATABASE, and use #