ApacheIf using RPM package installation, the installation path should be in the/ETC/HTTPD directoryApache configuration file:/etc/httpd/conf/httpd.confApache Module Path:/usr/sbin/apachectlWeb directory:/var/www/htmlIf the source code is installed,
http://zhangxugg-163-com.iteye.com/blog/1666673The federated described in this article belongs to MySQL's special engine, which can be used to map local data tables to a remote MySQL data table to solve a wide range of cross-machine connection
Integral type data:
1.tinyint,2.smallint,3.mediumint,4.int,5.bigint.InvasiveWhen the statement was made, we found that there was a statement:Create Table main_t ( tinyint ),smallint(), meidum_id mediumint ( ),int(a), bigint());
Universal binary MySQL is the official compiled installation program, relatively simple method of compiling and installation, and save time, this article is based on mysql-5.5.33 installation, formerly known as mysql-5.5.33-linux2.6-x86_64. tar.gz,
In database tables, using indexes can greatly improve query speed. Suppose we create a testindex table:CREATE TABLE Testindex (i_testid INT not null,vc_name VARCHAR () notnull);We randomly inserted 1000 records into it, including a i_testid vc_name 5
Describe statement:Grammar:describe table name;Simplified notation:desc Table NameAttention1. Two kinds of writing results are the same,2. You can not end with a semicolon,3. Multiple tables are not supported for simultaneous querying.Detailed
Environment: mysql5.5, Engine Innodb,sqlyogrow lock, table lock difference: In fact, is to see where the conditions are indexed, when there is an index is a row of locks, no index when it is a form of cable. Create the table structure first:CREATE
Streamlined beauty ...1. Install MySQL serverHttp://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.21-winx64.zipNote: The part of this URL that removes the file name is the path to almost all file downloadsThe following article can be borrowed from
Preface: In the creation of the database, there will be an option, such as collation, usually in the creation of the database and did not pay attention to, but chose the default, and did not feel any problems, today to see this sudden curiosity, so
1. View MySQL character encoding>show variables like ' character% '; #执行编码显示Where character_set_client,character_set_results,character_set_connection three running variables is the key to garbled2. Modify MySQL encoding format to UTF8Edit My.ini,
After you change the MySQL parameters, restart the MySQL database and view the log to find the following error message141029 2:23:37 [ERROR] Plugin ' InnoDB ' init function returned ERROR.141029 2:23:37 [ERROR] Plugin ' InnoDB ' registration as a
This MySQL is written in the Navicat.CREATE PROCEDURE Aa_getstudentbypage(in _pageindex int,in _pagesize int,In _username varchar (20),Out _pagecount int)BeginDECLARE _paidex int default 0;DECLARE _count int default 0;Set _paidex= (_pageindex-1)
Original addressMySQL will appear in Chinese garbled reason is the following points:The 1.server itself sets the problem, for example still staying in Latin12.table language setting problem (including character and collation)3. The connection
Mysql Note two
Mysql Note Two table of Contents
1. Preface
2. How Master Thread Works
2.1. Main loop (Loop)
2.2. Background tracking (Backgroup loop)
2.3. Refresh loop (flush loop)
2.4. Pause loop (suspend
A database is like a water source, storing a lot of data. The connection is like a faucet that extends into the water and is connected to it. The command is like a pump that provides power and execution for pumping, and then returns the water to the
Mysqlsql Statement Review 2 -- Regular Expression
Here, we will briefly review the usage of Regular Expressions in mysql when filtering data. This mainly refers to an example for each usage or a brief description.
The REGEXP keyword is used to
MySQL: Detailed description of MySQL date data type and MySQL time typeI. MySQL date type: Date Format, storage space occupied, and date range comparison
Date Type Bucket Date Format date range ------------ -------------------------------------------
One of mysql installation methods on linux, yum Installation
Mysql installation is nothing more than the following. yum installation is also a type of rpm installation, but this installation package does not need to be downloaded separately. It is
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