MySQL

01, Error_log--log-error=02, General_log--general-log-file=--general-log=[on | off] whether to start General-log03, Slow_query_log--slow-query-log-file=--long-query-time= Valve Value04, binary Log--log-bin=--log-bin-basename= #这个参数是不用在my. CNF is set

ReviewQuery: Grouping (GROUP by: Statistics), having (condition), sort (order by), limiting (limit offset,length)Union query: Record overlay, sort (order by:1. Must match limit, the query clause must use parentheses)Subquery: Sub-query

Project Project TasksUse Php+mysql programming to make a dynamic website.1. Determine the taskDo a simple student management system, you need to log in to view student information2. Demand AnalysisFeatures: Login function, registration function,

usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;usingMysql.data;usingMySql.Data.MySqlClient;namespacew

1 Installing ApacheWebsite: www.Apache.org Download the corresponding Apache, currently download the recent: Httpd-2.2.15-win32-x86-openssl-0.9.8msiInstall the brief steps such as:1.1 1.21.3 1.41.5 1.61.7 1.81.9 Enter http://localhost/in IE Address

mtsql: Common codeCreate TableCeShi1 (Uidvarchar( -)Primary Key, PWDvarchar( -), Namevarchar( -) Nationvarchar( -), Foreign Key(Nation)ReferencesNation (Code)//Add foreign key relationship//Referencesreferences) Write query statements that

MySQL Data backupInside MySQL, there are logical backups and physical backups. The biggest advantage of logical backups is that the same method can be used to back up the various storage engines. While physical backups are different, different

Most of the time, MySQL data will be very large, the data by default in/var/lib/mysql, because/var partition space is not large enough, so we need to change the MySQL data storage path, put into the large partition, so that can cope with MySQL data

Recently in the internship, some MySQL commands are often used, so did a bit of tidying up:Solve character garbled problem: Display Chinese instead of garbled: set names UTF8;Modify New Password: Update user set Password=password (' New password ')

1), the ID column number is executed first, if the number is the same size, then proceed from the top down, the ID is listed as NULL for the table is this is a result set, do not need to use it to query. 2), Select_type columns are common: a:simple:

Verification: MySQL Version 5.6Method One:Delete A from table a LEFT join (Select (ID) from table Group by Studentname,classid) b to a.id=b.id where b.id is null;Method Two:Explain delete from table where ID not in (select MiniD from (select min (id)

Originally Linux under the default is the table name is case-sensitive, with the following settings, you can let MySQL is not distinguished table name casing:1, log in with root, modify/etc/my.cnf;2. Add a line under the [MYSQLD] node:

1. CREATE TABLE: Drop table if exists photo;CREATE TABLE Photo (ID INT not NULL auto_increment PRIMARY KEY,Name VARCHAR (+) COMMENT ' name ', photo blob COMMENT ' photos ')Engine=innodbDEFAULT Charset=utf8Collate=utf8_general_ci;The data storage

1. Storage of MD5 in MySQL databaseStoring MD5 values with char (32) is a common technique. If your application uses varchar (32), it will cost an extra amount of unnecessary overhead for each string length that is worth it. This hexadecimal value

1. Permissions tableInstall MySQL will automatically install a database named MySQL, storage permissions table: User table, DB table, host table, Table_priv table, Columns_priv table, Proc_priv table and so on.1) User table: 39 fields, divided into

MySQL database cluster (read and write separation), the white is to read and write operations separately on different servers to achieve the purpose of improving efficiency.The general principle is as follows:All operations in the database are

Problem Description:Normally this is the case when you start MySQL:1, win open input interface;2, Input cmd command, right mouse button Select "Run as Administrator";3, then enter the login statement to log in to MySQL in the interface:- -p

First, the problem foundSecond, analysis of the problem. NET long-time connection to MySQL causes timeouts; Mode one: When the connection is exhausted, close the connection Mode two: Increase the execution SqlCommand time of C #Third, solve the

Because the WIN10 system on the cheap to uninstall MySQL after the plugin has been unable to delete the normal result can only install MySQL on the Ubuntu virtual machine,Baby heart is tired ah, so record their own installation process

MySQL database InnoDB engine server power-off data recovery method, mysqlinnodb Note: An online MySQL database server suddenly loses power, causing system failure to start up. After you reinstall the system, find the previous MySQL database