MySQL

1. Edit the Apache Master Profile httpd.conf Adjust ServerName 127.0.0.1:80 (note Backup)Vi/application/apache/conf/httpd.conf +9898 ServerName 127.0.0.1:80Add two lines under 311 lines:AddType application/x-httpd-php. php. phtmlAddType

The LOAD DATA infile statement reads from a text file into a table at a high speed.1. Basic grammarLOAD DATA [Low_priority | CONCURRENT] [LOCAL] INFILE ' file_name.txt ' [REPLACE | IGNORE] into TABLE tbl_name [Fields [TERMINATED by '

Write in front: indexes have a critical impact on the speed of queries, and understanding indexes is also a starting point for database Performance tuning. Consider the following scenario, assuming that a table in the database has 10^6 records, the

http://www.xiaoxiaozi.com/2009/07/12/1158/, a relational database management system like MySQL, is based on the ability to create relationships between tables in a database. By easily establishing a record-to-record connection in different tables,

First, IntroductionA stored procedure (Stored Procedure) is a set of SQL statements that are compiled to perform a particular function, stored in a database, and invoked by the user by specifying the name of the stored procedure and given the

MySQL using concat to splice Chinese characters garbled solution-fuxuejun column-Blog channel-Csdn.net http://blog.csdn.net/fuxuejun/article/details/6284725MySQL concat garbled problem resolution concat (STR1,STR2) when the concat result set garbled,

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

For some systems with large data volume, the problem of database is not only inefficient, but also the data storage time is long. Especially like a reporting system, it can take up to several hours to spend on data import every day. Therefore, it

Question: Why import Export to CSV file?(1) The so-called Big data processing, only concerned about some columns of data, rather than the entire table structure, the data needs to be saved as CSV Common storage format, not only can be processed as a

The principle of MySQL master-slave replication:The binary log file of the main library is read from the library at a certain frequency, and the same operation is performed from the library according to the binary records of the main library, in

In MySQL, we often use variable-length text data types such as varchar, text, and blobs. However, when we use these data types, we have to do some extra work--mysql data table defragmentation.So why do we need to defragment MySQL regularly after

In this there is not much to say entityframework compared to the various advantages and disadvantages of ADO. Please forgive me for not writing well.Recently used entityframework6.0 connection MySQL, encountered a variety of problems, Baidu Google

Stored ProceduresPass the reference: A parameter can be declared in parentheses in a stored procedure. The syntax is CREATE PROCEDURE P ([in/out/inout] Parameter Name argument type:) In: The parameter is passed to the value, the defined parameter

About MySQL user management, notes1. Create a new userCreated after logging in by the root user>> Grant all privileges on * * to testuser@localhost identified by "123456" ; Create a new user, the user name is TestUser, the password is 123456;>>

In MySQL configuration file my.cnf, there is a one-line skip-external-locking parameter, which is "Skip external lock". According to the official explanation of the MySQL development website, external-locking is used for locking MyISAM data tables

One, no longer for the Apache process siltation, depletion of memory and troubled0./etc/my.cnf, add the following line to the mysqld paragraph:Log-slow-queries=queries-slow.log Restart MySQL As appropriate, for a period of time, execute

Configure mysql auto-start in linux, and configure mysql to boot in linux Command echo"Service mysqld start">/Etc/rc. local Alternatively, go to the/etc/directory and directly edit the rc. local file in vim rc. local and add"Service mysqld start",

"Unable to locate the update row" is reported when MYSQL is updated using ADO. Some values may have been changed after the last read ." This strange error occurred when I used ADO to connect MYSQL to update data through ODBC in DELPHI today: the row

If no value is set for the SQL joined table, the default value isSELECT *FROM (SELECT t. task_name, t. status AS task_status, coalesce (r. task_ref_id, 999) AS task_ref_id, coalesce (r. status, 999) AS ref_statusFROM map_task tLeft join map_task_ref

Implement High-performance and high-concurrency counters in MySQL (such as the number of clicks in articles) and mysql counters There are a lot of projects that implement counters at will. For example, when we implement the number of clicks on a