_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.
create view View Name //(Create a view)
select Fi ...
Posted on Fri, 23 Aug 2019 05:54:07 -0700 by roopali
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
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.
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
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
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
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
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
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
inner join [Sales].[SalesOrderDetail] b
on a.SalesOrderID = b.SalesOrderID
inner join Production.Product p
on b.ProductID = p.ProductID
Posted on Tue, 18 Jun 2019 12:18:33 -0700 by nadman123
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.
nid &g ...
Posted on Mon, 03 Jun 2019 21:39:41 -0700 by Cochise
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
Posted on Tue, 21 May 2019 16:11:13 -0700 by nanobots