MySQL

Many students in the Web site, the first is in the local environment to make the site, and then through the site to move to the site space, this practice is very good, but also bring some unforeseen problems.If the DZ Forum can not upload avatar is

first, what is PreparedStatementIn the Java API documentation, we can see that PreparedStatement is the statement sub-interface () object that represents the precompiled SQL statement, and the SQL statement is precompiled and stored in

Recently read the O ' Reiliy series of "high-availability MySQL", naturally without the master-slave (master-slave) configuration and scale-related content. Master-slave this thing, in many companies are standard, the development of the basic daily

In the early days of business travel in the field of development, the import database is always a problem. Finally found a magic SQL statement to the implementation, as long as the import error will be the following statement execution on it. So far.

 Linux after the installation of MySQL is the default: distinguish the case of the table name, do not distinguish between the case of the column name;Root login, modify/ETC/MY.CNF, add a line at the end:Lower_case_table_names=1lower_case_table_names

1. Experimental environmentI built the MySQL cluster environment with three servers, the SQL node and the data node are on the same server, and the management node is a separate one.Cluster node1:192.168.1.102 Data node1:192.168.1.102Cluster node2:19

Locate the MySQL configuration file My.ini Add Skip-grant-tables under [mysqld] Win+r shortcut key Input cmd then enter the command net stop MySQL finally make the directory point to the bin directory in the MySQL installation directory

First, the character set summary In fact, most of the knowledge in this article has been very clear. Here is just a talk about their own sentiment. 1. Although UTF-8 begins with UTF (Unicode transfermation format), he is not Unicode in real sense.

In the MySQL database, both the DELETE statement and the TRUNCATE TABLE statement can be used to delete data, but there are differences between the two statements, the following shows you the difference between the empty MYSQLL table content is

First, create a databaseMysql> CREATE database company;mysql> use company;Second, create a table1. Create a table officesMysql> CREATE TABLE Offices , Officecode Int (ten) not NULL UNIQUE, city varchar (+) not NU LL, address varchar (+)

Stored Procedures and functions (proc tables stored in MySQL database, so check for this table)A stored procedure is a stored procedure (like a subroutine in a normal language), and there are two types of MySQL support: stored procedures, functions

When you create a table with a field type of timestamp, the default build statement for that field is:CREATE TABLE ' test ' ( ' id ' int (one) default null, ' ctime ' timestamp not null default Current_timestamp on UPDATE CU Rrent_timestamp)

Today in the task of making a input string length check on the page, the database defines the field as the title varchar (+) NULL, MySQL database.Always thought that 128 is a byte length, a Chinese character 2 bytes, English and so on a byte, so can

I have used the MySQL pure CLI (command line), that is, the execution environment of the navicat for MySQL pro cracked version, and even used the more high-end sqlyog, finally I chose the official workbench.First of all, I have to say that MySQL

recently started to play PHP, so try to build a development environment and make a record, in case you can use it later to be easily checked. The first step is to ensure that the package is up to datesudo apt-get updateStep two install Apache2sudo

One, what triggers1, personal understandingFlip-flops, literally understood, trigger a device, called triggers (haha, personal understanding), for example, like dark, you turn on the lights, you see things. You put the firecracker, lit, and then

Dirty read (dirty read) unrepeatable read (phantom problem) Parsing1. Dirty read First, distinguish between dirty pages and dirty data Dirty pages are modified pages in the memory buffer pool. They are not flushed to the hard disk in time, but are

MySQL "replace into", mysqlreplaceinto MySQL has many extensions for SQL, some of which are very convenient to use, but some may have performance problems after misuse, and some unexpected side effects, such as REPLACE. For example, there is a table:

MySQL: Error: Tablespace for table 'database'. 'temp ''exists. Please DISCARD the tablespace before IMPORT. Solution: createtablespace Today, when I operate mysql database tables on navicat, I suddenly fail to respond. Then restart the mysql service.

SQL Aggregate functions and sorting methods Aggregate functions count, max, min, avg, sum...Select count (*) from T_EmployeeSelect Max (FSalary) from T_Employee Sort ASC ascending DESC descendingSelect * from T_Employee order by Fage Sort by age in