MySQL

As an extension of the SQL standard, MySQL also supports integer types tinyint, Mediumint, and bigint. MySQL int (m), m indicates that the display width is independent of storage, and int is 4 bytes.The signed int of the MySQL database can save 2^31-

from:http://jackyrong.iteye.com/blog/19826781. Number of system MySQL processesPs-ef | grep "MySQL" | Grep-v "grep" | Wc–l2.slave_runningMySQL > Show status like ' slave_running ';If the system has a slave replication server, this value indicates

before all used lamp, this configuration a lnmp to see, try Nginx is not easy to useTurn off SELinuxVi/etc/selinux/config#SELINUX =enforcing #注释掉#SELINUXTYPE =targeted #注释掉Selinux=disabled #增加Shutdown-r now #重启系统Installing NgnixInstalling the GCC

1. First check the default installed character setMysql> Show variables like '%char% '; +--------------------------+----------------------------------------------- ---------+| variable_name | Value |+--------------------------+-----------------------

Let's talk about the environment first:Server version:5.6.16-enterprise-commercial-advanced-log MySQL Enterprise server-advanced Edition (commercial)Mysql> Show variables like '%innodb_flush_log_at_trx_commit% '; +--------------------------------+---

Ext.: http://blog.chinaunix.net/uid-20639775-id-3323098.htmlIn System management or database management, it is often imperative to execute a command or SQL statement periodically. Anyone familiar with the Linux system knows the Cron scheduling task

Need to install Mysql-connector-net-6.7.4.msi Locate three DLLs in the location of the C-drive installation MySQL, and copy to the Bin folder Increase in C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config Or add a

Many times, we in the MySQL database query when we want to deal with time, such as formatting or other operations, this way to avoid the re-processing, and MySQL has a lot of time to deal with the function, today simple to do a small summary, for

Numeric typeMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each subtype supports data of

Temp table: Table in memory, data in memory.Memory table: Table on disk, data in memory.Modify the size of the staging table and memory table in the My.cnf file:[Mysqld] 　　 # Memory Table capacity　　max_heap_table_size=1024m　　# temp Table

Original: Windows Build apache+mysql+php development environmentRequirements Essential knowledgeFamiliar with basic programming environment construction. Operating EnvironmentWindows 7 (64-bit);Apache2.2;MySQL Server 5.5php-5.3

Get ready:CREATE table t (x int,y int);　　Usage 1:Modifying a column's data classALTER TABLE t modify column y nvarchar (32);　　Usage 2:Add a column to a tableALTER TABLE t add column z int;　　Usage 3:To delete a column in a tableALTER TABLE t drop

1． Index functionIn addition to the ordered lookups mentioned above, the database uses a variety of fast location techniques to greatly improve the query efficiency. In particular, when the amount of data is very large and the query involves more

1, transaction processingInnoDB supports transactional features, MyISAM not supported. Myisam executes faster and performs better. 2,select, UPDATE, INSERT, delete operationMyISAM:if executing a lot of select,myisam is a better choiceInnoDB:If your

Briefly describe the two usages of MySQL in:They are followed by a table (recordset) in the In keyword, and a string set after in.Let's go ahead and follow a table.First, the structure of three tables is elaborated:S

I started the migration blog, the entire structure of the blog building and coding http://www.cookqq.com/lookBlog.action?id=c7d6978a-0dc0-4648-9020-2b81d859a243MySQL server recently always error, the content is as follows:The last packet

MySQL Time processingUsually we have some time to change the demand, such as to count the revenue of a certain period of time, such as to intercept a certain time of year, such as to calculate the day of the week according to a certain date, these

Mysql error 1862 (HY000): Your password has expired., hy000expired Encountered error: ERROR 1862 (HY000): Your password has expired. To log in you mustChange it using a client that supports expired passwords. The reason is: MySQL 5.6

Mysql learning starts from 0: Table Creation The following example shows a table named "persons: Id LastName FirstName Address City 1 Adams John Oxford Street London 2 Bush George Th Avenue

[Switch] MySql modifies the table type and mysql modifies the table Recently, I encountered a problem about modifying the mysql table type. Previously, when phpmyadmin managed the mysql database, the created table is of the MyISAM type by default,