NAV: SLTechnology News&Howtos > Database >

• 

  Single-parameter or multi-parameter passing of MySQL stored procedure

  Almost all stored procedures developed by MySQL require parameters. These parameters make stored procedures more flexible and useful. In MySQL, there are three modes for parameters: IN,OUT or INOUT. 1, single parameter inDELIMITER $$USE dc3688 $$

  2022-06-01 10:03:38 Views: 288
• 

  Thematic report on table structure definition optimization

  The project description reads the database table structure definition of the Ecbil project, finds that there are common irrationality, and organizes the special report for the R & D team and DBA team to optimize, and assist in the future table structure definition design. Question 1 example table structure definition: 2 `id` BIGINT (2

  2022-06-01 10:03:35 Views: 293
• 

  Installation and use of Meituan Dianping SQL Optimization tool SQLAdvisor

  SQLAdvisor details SQLAdvisor is a SQL optimization tool developed and maintained by the Beijing DBA team of Meituan Dianping Company: input SQL, output index optimization recommendations. It is based on the original lexical parsing of MySQL, combined with SQL.

  2022-06-01 10:03:32 Views: 221
• 

  Restart MSSQL regularly to free memory

  Restart MSSQL regularly to free memory 1. In the property-"memory option, set an appropriate memory limit value according to the configuration of the server." 2, write the following bat file, and then add the plan net stop sqlserveragentnet in the task plan

  2022-06-01 10:03:32 Views: 257
• 

  How to install MongoDB 3.4 for CentOS7.2

  This article mainly shows you how to install CentOS7.2 MongoDB 3.4, the content is easy to understand, I hope you can learn, after learning there will be a harvest, the following let the editor take you to take a look at it. Server version CentOS7.2Mo

  2022-06-01 10:03:29 Views: 295
• 

  The record of the whole process of oracle dg master and standby switching SWITCHOVER

  [oracle@oraclep trace] $ifconfig enp0s3: flags=4163 mtu 1500 inet 10.0.2.15 netmask 255.255

  2022-06-01 10:03:28 Views: 266
• 

  How to create and use mysql triggers

  This article mainly explains how to create and use mysql triggers, the content is clear, interested friends can learn, I believe it will be helpful after reading. What is a trigger? a trigger is used to perform some actions "automatically" after / before certain actions. (for example, insert

  2022-06-01 10:02:58 Views: 246
• 

  Oracle 11g R2 storage structure

  Knowledge about data files if you want to see how many data files there are in the system, we can check them through dynamic data dictionaries or static data dictionaries: viewing data files through static data dictionaries, viewing data files through dynamic data dictionaries, directly viewing the contents of data files can not be seen, it must be viewed through a logical

  2022-06-01 10:02:58 Views: 238
• 

  How to use MySQL triggers

  This article mainly explains how to use MySQL trigger, the content is clear, interested friends can learn, I believe it will be helpful after reading. 1. MySQL trigger creation: 1. MySQL trigger creation syntax: CREATE [DEFIN

  2022-06-01 10:02:58 Views: 229
• 

  The difference between memcache Database and redis Database (Theory)

  After learning about memcache cluster and redis cluster, I have some questions: redis cluster supports more storage types than memcache cluster; redis cluster supports data persistence, which can better protect data integrity; so, why do some enterprises

  2022-06-01 10:02:40 Views: 205
• 

  ORA-32004: obsolete or deprecated parameter (s) spe

  Error found during database startup: ORA-32004 turns on log tracking, shuts down database restart, finds problems in parameter files: the key point is: Deprecated system parameters with specified valu

  2022-06-01 10:02:40 Views: 221
• 

  Oracle scalar quantum query

  SQL > conn scott/scottConnected.SQL > create table a (id int,name varchar2 (10)); Table created.SQL > cre

  2022-06-01 10:02:40 Views: 285
• 

  12c verify RMAN encrypted backup

  In daily work, we often encounter the need for backup, and then restore data off-machine to provide test data. In order to ensure the security of the data, it is recommended that you encrypt the backup. Test environment: Oracle 12c R1 RAC environment 1. The backup script is as follows: $cat rk_rman.sh

  2022-06-01 10:02:40 Views: 264
• 

  Modification of oracle user password never expires

  1. Check which user's proifle is, usually default:sql > SELECT username,PROFILE FROM dba_users;SQL > select * from all_users

  2022-06-01 10:02:39 Views: 292
• 

  How to write better SQL queries: the Ultimate Guide-part 2

  In the last article, we learned how SQL queries are executed and what you need to pay attention to when writing SQL query statements. Next, I will further learn the query method and query optimization. The implicit fact in the reverse model of query based on set and program method is that the query time base is established.

  2022-06-01 10:02:36 Views: 266
• 

  The Development and Application case of FineReport Printing of Web report

  Report printing is a problem often encountered in the process of report use and development. this paper summarizes some typical application cases about the development and printing function of Web report, taking the most widely used FineReport as an example. Case 1: java directly calls report printing when java background defines timing printing

  2022-06-01 10:02:33 Views: 299
• 

  How to use MYSQL performance Analyzer EXPLAIN

  This article mainly explains how to use the MYSQL performance analyzer EXPLAIN, the content is clear, interested friends can learn, I believe it will be helpful after reading. Usage: EXPLAIN SELECT * FROM user

  2022-06-01 10:02:24 Views: 263
• 

  How to use mysql triggers

  What the editor wants to share with you this time is how to use mysql triggers. The article is rich in content. Interested friends can learn about it. I hope you can get something after reading this article. Example: create trigger, record table add, delete, change operation record / / create user table

  2022-06-01 10:02:23 Views: 282
• 

  Self-increment causes duplicate primary key

  When a record is inserted, the value generated by the increment column may conflict with the existing record primary key, resulting in an error. First of all, find a way to solve the problem, by manually increasing the value of the self-increasing column to ensure that it is larger than the existing primary key in the table. After adjustment, the precondition for the normal problem of the guided data: 1.mysql replication

  2022-06-01 10:02:23 Views: 236
• 

  Table structure of HBase

  HBase's table structure HBase stores data in the form of a table. The table consists of rows and columns. Columns are divided into column families / column clusters (column family). As shown in the figure above, key1,key2,key3 is the only row key value for three records, co

  2022-06-01 10:02:20 Views: 262