In the daily work, will be a simple use of MySQL, so the common Command operation summary, commonly used in the following ways
Use of the mysqldump command:
Backing up and exporting databases
Mysqldump-h database_ip-u username-p--opt databasename
In order to install convenient, need to pay attention to a few small details.It is best to install the Xcode before installing this environmentMac OS X 10.10 Yosemite with PHP5.5 and Apache2.4 make the appropriate changes.Mac installs the required
An exact numeric data type that uses integer data.
bigint
Integer data (all numbers) from -2^63 (-9223372036854775808) to 2^63-1 (9223372036854775807). The storage size is 8 bytes.
P.S. bigint already has a length, in the MySQL build table length,
Solution MySQL does not allow remote access to the method
Workaround:1. Change Table method. Your account may not be allowed to log in remotely, only in localhost. This time as long as the computer in localhost, login mysql, change the "MySQL"
Variables defined by declare and @set are often seen in stored procedures. In simple terms, the declare definition is similar to a local variable, @set a similar global variable defined.
1. Declare-defined variables are similar to local variables
Take a look at the paging SQL of a single SQL statement first.
Method 1:
Applies to SQL Server 2000/2005
Copy Code code as follows:
SELECT Top Page Size *
From table1
WHERE ID not in
(
SELECT Top Page Size * (page-1) ID from
In MySQL master-slave replication, sometimes encountered such a failure: on the Slave slave_io_running and slave_sql_running are yes,slave_sql_running_state display Slave has read All relay log; Waiting for the slave I/O thread to update it, it
Explain shows how MySQL uses indexes to process SELECT statements and join tables. can help you choose better indexes and write more optimized query statements.How to: Add explain before the SELECT statement. such as EXPLAIN SELECT * from ' users '
mysql| Comparison | performance
MySQL supports the two main table storage format Myisam,innodb, last month when doing a project, first used InnoDB, the result is particularly slow, 1 seconds can only insert 10. Later replaced by the MyISAM format, a
061 How do I delete a table?
Answer: Run command drop TABLE table_name;
062 Creating an Index
Indexing is especially important for queries as a major application. Most of the time the performance problem is simply because we forgot to add the
Learn to use RIA Framework Flex to create a MySQL admin UI
phpMyAdmin's appearance shook the industry, no doubt. It is, of course, the best PHP application because it changes the MySQL admin interface from the command line to the form of a Web
Original: http://www.drupal001.com/2014/02/percona-xtrabackup-mysql/Xtrabackup IntroductionPercona Xtrabackup is open source free MySQL database hot backup software, it can be InnoDB and XTRADB storage Engine database non-blocking backup (for MyISAM
Verify that there is a MySQL service in the list of computer services (1) Right click on the desktop computer icon appears menu list options, check management (there are several ways to open the computer local services list, here is justThe way I
Http://www.169it.com/article/3219955334.htmlSQL statements Use Basic principles: 1. To optimize the query, avoid full table scan as far as possible, and first consider indexing on the columns involved in where and order by. 2. You should try to
PS: If you want to get RHEL's high-quality, high-performance, high-reliability, and need easy-to-use (the key is free) package update features, then Fedoraproject launched EPEL (Extra Packages for Enterprise Linux) just right for you. EPEL
We all know that MySQL (the best combination with PHP) developers have developed a MySQL GUI tool that can connect to a local computer or remotely. The following is a detailed description of the remote use of the MySQL GUI tool. We hope to provide
In MySQL, innobackupex and xtrabackup are used for big data backup and restoration. innobackupex
Backup and restoration of large data volumes is always a challenge. When MYSQL exceeds 10 Gb, it is slow to export data using mysqldump. Xtrabackup is
1. TIMESTAMP variants
TIMESTAMP timestamps can have multiple different features during creation, such:
1. Refresh the data column when creating a new record or modifying an existing record:
TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE
I actually saw the 50 things that Robert Treat had sorted out on the same day, "50 things that I need to know before migrating Mysql to Oracle" and 50 things I need to know before migrating Oracle to Mysql., it's just that this list of Baron
When I used Navicat for MySQL to import a MySQL database yesterday, a serious error occurred. Lost connection to MySQL server during query, literally, Lost connection to the MySQL server during the query.[Msg] Decompressing...[Msg] Table Created: wp_
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