MySQL

MySQL has the following types of logs:Error log:-log-errQuery log:-logSlow query log:-log-slow-queriesUpdate log:-log-updateBinary log:-log-binWhether the log is enabledMysql>show variables like ' log_% ';How to know the current logMysql> Show

Vi/etc/my.cnfInnodb_data_home_dir =Innodb_data_file_path=/data/mysql/ibdata1:10m:autoextend (for the current ibdata situation)[[email protected] MySQL] #mkdir-P/data2/mysql[Email protected]]# chown-r mysql:mysql/data2[[email protected] scripts]

Excel:Note:1. Create a table in MySQL with the same table structure as Excel (contains ID)2, Excel best without any format, just pure value, otherwise you will not be able to import errors--------------------------------------------------------------

There are a lot of posts on how to change the directory of the MySQL database under Windows server2008, here's a quick step, and if you're not successful, check out other posts first.5.1 \data changed to D:\MysqlData . 1 . Create a folder

First, the database engine　　The Database engine is the core service for storing, processing, and securing data. Use the database engine to control access and quickly process transactions to meet the requirements of most applications that need to

Summary of functions commonly used in MySQL:First, mathematical functionsABS (x) returns the absolute value of XBin (x) returns the binary of X (Oct returns octal, HEX returns hex)Ceiling (x) returns the smallest integer value greater than XEXP (x)

　　chapter I the annoyance of small a ----- why learn a database and how to select a databaseSmall A is a company's staff, the company data department employees, the normal size of work, completely inseparable from the excell, and recently small a

The MySQL database engine depends on how MySQL was compiled when it was installed. To add a new engine, you must recompile MySQL. By default, MySQL supports three engines: ISAM, MyISAM, and heap. Two other types of InnoDB and Berkley (BDB) are also

1. Turn off the MySQL service, turn on the system setup last MySQL, then turn off MySQL first2. Generate a file named Mysql-init, put in the file: a sentence, this sentence different version, the following: (not included in parentheses)Alter user '

Explain shows how MySQL uses indexes to process SELECT statements and join tables. Can help select better indexes and write more optimized query statements.Parse an SQL statement first to see what

1. Download http://dev.mysql.com/downloads/mysql/2. Community > MySQL Community Server3. Other Downloads: > Windows (x86, 32-bit), ZIP Archive5, decompression Mysql-5.7.11-winx64.zip, decompression in D:\soft\mysql-5.7.11-winx64\mysql-5.7.11-winx646,

Requirement: After you insert a record into the MySQL database using MyBatis, you need to return the self-increment primary key value for that record.Method: Specify the Keyproperty property in Mapper, as shown in the following example:id=

User management mysql>use MySQL; view mysql> select Host,user,password from user ; creating mysql> Create user  zx_ Root   identified by ' xxxxx ';  //identified by will use plaintext password encryption as a hash value to store modifications

MySQL create user and give user permissionMethods commonly used by operations personnel:Mysql> Grant all on xiaohu.* to ' [e-mail protected] ' identified by ' 123.com ';Library. TableQuery OK, 0 rows affected (0.01 sec)Grant syntaxGrant all

After the initial installation, use the administrator to enter the CMD interface, Enter "Mysql-u root-p; "," Enter Password: ", direct enter Enter "show databases; "And you'll see the MySQL database, and we'll switch to this database

First, the root of the original myql password;Method One:Outside the MySQL system, use the Mysqladminmysqladmin-u root-p Password "test123" Enter Password: "Enter the original password"Method Two:By logging into the MySQL system,Mysql-uroot-penter

Original address: http://www.jb51.net/article/30164.htmQueue is a commonly used data structure, the basic feature is first-in, first-out, in the transaction and so on to use it, and sometimes with a priority queue. When there is concurrent access to

1. MySQL adds a time interval for the date: Date_add ()Set @dt = Now ();Select Date_add (@dt, Interval 1 day); -Plus 1 daysSelect Date_add (@dt, interval 1 hour); -Plus 1 hoursSelect Date_add (@dt, interval 1 minute); -Plus 1 minutesSelect Date_add (

--The article content through the network search combination,MySQL exception, you can customize the exception, and then apply. You can also use the system default exception to capture the app.First, the exception definition:DECLARE condition_name

Basedir = Path Use the given directory as the root directory (the installation directory). Character-sets-dir = Path Gives the directory where the character set is stored. DataDir = Path Reads the