MySQL

1, first you have to understand that MySQL is also a language, he can also write programs, but also support logical judgment, if,elseif,else,switch,while and so on the judgment2, MySQL assignment value of a variable operation: set @a = 1; View this

For example, the age of this field can be used 1990-03-15 also can be expressed in 19900315You can select char and int on the column type;If a field can select more than one type, try to choose a faster type;Field-type precedence integer

For some friends, the installation of MySQL5.6 in the Ubuntu14.04 is always wrong, here I put the process of my installation to everyone to say:If you are logged in Ubuntu is not the root account, then first switch to root, command sudo su root will

1. Development environmentoperating system: Win10 python version: Python 3.5.2 mysql:5.5.532, the use of the moduleIf not, use Pip to install: Pip install xxx xxx need to install the module3, Analysis link (blog official website: https://www.cnblogs.

One: Modify table information1. Modify the table nameAlter Table to Sys_app;2. Modify Table AnnotationsAlter Table ' System Information Table ';Second: Modify field information1. modifying field types and annotationsAlter table sys_application

MySQL is a third-party module that needs to install PIP install Pymysql First,After SQL executes, there are three data acquisition functionsCur.fetchone () #获取第一条数据, and so on and so on, the second execution will take the first one that removes the

MySQL Query record if there is a timestamp field, the view results inconvenient, can not immediately see the meaning of the timestamp represents, now provides the MySQL format change time function, you can easily see the time after the format.1. The

Note 1:http://www.cnblogs.com/hoojo/archive/2011/06/20/2085390.htmlNote 2:http://www.cnblogs.com/hoojo/archive/2011/06/20/2085416.html1. query all data of a tableSELECT * from temp;* represents all columns, temp represents the table name, and all

Example ~ ~example1:Create a table Tab1 1234 DROPTABLE IF EXISTS tab1;CREATE TABLEtab1(    tab1_id varchar(11)); Create a table TaB2 1234 DROPTABLE IF EXISTS tab2;CREATE TABLEtab2(    tab2_id

Java MySQL data type comparison Type name Display length Database type Java type JDBC Type index (int) Describe varchar L+n VARCHAR Java.

1 Event BriefThe event is a procedural database object that MySQL invokes at the appropriate time. An event can be invoked once or periodically, and it is managed by a particular thread, the so-called "event Scheduler".Events are similar to triggers,

1 GROUP by indicates a sort, followed by the first data in each group, where the condition is indicated, if you need conditional filtering on the order, you should follow the property name with a + condition. and cannot use where2 aggregate function

Views View Usage Summary:A view can be thought of as a "virtual table" because it returns a result set format similar to the format of the dataset returned by the Entity data table, and the view is referenced in the same way as the data table. Each

Reprinted from: https://www.2cto.com/os/201408/329502.htmlInstall MySQL Execute the following command: sudo apt-get install Mysql-server 　　2. After continuing, you need to set the MySQL password　　3. Enter the password again.　　4.

See sort_buffer_size This parameter (the connect level parameter, MySQL5.7, the default value is 1048576 bytes, that is, 1MB) The default value is so small,Think about whether it is possible to turn up a little bit, anyway the memory is dozens of GB,

Original link: http://www.cnblogs.com/rookie-c/p/6425039.htmlCreate a databaseCREATE DATABASE name;Show all databasesSHOW DATABASES;Deleting a databaseDROP DATABASE name;Select DatabaseUse DATABASENAME;Displays the tables that exist in the current

Do not know why, write this article I always want to sigh. First of all, I appreciate and admire the developers who can share knowledge and technology, regardless of whether your technology is very cow, but your spirit let me very much admire. Java

Using indexes is one of the essential skills of database performance optimization. In the MySQL database, there are four kinds of indexes: Clustered index (primary key index), normal index, unique index, and the full-text index (fulltext index) we

Basic Mysql database knowledge and basic mysql knowledge E-R model (Entity Relationship Model) Currently, physical databases are designed according to the E-R model. E Indicates entry, Entity R indicates relationship, Relation Convert an object

Upgrade mysql to 5.7 in ubuntu and use tumysql 0 Preface A few days ago, the Library said that the server (Ubuntu14.04) had a security vulnerability and it would shut down if it was not fixed on time. I checked the vulnerability list, mainly about