MySQL (Learning Notes) - Database Views, Triggers and Stored Procedures

_Database View, Triggers and Stored Procedures _1. What is a view? Definition: Views are virtual tables derived from one or more tables in a database and are not in memory. Grammar: create view View Name //(Create a view) as select Fi ...

Posted on Fri, 23 Aug 2019 05:54:07 -0700 by roopali

MySQL Database Advanced-Stored Procedures

Links to the original text: https://blog.51cto.com/9291927/2094915 Advanced MySQL Database (4) - Stored Procedures This article is reproduced from: https://blog.51cto.com/9291927/2094915 Introduction to Stored Procedu ...

Posted on Fri, 16 Aug 2019 06:35:31 -0700 by duankr

MySql || Quickly create 100w records

Normally, each developer will discuss the optimization of sql when there is a large amount of data.But not everyone has 100w of data to use for actual combat, so today we'll start by simulating a table of 100w of data. Creation principle In fact, there are many ways to create, fast and slow.This blog is certainly not the fastest one to writ ...

Posted on Sat, 10 Aug 2019 21:42:21 -0700 by Rupo

Oracle Learning Notes 4: pl/sql

1. What is pl/sql? sql: Structured Query Language pl/sql: (Procedure Language & Structured Query Language) is an extension of SQL language and stored procedure language. It can implement simple logic programming like Java language. 2. Advantages of pl/sql? From bloggers https://www.cnblogs.com/huyong/archive/2011/05/16/2047329.html See ...

Posted on Sun, 21 Jul 2019 20:41:56 -0700 by EGNJohn

Introduction to oracle stored procedures 1

     Stored procedures are combinations of SQL, PL/SQL, Java statements that enable you to move code that executes business rules from your application to the database. As a result, the code is stored once but can be used by multiple programs. It is a block of SQL statements stored on the database server, and its efficiency is 6-10 times high ...

Posted on Sun, 07 Jul 2019 20:00:55 -0700 by mp04

Timely Email Warning and Reminder for Blockage in Database (Part 2)

stay Timely Email Warning and Reminding of Blocking in Database (Part I) We build a new table to store blocked records, collect blocked stored procedures and configure sending mail to test ok, etc. Step 4: Create a storage process for sending mail. There are two modes that you can choose according to your needs Create a stored procedure for sen ...

Posted on Wed, 03 Jul 2019 15:53:38 -0700 by ksb24930

SQL Server Transaction Replication Distribution to Subscription Synchronization Slow

Recently, it was found that a release often had problems, and every few days it was out of sync, prompting for initialization. When synchronization is readjusted, replication is still slow! Every day, there are 56 million orders that are not distributed during the day! To solve the problem of slow synchronization, we need to know what operation ...

Posted on Wed, 03 Jul 2019 14:55:25 -0700 by lalomarquez

SQL Server Parameter Sniffing and Its Improvement

Original address 1. Use Exec() to run dynamic SQLcreate procedure Nosniff1(@i int) as declare @cmd varchar(1000); set @cmd = 'SELECT count(b.SalesOrderID),sum(p.weight) from [Sales].[SalesOrderHeader] a inner join [Sales].[SalesOrderDetail] b on a.SalesOrderID = b.SalesOrderID inner join Production.Product p on b.ProductID = p.ProductID wh ...

Posted on Tue, 18 Jun 2019 12:18:33 -0700 by nadman123

Myql operation usage (3)

view View is a virtual table (non-real), whose essence is to get dynamic data sets according to SQL statements and name them. Users can get the result set by using only the name, and use it as a table. SELECT * FROM ( SELECT nid, NAME FROM tb1 WHERE nid &g ...

Posted on Mon, 03 Jun 2019 21:39:41 -0700 by Cochise

mysql sets username password, stored procedure, trigger

Summary exercises of mysql Modify root user password mysql -u root; mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root'; mysql> FLUSH PRIVILEGES; Log in to the root user and give the user the right to create the database; User: tester, password: wangan Create users: CR ...

Posted on Tue, 21 May 2019 16:11:13 -0700 by nanobots