MySQL

Fix it: My actual operation under Windows is as follows1. Close the running MySQL.2. Open the DOS window and go to the Mysql\bin directory.3. Enter mysqld-nt--skip-grant-tables carriage return. If you don't get a hint, that's it. 4. Open a DOS

*innodb_buffer_pool_size If you use InnoDB, then this is an important variable. Compared to MyISAM, InnoDB is more sensitive to buffer size. Mysiam may also be fine with the default key_buffer_size for large amounts of data, but InnoDB feel like

The important thing is the above mentioned: INSERT ... SELECT INSERT ... On DUPLICATE KEY UPDATE INSERT ... On DUPLICATE REPLACE For example, to insert a piece of data into a table, if the table does not have that data inserted, if the data

1 installation. MySQL is installed in the/usr/local/mysql directory. The code is as follows Copy Code Yum-y Install Perl PERL-DBIwget http://file.111cn.net/upload/2013/12/DBD-mysql-3.0002.tar.gzTar zxvf

Remote access Mysql-h localhost-uroot-p Modify password Mysqladmin-uroot-proot Password Admin If the original password is empty Mysqladmin-uroot Password Admin Display version number, status, process information, etc. Mysqladmin Version

The actual line of the scene is more complex, then involved in the TRUNCATE, delete two operations, confirmed lost data almost 70,000 lines, and so on stop, almost a total of more than 10,000 rows of data written. Here for a simple explanation, just

1. Create a database. The CREATE DATABASE statement is created in MySQL. The format is as follows: Create DATABASE db_name; Db_name is a database name and must be a valid name. The following provisions are provided: A. Cannot have duplicate names

The code is as follows Copy Code SELECT * from TB where c> date_format (' 2007-07-06 ', '%y%m%d ') and C SELECT * from TB where c> date (' 2007-07-07 ') and c Statday is a Date data field of type 2006031001 The

The now () function gets the current date and time:Select Now ();/*+---------------------+| Now () |+---------------------+| 2009-05-18 20:11:24 |+---------------------+1 row in Set (0.02 sec)* * Ah, this function is often used by me, nothing just

MysqlimportExamplemysqlimport-uroot-p123456 Test/tmp/mytbl.txt;Convention: The last part of the file name is the table name, and the above statement is imported into the table MytblMysqlimport must specify the database, the above statement database

MySQL stored procedure instanceTechnical points A stored procedure includes a name, a list of arguments, and a set of SQL statements that can include many SQL statements. The following is the process of defining a stored procedure: CREATE

MySQL Replace into instance tutorial Replace into and insert into the difference, I and he said in the evening my blog look at that time is busy, now from the MySQL manual to find something, the MySQL manual said replace into said or more detailed.

The first step should be to do is to troubleshoot problems, to find bottlenecks, so, start with the logTurn on slow query log Mysql>show variables like "%slow%"; To view the slow query configuration, not add to the MY.CNF, as

The code is as follows Copy Code Mysql-u root-pmysql> use MySQL;Mysql> grant all privileges in *.* to root@ '% ' identified by ' root ';Mysql> select Host,user,password from user; + ———— –+--+ ——————————————-+| Host | user |

Modify the phpmyadminconfig.inc.php files in the phpMyAdmin site for this machine Find this line and change the ' localhost ' after [' host '] to remote database IP The code is as follows Copy Code $cfg [' Servers ']

A summary of Linux under the MySQL some of the commands: 1.Linux under the command to start MySQL:Mysqladmin start/ect/init.d/mysql Start (Previous installation path for MySQL) 2.Linux Restart MySQL command:Mysqladmin restart/ect/init.d/mysql

The wrong answer has been adopted, misleading others. Char Max 255 charactersvarchar maximum 65,535 bytes (so, different character sets, the number of characters can be stored differently)Text Max 65535 characters 1)VARCHAR l+1 Byte, where lTEXT l+

Forget MySQL Tutorial password processing method (Linux,windows)Here is a description of the MySQL password processing method, mainly in the different operating systems such as Linux and Windows to retrieve the password method #/etc/init.d/mysql

MySQL tutorials How to create a database tutorial and delete a database Creating table SyntaxCREATE DATABASE ;Quite simply, look at a simple example Mysql>Mysql>mysql> CREATE DATABASE myDatabase;Query OK, 1 row affected (0.03 sec)

Recently, I got a private activity and a warehouse receiving and picking system. The development cycle is from 30 days to 60 days.The final decision of the entire project is implemented using the java client + mysql server. Therefore, some necessary