First download PHP, open the PHP official website download page: http://www.php.net/downloads.php, I use here is the Php-5.2.5-win32 version, a bit old, but the same.
Unzip the downloaded Php-5.2.5-win32 file into the c:php directory (this
First, the MySQL user's basic description:
1.1 Basic structure of the userUsers of MySQL: User name @ host
Username: within 16 charactersHost: Can be host name, IP address, network address, etc.Host Name: Www.111cn.net,localhost
ip:192.168.0.1
When you apply a database in PHP, you typically use DDL statements to create databases, datasheets, and modify table structures in your Web site in a MySQL client's console, and then apply them in your PHP scripts. It is rare to execute DDL
One, indexing base usage
1. Create an index
You can create an index when you execute a CREATE TABLE statement, or you can add an index to a table by using either CREATE INDEX or ALTER TABLE alone.
1>alter TABLE
ALTER table is used to create a
Mysql Statement Change table structure ALTER (ALTER)Original
Table A For example:
The code is as follows
Copy Code
CREATE TABLE A (A_a int NOT NULL,A_b int NOT NULL,A_c Char) Engine=innodb Charset=utf8;
Syntax:
LOAD Data Syntax Description:
LOAD DATA infile Syntax
LOAD DATA [low_priority] [local] INFILE ' file_name.txt ' [REPLACE | IGNORE]Into TABLE tbl_name[FIELDS[Terminated by ' t '][Optionally] Enclosed by '][escaped by ']][LINES terminated by ' n
Function:
Monitor the MySQL process, the failure is restarted, if unable to start the email notification
The code is as follows:
The code is as follows
Copy Code
#!/bin/bash#/usr/bin/nmap localhost | grep 3306#lsof-i:33
Prepare the article:
1, configure the firewall, open 80 ports, 3306 ports
Note: The Ubuntu default installation is not open any firewall, for the security of the server, we recommend that you install the firewall settings, it is recommended to use
Although there are many GUI based MySQL clients that exist, such as the famous phpMyAdmin and SQLyog, but I have always liked native MySQL command-line clients, it is true that we need to take some time to familiarize ourselves with these
Character-set-server/default-character-set: Server character set, by default.
Character-set-database: Database character set.
Character-set-table: Database table character Set.
Priority increases in order. Therefore, in general, you only need to set
MySQL data (field) typewhen you create a table, you explicitly define the data type of the field. MySQL's main data types are numeric, string (text), date, and other types.Numeric typeNumeric type description:
Supplementary notesIn the Int
The max () function of MySQL is used to find a record of the maximum value in a recordset.
The EMPLOYEE_TBL table that you want to know about Max functionality has the following records:
Mysql> SELECT * from EMPLOYEE_TBL;
+------+------+----
First, stored procedures
Stored Procedures (Stored Procedure) are in a large database system, a set of SQL statements to complete a specific function, compiled and stored in the database, the userExecutes it by specifying the name of the stored
Introduction: mysql5.0.94, this version and the more advanced versions (5.5, 6, and so on) have not yet supported circular recursive queries, and MySQL is difficult to traverse in the middle layer of the tree table compared to SQL Server and Oracle.
Every so often people ask me the question how should they the estimate memory consumption by MySQL Server in given Configurati On. What is the formula they could use.
People often ask me how to estimate memory consumption when I configure MySQL. So
According to the information on the Internet, MYSQ does not have a Dada directory at the beginning of version 5.7, and requires an additional "initialize database" operation to automatically generate the data
Add user insert into Mysql.user (Host,user,password) VALUES ("localhost", "Test", Password ("1234"));Report the following error 1364 (HY000): Field ' ssl_cipher ' doesn ' t has a default value errormysql5.1 The above version, I was operating on
Enable remote port 16.04 and 16.04mysql5.7.17 for mysql5.7.17 in ubuntu 3306
Enable MySQL Remote Access Permissions
By default, mysql users do not have the permission for remote access. Therefore, when the program is not on the same server as the
In fact, the material for this fault comes from a friend of mine. Although I am not the real person who experienced the fault, even if I am just a bystander, I still feel a little bit rewarding. As a result, I recorded it to feed readers.The root
Cobar is a distributed processing system for relational data developed by Alibaba. It is a middleware that provides distributed services for relational databases (MySQL). This product successfully replaces the original Oracle-based data storage
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