XAMPP is an environment (PHP+APACHE+MYSQL) software that can quickly create web sites, if there are many projects, Using 127.0.0.1 or localhost access is cumbersome and not easy to remember, you can use the domain name virtual directory to achieve
1. First open the MySQL tutorial in the command line consolePerhaps the order is as follows:Mysql-u root-p database_nameThen you may be prompted to enter the corresponding password2. The following command may be useful to you when you want to change
MySQL tutorial Add new user and modify password method
Format: Mysqladmin-u username-P Old password password new password
1, to root add a password ab12. First enter the directory Mysqlbin in DOS, and then type the following command:
In many cases, a temporary table is required to combine the distinct of an order by.
Note that because distinct may use GROUP BY, you must be aware of how the MySQL tutorial uses the columns in the order BY or HAVING clause of a part of the
MySQL tutorial several ways to export Excel files
Method One
PHP tutorials with mysql command and shell
SELECT * into outfile './bestlovesky.xls ' from Bestlovesky where 1 the ORDER by id DESC limit 0, 50;
Method Two Bestlovesky.xls is opened in
Work needs to query this month, the data this month to ranking, a closer look at the database tutorial in the database stored in the date format is 2010-02-23 14:2:3 This type, so I think the database by the second query method is not, find a date
Some methods for dealing with garbled problems in MySQL tutorial1 Set up PHP tutorials MyAdmin
Language:chinese Simplified (zh-utf-8)
MySQL Character set: Utf-8 Unicode (UTF8)
MySQL Connection proofing: gbk_chinese_ci
2 when creating a
The solution of MySQL Chinese sorting error/*
Method One
Change the character set of the field directly to GBK, and then sort directly by using order by.
MySQL Tutorial 5.x supports a column to define a separate set of characters
Method Two
Add
This tutorial is going to tell you about the MySQL tutorial how to improve the table's statistical query speed Oh, we talked about using the middle table to improve the query and statistical speed of the datasheet.
For tables with a large database
Completely uninstall MySQL graphics tutorial under Linux
1, to find whether the previous installed MySQLCommand: Rpm-qa|grep-i MySQLYou can see the following figure:
Before the description is installed:Mysql-client-5.5.25a-1.rhel5Mysql-server-5.5.2
Free space for php mysql 1Majorhost.com provides some of the most functional free hosting network services on the Internet. We are confident that we will beat any other free host... we can assure you of the following:10 GB storage space99.98% of
I. Syntax GROUP_CONCAT ([DISTINCT] expr [, expr...] [order by {unsigned_integer | col_name | expr} [ASC | DESC] [, col_name...] [SEPARATOR str_val]) It can also be simply understood Group_concat ([DISTINCT] field to be connected [Order by asc/DESC
EnvironmentMySQL version:Mysql> select version ();+ ---- +| Version () |+ ---- +| 5.6.30-log |+ ---- +1 row in set (0.05 sec)Ensure that the master and slave nodes have been synchronizedSlave_IO_Running: YesSlave_ SQL _Running:
In my opinion, limit should be the most frequently used method in mysql. Next we will explain the role of limit and how to use it correctly.SELECT * FROM table LIMIT [offset,] rows | rows OFFSETThe LIMIT clause can be used to force the SELECT
This method only describes how to save the table name (data is not recovered). If you want to restore the original data, use extundelete to restore the file and put it back.In addition, it is suitable for storing the full-backup frm and idb files
Mysql master/slave databases are not synchronized todayFirst go to the Master database:Mysql> show processlist; check whether there are too many Sleep processes. It is normal.Show master status; also normal.Mysql> show master status;+ ---------------
Description:I create a empty table and then alter this table's "AUTO_INCREMENT" starts from 10000000. after a long time, MySQL lost "AUTO_INCREMENT" definition when I show this table again. mariaDB has the same problem but Percona Server is fine.$
MySQL databases are classified into two types: traditional data table formats and transaction-supported data table formats (InnoDB and BDB, with InnoDB as the primary ), the following describes how to install and use MySQL transaction processing
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