Programmer Group

When querying the status of materialized view and other information, monitoring and management, it is necessary to query the system view. The following lists the commonly used query statements for materialized view status, dependency Association, and batch maintenance, which can be modified according to the specific sit ...

There are two methods for inserting MySQL test data: Select the priority (generate test data in combination with PHP > use stored procedures). Use stored procedures (it is recommended to use this method when the test data is less than 1000) The specific code is as follows: To create a table: 1 mysql> create table TB1( 2 -> id in ...

Recently, when dealing with a table splitting problem, we need to create a stored procedure for the program to automatically split tables. We need to ensure that all table structures, constraints, indexes, etc. are consistent. In addition, views, stored procedures, permissions, etc. are not considered temporarily. In Mysql, the procedure of cre ...

What is a stored procedure? That is, you can write logical sql, such as judgment, loop, etc,, What are the benefits? Imagine that we want to insert 100 pieces of data. Compared with batch operation, it is sure that the efficiency of the stored procedure is high In addition, the running speed of stored procedures is v ...

Statistics of the amount of data in a table is a common requirement, but different table designs and different writing methods can lead to large differences in statistical performance. Here is a simple experiment to test (everyone should pay attention to the cache when testing, otherwise the test results will be affected). 1. Preparations In or ...

Business description: table A is the detailed statement of table B. now it is required that table B has millions of records. Insert the relevant records of table B in table A. Preparation: oracle database, database tool pl\sql, stored procedures written in the package. Implementation ideas: 3.1 get the total data volu ...

1. Create user table CREATE TABLE user100w( id INT NOT NULL AUTO_INCREMENT, first_name VARCHAR(10) NOT NULL, last_name VARCHAR(10) NOT NULL, sex VARCHAR(5) NOT NULL, score INT NOT NULL, copy_id INT NOT NULL, PRIMARY KEY (`id`) ); 2. Create stored procedure DROP PROCEDURE IF EXISTS add_user; DELIMITER / ...

1. Requirements: from 10:00 p.m. to 5:00 a.m. every day, execute the stored procedure regularly every 10 minutes. 2. Implementation mode: there are two ways to achieve it: One is more conventional. Using mysql event timing task, first introduce the related commands of event timing task in mysql, To see if event is enabled: ...

Parameterless stored procedure: create or replace procedure sayhello as --Explanation part begin dbms_output.put_line('hello world'); end; 1 2 3 4 5 6 Two call methods of command window 1. SQL> set serveroutput on; --The first time I have to drive SQL> exec sayhello hello world PL/SQL procedure successfully comple ...

Catalog mysql generates a lot of data automatically Create random number generation Generate random string Generate random number, return varchar type data combination, such as cell phone number Create user table myisam engine Create stored procedure generate data Create table innodb engine mysql generates a lot of data automatically In or ...