Reprinted from Http://www.jb51.net/article/40179.htmFirst, 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
Use console to insert and query data to display garbled when using Navicat for MySQL to open a databaseProcessing process1. View the database encoded as "UTF8-UTF-8 Unicode", that is, the database character set is not a problem, the initial
The particularity of the Hash index structure, itsretrieval efficiency is very high, index retrieval can be located at once, unlike the B-tree index needs to be from the root node to the side point, and finally access to the page node so many IO
Next blog Address http://lee90.blog.51cto.com/10414478/1825478In the previous blog post, we used only one slave node.in the actual production environment, we must have multiple slave The node is responsible for reading the database. Let's say we
The official description of the three main APIs that PHP connects to the MySQL database server is as follows:http://php.net/manual/zh/mysqli.overview.phpPHP MySQL and mysqli transactionsIn PHP, MYSQLI has already encapsulated the operation of MySQL
http://lobert.iteye.com/blog/1955841Get a table some days ago, nearly 4000w data, no index, primary key. (It's definitely a talent to build this watch.)This is a log table, recorded in the game the output and consumption of items, there was a
First, let's talk about why the tables are divided.When a piece of data reaches millions of, you spend more time searching for it, and if you have a joint query, I think it's possible to die there. The purpose of the sub-table is to reduce the
In Debian-sys-maint , the Debian system used for MySQL maintenance can be understood as a backup and restore of MySQL through a "non-regular" program of the system, using the account that the program uses to log in to MySQL.This debian-sys-maint
Open phpMyAdmin, log in, the following problems occur, prompted: #1045 unable to log on to the MySQL serverThe following error condition may occur: phpMyAdmin: #1045 cannot log on to the MySQL server. Access denied for user ' root ' @ ' localhost ' (
After a period of nodejs development experience, the selection of the database is MySQL, a start to think their basic knowledge of the database is OK, because after all, they have used Apache+php+mysql database course design, However, in the
MySQL function can not be created, is a very troublesome problem, the following gives you a solution to this problem, if you have encountered similar problems, may wish to see.Http://database.51cto.com/art/201010/229918.htmWhen using a MySQL
Many trainees install the bug tracker in a Linux environment with the help of the XAMPP integration environment, but if you want to enter MySQL, use the normal command:Mysql-uroot-p will prompt the following error:ERROR 2002 (HY000): Can ' t connect
On the MySQL lock line or lock table, this problem, today is a bit of a clue, MySQL InnoDB is a lock line, but the project actually appeared deadlock, lock table situation. Why is it? Take a look at this article first.When doing the project due to
Posted by Talks on 2012/02/24 |The first chapter of the prefaceSecond connection optimizationThird Article index optimizationFour-piece query optimizationThe fifth chapter to the actual combatQuery optimizationQuery optimization involves the use of
How to modify the database name in MySQL
Available in three ways:1. RENAME DATABASE db_name to New_db_nameThis one.. This syntax was added in MySQL 5.1.7, and 5.1.23 was removed.It is said that data may be lost.
Problem Description: Java.sql.SQLException:Incorrect string value: ' \XF0\X9F\X90\XBB ' for column ' nickname ' at row 1 at Com.mysql.jdbc.SQLError.createSQLException (sqlerror.java:1094) at Com.mysql.jdbc.MysqlIO.checkErrorPacket
Troubleshoot database no connection issues PrefaceDatabase version type: Mysql5.5The database connection failed when the application connected to the database. Open database view, shown below.The reason for this is that the MySQL service is having
MySQL repication1MySQL repicationprinciple The write operation of the front-end user, or the database modification operation, is logged to the binary log file, save as an event, Master sends Binlog to slave MySQL server via port 3306, slave MySQL
Mysql optimization and mysql optimization solution
1. enable one data file setting for each table in InnoDB
InnoDB can store the information of each database in A. idb data file. Each. ibd file represents its own tablespace. In this way, the class
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service