MySQL

Recently tried PHP7, in compiling and supporting MySQL have encountered some problems, I believe many students also encountered, so here to chat about this process. In simple terms, compiling PHP7 takes only 3 steps: 1./buildconf--force2./configure3

When you first build a database with MySQL administrator, the table defaults to the InnoDB type, and you don't care. Later, when using Access2mysql to guide the data found can only lead to myisam type of table, do not know what the difference

Mysqldump: One of the features is that the list needs to be locked during processing, so if we need to perform a backup work during the working hours, it can cause DML blocking. But generally now MySQL has the principal and subordinate, the backup

Recently learning Java and database, think of the previous written student management system, are downloaded from the Internet, perfunctory. There is nothing to do, but also write their own one, but not many functions to achieve. Development

Let's look at the following example: 1 Replace into ...1.1 Input raw Data mysql> use test; Database changed Mysql> mysql> CREATE TABLE T1 SELECT 1 as a, ' C3 ' as B, ' C2 ' as C;ALTER TABLE T1 Change a a INT PRIMARY KEY auto_increment;Query OK,

Error Tip: Error:can ' t create/write to file ' C:\WINDOWS\TEMP\ #sql_738_0. MyD ' (errcode:17) Problem Analysis: 1, C:\Windows\TEMP folder permissions are not enough, at least to give the USERS group readable and writable permission; 2, C:\

Today, when parsing dedecms found Deder mysql Time field, are used ' SendData ' int (a) unsigned not NULL DEFAULT ' 0 '; Then find this article on the Internet, it seems that if the time field has participated in the

Mysql First we build a chart_pie table as statistical data. -- ---table structure ' Chart_pie ' -- CREATE table IF not EXISTS ' Chart_pie ' ( ' id ' int (one) not NULL auto_increment, ' title ' varchar NOT NULL, ' PV ' int (a)

MySQL has a lot of ways to import data, but these are only half of that data transfer, and the other thing is to export it from the MySQL database. There are many reasons why we need to export the data. One important reason is to back up the

Often for convenience and intuition, we will first directly in the Database design table, but the next time the table structure and design in the design document, so that the encoding can be intuitive query, once the database table is very much, the

1, update sudo apt-get update 2. Installation Nginx sudo apt-get intsall nginx After Ubuntu installation, the file structure is roughly: * All configuration files are under/etc/nginx, and each virtual host has been placed

We must have used phpMyAdmin inside the database import, export function, very convenient. But in practical applications, I found the following questions: 1 database more than a certain size, such as 6M at this time using the export generally no

Convert IP addresses and numbers with MySQL built-in functions Take advantage of two built-in functions Inet_aton: Converts an IP address to a digital type Inet_ntoa: Converts a numeric type to an IP address Take full advantage of MySQL's

This article is the author installs the PHP Dynamic Web server on the Linux server, the MySQL database Installation configuration Handbook. Through the server installed Apache, Mysql, PHP and other functions to achieve a dynamic PHP to create a full

In some cases you may want to run multiple servers on the same machine. For example, you may want to test a new MySQL version so that your existing production system settings are not disturbed, or you may want to provide a separate MySQL

Usage of MySQL time conversion function Returns the week index of date (1= Sunday, 2 = Monday, ...). 7= Saturday). These index values correspond to ODBC standards. mysql> select DAYOFWEEK(2007-10-31); -> 4 WEEKDAY(date) Returns the week index of

The specific text can not find, this article is a reference to the portal of an articleMethod One:Query statements output directlySyntax format:Example:Select * intoOutFile'/data/var-3307/catid.xls' fromHelp_catwhere 1 Order bycat_iddescLimit0, -;

MyBatis's dynamic SQL is based on the OGNL expression, which helps us to implement some logic in SQL statements conveniently.The elements used to implement dynamic SQL in MyBatis are: If Choose (when,otherwise) Trim where

If a field in a table that has a non-primary key points to a primary key in a table, the field is called a foreign key.You can have multiple foreign keys in a single table.The default effect of a foreign key is two points:1. The role of the child

Install and configure MySQL in the free version of win10, and install and configure win10 I found a lot on the Internet. I found that many of them are not linux systems, but they are different from the current new version. I have done some practical