MySQL

1. Build Person TableCREATE TABLE ' person ' (' id ' int (one) DEFAULT NULL,' Name ' varchar (the DEFAULT NULL),' Sex ' char (+) DEFAULT NULL)Jian PERSON_EXCREATE TABLE ' person_ex ' (' id ' int (one) DEFAULT NULL,' Name ' varchar (the DEFAULT NULL),

One, inner connection (INNER join)1. Equivalent connectionOverview : The value of the connection column of the two tables is compared with the equals "=", which is equivalent to the two tables when the Cartesian is executed, and the values of the

MVC and MTV ModeThe famous MVC pattern: the so-called MVC is to divide Web applications into models (M), controllers (C), Views (V), and they are connected together in a plug-in, loosely coupled way.The model is responsible for the business object

A long time has not been updated, today to share a wave of simple documents, rookie of the spirit of entry is continuous learning, constantly looking for God help!!!!Here today to recommend a blog address: http://sumongodb.blog.51cto.com/All right!

The case when statement in the MySQL database.A case when statement that evaluates a list of conditions and returns one of several possible result expressions.Case has two formats:The simple case function compares an expression to a set of simple

The difference between stored procedures and functions reference links:Http://www.cnblogs.com/lengbingshy/archive/2010/02/25/1673476.htmlTo create a stored procedure:DROP PROCEDURE Mypro;CREATE procedure Mypro (SID int,out Scount INT)BEGINSELECT

1. What is JDBC?JDBC (Java database Connectivity) is the connection of Java databases, in other words, the Java language to operate the database. It turns out that we operate the database using SQL statements in the console to manipulate the

OneDownload good after extracting files, unzip the content, you can extract the content to the desired location, the cases urealyticum pressure to "D:\phpweb\mysql",There is a problem with the new version of the folder without the data name, this

MySQL installation under Linux1. Download: Http://dev.mysql.com/downloads/mysql/5.6.html#downloadsDownload version: I choose here 5.6.33, General edition, Linux under 64-bitYou can also directly copy the 64-bit, download by command: wget

MySQL operator: 1. Arithmetic operator subtraction and modulo select 6+4addition operation,6-4subtraction operation,6*4multiplication operation,6/2division operation,6 DIV 2division operation,6%4die-finding operation,6 MOD 4die-finding operation;2.

edit mysql profile: My.ini (in MySQL installation directory). Open the configuration file, add it to the last line of the file: Skip-grant-tables, and then save exit Span style= "color: #333333; font-family: "microsoft yahei",

1.mysql-5.7.19-winx64.zip (This is a free installation version, about 318 trillion, there is a installation version, 380 MB or so Mysql-installer-community-5.7.19.0.msi) to extract this package to the specified disk2. It is best to change the

Installing mysql-5.6.37 on CentOS 6.91. Prepare the file system for data storageCreate a new logical volume and mount it to a specific directory. The process is no longer given here.This assumes that the mounted directory of its logical volume

Is the result of adding only one sort:As you can see, a single field is no problem. What if I join C2? It's c2.It can be found that the order here is first ordered by C1, and then for the C1 after the same sequence of the same elements, and

- |  the role of the index 1, constraint 2, speed up find- |  Why is the index so fast? Why are indexes so fast? The Name column creates an index create a file, Name column all the data is tagged with a number, the more levels are found in a

1. Delete MySQLA. sudo apt-get autoremove--purge mysql-server-5.0b. sudo apt-get remove Mysql-serverc. sudo apt-get autoremove mysql-serverd. sudo apt-get remove Mysql-common (very important)In fact, some of the above is redundant, it is recommended

Mysql 5.7.19 installation-free configuration method tutorial (64-bit), mysql5.7.19 Official website download mysql-5.7.19-winx64, pay attention to the corresponding system 64-bit or 32-bit, here is the use of 64-bit. Decompress the package to a

MySQL uses AES_ENCRYPT () and AES_DECRYPT () for encryption and decryption, Preface Recently, I have encountered a requirement as follows:AES_ENCRYPT()The function encrypts plaintext and stores it in MySQL, but encountered some problems ...... The

MySQL Learning (iii) -- connecting to the MySQL database using Java and javamysql 1. What is JDBC? JDBC (Java DataBase Connectivity) is a Java DataBase connection. To put it bluntly, it uses Java to operate databases. In the past, we used SQL

Difference between table and schema in the database: tableschema What is Database, Schema, Table, column, row, and User? We can regard the Database as a big warehouse. The Warehouse is divided into many rooms. The Schema is the room, and a