MySQL

Directory:1. Install MySQL2. mysql file deployment3. mysql Start-Stop command4. Connect to the database5. Manipulating Database commands6. Import and export of data7. Other1. Install MySQL1, install MySQL using Yun, can be installed automatically

To operate a remote Linux server prepare:1, download FileZilla used to upload files to the Linux system2. Download Putty Linux System Operation windowInstalling the JDK1. Check your Linux bits first:Uname-a;Download the corresponding JDK on the

PHP//The encoding of the set character is utf-8, which resolves the Chinese in the URLHeader("content-type:text/html; Charset=utf8 "); //get the variables in the browser URL$dbdatabase=$_get[dbdatabase];$tablename=$_get[TableName];//MySQL account

MySQL Data folder appears mysql-bin log file, through my.cnf comment out log, can delete it?ReferenceHttp://database.51cto.com/art/201107/278988.htmThe source and processing method of mysql-bin.000001 file are introduced in detail.In MySQL database ,

has been used in the 5.1 version, because the new business needs 5.6, installed and made notesMySQL5.6 some new features:InnoDB can now limit the amount of memory consumed when a large number of tables are open (a third party already has

[ERROR]/usr/sbin/mysqld:the table ' cps_effect_confirm_log_1301 ' isToday to a database recovery data, is a 25G library, in the execution of half is, the occurrence of such an errorOne, view the disk space 'DF-DH see that the MySQL directory (not

1. Use the show statement to find out what database currently exists on the server:Mysql> SHOW DATABASES;+----------+| Database |+----------+| MySQL || Test |+----------+3 Rows in Set (0.00 sec)2. Create a database Abccsmysql> CREATE DATABASE

A problem needing attention1. When the database field is a blob type, the setbinarystream (int,inputstream,int) method in PreparedStatement must be used;2. When the database field is longblob type, you must use the setbinarystream

Today suddenly found that we have many tables in the database, suffix named "Copy", is estimated to be a direct copy of the navicat caused, and then to those with the same suffix name of the table to delete, if a choice will be troublesome, the

---restore content starts---error:2014 Commands out of sync; You can ' t run the This command nowI'm really drunk with this error number.Always tangled in why the stored procedure is executed, the commit operation is no longer found in the log of

1st logs divided into three different formatsStatement statement-basedRow-basedMixed compound.Difference:Simple and lean-based statement, the server writes data modification events as SQL statements to binary, content is easier to understandThe

MySQL forgot root password solution:# vi/etc/mysql/my.cnf (added under [mysqld])Press A or I to enter the compilation modeSkip-grant-tablesPress the ESC key to exit the compilation mode: Wq (Save and exit)# service MySQL Restart# MySQL> show

The way to examine the engine is to use mysqlshow, a tool that displays database information at the command line. Mysqlshow is available in the MySQL client installation package. To use mysqlshow, you need to provide the MySQL server login

[Warning] '--log_slow_queries ' is deprecated and would be removed in a future release. Please use '--slow_query_log '/'--slow_query_log_file ' instead.1. Modify the configuration

A MySQL backup related command:MYSQLDUMP-H host name-P Port-u user name-p password (–database) database name > file name. sqlCommands to back up the MySQL databaseMysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlbacking up the

Objective:If your database file is large, you may need to take up a lot of server resources when backing up, so the webmaster should try to choose the minimum period of time to perform automatic backup commands, such as 4-5 o ' Day in the morning.

CentOS Installation Mysql-proxyCentOS Installation Mysql-proxymysql-proxy的用处就不再说了mysql-proxy依赖libevent,lua,glib2等几个软件So before you install it, firstyum install lua-develyum install glib2-develLibevent I use source code installation,Download

Common statements in MySQL:1: Create a table with self-growing primary keyDROP TABLE IF EXISTS user_login;CREATE TABLE User_login (user_id INT UNSIGNED not nullauto_increment,User_name VARCHAR () DEFAULT NULL,PRIMARY KEY user_id) Engine=myisam

Original: MySQL stored procedures and common functionsA. function1. Mathematical FunctionsCeil () into a roundingSELECT ceil (1.2); 2Floor () Rounding and roundingSELECT floor (1.9); 9MoD take remainder (modulo)SELECT MOD (3,8); 3--3 to 8

Use Java to access images and other types of files in the MySQL database1. Notes 1. When the database field isBlobType, must usePreparedStatementInSetBinaryStream (int, InputStream, int)Method;2. When the database field isLongblobType, must