PLSQL syntax (variable, if,loop,cursor,exception)

1. Grammar Break executable method saved on the database server for other developers to call It can effectively reduce the data interaction between database and server, improve efficiency and reduce bandwidth consumption Syntax format: declare -- define part, save variable, reference variable, record exception begin -- logical processing ...

Posted by wint.thaw on Sat, 25 Apr 2020 08:08:26 -0700

Django ORM multi table operation (Advanced)

  Django ORM multi table operation (Advanced)   1, Create model Next, we design the corresponding relationship between each table through the book management system. Through the relationship above, we can define our model class. from django.db import models class Book(models.Model): title = models.CharField(max_length= ...

Posted by bough on Fri, 24 Apr 2020 22:45:19 -0700

Take you to the Quick Start-Advanced-Advanced ybatis-XML Approach

MyBatis-XML Schema 1. Brief Description - Differences from Notes Execution efficiency: same Speed of development: faster annotations Easy maintenance: Notes are simpler. Old company, old projects still use XML     2. Environmental Setup 1. Make sure the database has been created 2. Import jar package & core configuration file ...

Posted by morphboy23 on Fri, 24 Apr 2020 10:13:57 -0700

MySQL function of database

1, Date and time functions 1. Function to get the current dateIt's the same. It's different CURDATE(): used to get the current date of the systemCurrent "date() is used by the system to get the current date mysql> select CURDATE(),CURRENT_DATE(); 2. Get function of current time CURTIME(): used to get the current time of the system ...

Posted by deerly on Fri, 24 Apr 2020 10:12:24 -0700

Laravel admin from getting started to abandoning (I. getting started)

1, Installation and release according to official instructions 2, New customized Models and controllers 1. Create a new database table (it is recommended to directly create a table in the database. If you want to try, you can also create a table in migrations. Please refer to the PHP artican command for details) 2. Create models through PHP ...

Posted by ludwig on Wed, 22 Apr 2020 09:25:14 -0700

lavarel video project of backnet -- 1. Data migration

1, Summary One sentence summary: 1. The data migration of lavarel is relatively simple, which is to create data tables with php 2. Create migration file: PHP artican make: migration create? HD? Table -- create = HD 3. Create the migration file as a table: PHP artican migrate   1. Install barryvdh / laravel ide helper to add code prom ...

Posted by GrayFox12 on Wed, 22 Apr 2020 05:00:51 -0700

Fault analysis of dual master master replication Err 1677

2020-03-29 20:00:27   1, Error message Recently, the project implementation colleagues upgraded the system and changed a field of test.test tab. The SQL statement is as follows: ALTER TABLE TEST.TEST_TAB_T1 MODIFY BXXX VARCHAR(200); After the system upgrade of the project, the MySQL master-slave synchronization er ...

Posted by PigsHidePies on Wed, 22 Apr 2020 02:33:56 -0700

068. Using DRF view set of Python framework Django

One view atlas and the use of routing Using the view set ViewSet, you can place a series of logically related actions into a class: list() provides a set of data retrieve() provides a single data create() create data update() to save the data Destroy() delete data The ViewSet view set class no longer implements methods su ...

Posted by NorthWestSimulations on Tue, 21 Apr 2020 22:30:51 -0700

MySQL installation tutorial of Docker series

MySQL installation tutorial of Docker series With the previous basic tutorial Common command operation manual of Docker series After that, this blog records a mysql installation tutorial mysql image query command docker search mysql Several key parameters are explained as follows: INDEX docker.io is the official website of docker NAME the NA ...

Posted by Chetan on Tue, 21 Apr 2020 08:48:24 -0700

Root out and solve the problem of error reporting of Django2 connecting MySQL perfectly

Introduction Refer to the following article for the problem of Django2 connecting to MySQL and the solution of modifying the source code: The interaction between Django and MySQL However, there are many problems when the above source code modification method is used in the production environment. This article explains in detail how to solve thi ...

Posted by dmcglone on Tue, 21 Apr 2020 00:13:28 -0700