1. Restriction rules
The limits of a field have the following rules when the field is defined:
A) storage limits
The varchar field is to store the actual content separately from the clustered index, where the content begins with 1 to 2 bytes
String functionsstring comparison functionsIf the length of the result is greater than the maximum value of the Max_allowed_packet system variable, the return value of the string value function is null. See section 7.5.2, "Tuning server parameters."
Introduction to timestamp basic knowledge
Variant of the timestamp1,timestamp DEFAULT current_timestamp on UPDATE current_timestamp refreshes this data column when new records are created and existing records are modified
2,timestamp default
This is not a fixed number. This article briefly describes the restriction rules.
Strlen calculates string length, one Chinese when 2 characters
Mb_strlen according to its character encoding mode, the statistic character quot
Count the number of
Apache|mysql|apache|mysql 1, install PHP: will download the PHP compressed file decompression, folder renamed to PHP copied to the C-packing directory.
2, open just unzip the PHP directory, you will find a file called "Php.ini-dist", this is the
Apache is currently the most widely used Web server, PHP3 is an ASP-like scripting language, the current trend is much more than Perl, and MySQL is a lightweight database system, especially for Web site building, these 3 software are free software,
System Maintenance engineer Li ChaoWe have introduced the Distributed Monitoring System zabbix-automatic discovery-add MySQL multi-instance monitoring, but did not provide the key that can be used directly, too shabby, the monitoring effect is poor.
If you want to do a Java EE development on Linux, first build the Java EE development environment, including the JDK, Tomcat, Eclipse installation (this in a previous essay has explained in detail the Linux learning CentOS (vii)- CentOS under the
Mysql Backup Tools Xtraback full-volume and incremental testingXtrabackup is an open source project for Percona, can be hot backed up InnoDB, XtraDB, and MyISAM (Will lock the table)Official website
This article to provide you with three kinds of in MySQL to avoid repeated insertion record method, mainly refers to the Ignore,replace,on DUPLICATE key update three methods, you can try to reference.Case one: Using the Ignore keywordIf the
The main contents of this chapter:
First, foreign key
Second, table connection
Third, sub-query
Iv. Index
first, foreign key:
1. What is a foreign key
2. Foreign KEY syntax
3, FOREIGN key conditions
4.
Transferred from: http://www.cnblogs.com/likwo/archive/2010/04/16/1713282.htmlQuery Day:SELECT * FROM table where to_days (column_time) = To_days (now ());SELECT * FROM table where date (column_time) = Curdate ();Query one week:SELECT * FROM table
MySQL replication case AReprint: http://www.vmcd.org/2013/09/mysql-replication-case-%E4%B8%80%E5%88%99/Posted by admin on September 10th, 2013Recently, a colleague has handled a MySQL replication error. Send for referenceMySQL synchronization error,
When developing PHP on Windows, the runtime environment is an essential part. We often choose the existing environment suite, currently, popular environment Kits include XAMPP, Wamp, apmserv, dedeampz, wnmp, and phpnow. Phpnow has been used for
MySql login password forgot and forgot password solution, mysql Login Password
Method 1:
MySQL provides command line parameters for skipping access control and starts the MySQL server by running the following command:
safe_mysqld --skip-grant-tables&
SQL Server Error: 1326 (the manager cannot connect to the remote database) solution, error1326
SQL Server Error: 1326
When using SQL Server, we will encounter the problem that SQL Server Management Studio cannot connect to a remote database instance.
MySQL stored procedure details mysql stored procedure and mysql stored procedure details
Mysql stored procedure details
1. Stored Procedure Overview
The commonly used operating database language SQL statements must be compiled and then executed
Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO), 28000 denied
Recently, mysql 5.6 has encountered the following problems.
Thank you for sharing the original article:
CASE Environment:
Operating
Abstract: loading data for a database is one of the important responsibilities of the Administrator. It is precisely because of the importance that MySQL provides a wide range of methods. The INSERT and LOAD statements are mainly used.
INSERT new
MySql: www.mysql.org
First, start and stop the mysql Service
Net stop mysql
Net start mysql
Second, log on to mysql
Mysql-u user name-p User Password
Mysql-uroot-p. After you press enter, you are prompted to enter the password, enter 12345,
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