MySQL timestamp type and time zone
MySQL's timestamp type time range between ' 1970-01-01 00:00:01 ' and ' 2038-01-19 03:14:07 ', exceeding this range the value is recorded as ' 0000-00-00 00:00:00 ', an important feature of this type is that the
Objective
This article mainly involves in the data creation table, encountered error 1215 (HY000): Cannot add foreign key constraint problem aspects of the content, for the data creation table, encounter the same problem interested students can
1. Install MySQL
Currently MySQL has two forms of file, one is MSI format, one is in the zip format. MSI format directly click Setup.exe, follow the steps. But many people under the zip format of the decompression found no setup.exe, I downloaded
HTML and PHP, MySQL interaction
Why should I use a database?
World Wide Web (WWW) is more than just a place to provide information. If you have something, make a website, you can share it with people all over the world. But this is not a very easy
It is a common problem to have a database error with MySQL (the best combination of PHP) with a power outage or an abnormal shutdown. There are two ways, one way to use the SQL statements of Check table and repair table for MySQL (and the best
1. Database download
MySQL official website: http://www.mysql.com/, database download address: http://www.mysql.com/downloads/. From the official website can find two kinds of packages, one is EXE installer, the other is a zip compression package.
show databases;Show tables from db_name;
Show columns from table_name to db_name;Show index from Talbe_name [from db_name];Show status;Show variables;Show [Full] processlist;Show table status [from db_name];Show grants for user;
In addition to
CentOS Linux has been used more and more widely because of its compatibility with Rhel and the stability of enterprise-class application, and allow users to use it freely.
1] CentOS MySQL Installation decompression[Root@localhost root]#
This article describes the MySQL table optimization, analysis, inspection and repair methods. Share to everyone for your reference, specific as follows:
This article describes the general management of the database as preventative maintenance and
Basic Concepts
• character (Character) refers to the smallest form of semantic notation in human language. such as ' A ', ' B ', etc.;
• Given a series of characters, assign a numeric value to each character, and use a numeric value to represent
Stored procedures and functions define a collection of SQL statements in a database, and then call those stored procedures and functions directly to execute a defined SQL statement. Stored procedures and functions can prevent developers from writing
When we create a table, we will inevitably think of it poorly, so we later modify the table modification table to use the ALTER TABLE statement
Modify Table name
Copy Code code as follows:
mysql> ALTER TABLE student rename person;
1. Optimize your MySQL query cacheQueries on the MySQL server enable high speed query caching. Keeping the database engine in the background quietly is one of the most effective ways to improve performance. When the same query is executed multiple
In the previous article to introduce the express to realize the front-end back-end communication upload pictures of the storage database (MySQL) fool tutorial (i)
Database such as the title, using the open source of MySQL as the basis, I am the
MySQL command line is to learn the MySQL database must have knowledge, the following for you to introduce 10 useful MySQL command line, I hope you learn the MySQL command line can help.
1, display the structure of the data table:
mysql> DESCRIBE
Concurrency and isolation control mechanism in 1.MySQL
Meta-data metadata Lock: Implemented in the table cache buffer, provides isolation for DDL (Data Definition Language). A special Meta-data metadata type, called Name Lock. (SQL Layer)
Defining Data Tables
If a computer manufacturer, its database is stored in the machine and accessories product information. The table used to keep the whole product information is called a Pc, and the table used to hold the information of accessory
First we are talking about logic errors and grammatical errors:
The biggest difference is that the syntax error does not pass the compiler compiler, logic errors can be passed. Specifically, the grammatical error means that the error violates the
MySQL 5.1 supports triggers as well as custom function interface (UDF) features, and can implement Memcache Automatic Updates if combined with Libmemcache and memcached functions for MySQL. Simply record the installation test steps.
Installation
Enabling slow query log for tracking SQL Execution in MySQL and SQL log tracking in mysql Query slow query parametersShow variables like '% quer % ';
Slow_query_log (whether to record slow queries)
Slow_query_log_file (slow log file path)
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