Mysqldump is often used in MySQL database logical backups.
1. Various usage instructions
A. The simplest use:
Mysqldump-uroot-ppassword [database name]
> [dump file]
The above command backs up the specified database to a dump file
Mysql> SELECT something from Tbl_name
WHERE To_days (now ())-To_days (Date_col)
DayOfWeek (date)
Returns the week index of date (1 = Sunday, 2 = Monday, ...). 7 = Saturday). Index values are compliant with ODBC standards.
mysql> SELECT DayOfWeek ('
Prepare the software first:First, install Apache, configure the success of a common Web serverRun the download Good "Apache_2.0.55-win32-x86-no_ssl.msi", the following interface appears:screen.width*0.7) {this.resized=true; this.width=screen.width*0.
1, pre-installed Windows 2003 dozen good SP2 above patch installed IIS6.0 and select ASP and. NET Support. IIS default support asp.net 1.1 asp.net 2.0 can be downloaded online
Installation.
2, install PHP, MySQL and MSSQL. Many correct introductions
How to start/stop/restart MySQL
First, the way to start
1, use service to start: Service mysqld start
2. Start with mysqld script:/etc/inint.d/mysqld start
3. Use Safe_mysqld to start:safe_mysqld&
Second, stop
1, use service to start: Service
Recently wrote some mysql stored procedures and functions, found that the online more valuable documents are very few, most of them are copied from the manual, some practical problems can not be solved, such as the use of variables as table
In a colleague that the entire installation version of MySQL, and then add to window services, but there are many problems in the middle, summed up personal experience, I hope others do not detours.
1 in the colleague that or to the official
Using PHP as a background run program (such as bulk SMS), executing php,php in CLI mode requires a MySQL loop to perform database processing.
When the MySQL connection flashes, the execution of the loop will fail.
We need to design a method that,
1.character_set_server and Collation_server
These two variables are the character set of the server. They can be set by--character-set-server and--collation-server when the system is started. If not, the system will set the two variables to default
one, the connection MySQL.
Format: mysql-h host address-u user name-P user Password
1, connected to the MySQL on the computer.
First open the DOS window, and then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter
Outer Joins. An outer join can be a left outer join, a right outer join, or a full outer join.
When you specify an outer join in the FROM clause, you can specify one of the following groups of keywords:
Left JOIN or left OUTER join.
The result set
This article provides you with MySQL installation package, detailed installation procedures, as well as the installation process of problems arising from the solution, I hope to help you ...
Tools: Mysql 5.7.12.0 installation package download
Objective
Before the practice encountered a problem, in a similar pt-osc scenario, you need to swap two table names, how to ensure the foolproof?
Analysis
Some people may think, the table name is not easy to drop, rename each other.
However,
First look at the architecture, as shown in the following figure:
Deployment
1. Modify the Hosts
Perform the same operation on all servers.
Vim/etc/hosts
192.168.137.10 Master
192.168.137.20 backup
192.168.137.30 slave
192.168.137.40
Objective
JSON is a lightweight data interchange format that uses a language-independent text format, like XML, but is simpler, easier to read, and easier to write than XML. Easy to parse and generate for machines, and reduce network bandwidth
This article illustrates how MySQL uses foreign keys to implement cascading deletes and updates. Share to everyone for your reference, specific as follows:
MySQL supports the foreign key storage engine only InnoDB, when creating foreign keys,
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" Database in the "User" table in the "host" item, from
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