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