NAV: SLTechnology News&Howtos > Database >

• 

  What is the difference between the isolation level and the propagation level of a transaction

  The isolation level of a transaction the isolation level of a transaction originates from the I (Isolation) of transaction ACID, that is, when multiple transactions operate the same entity at the same time, the read and write operations of one transaction affect the visibility of other transactions and themselves. It can be divided into the following levels: read something that has not been submitted.

  2022-06-01 17:07:23 Views: 265
• 

  InnoDB data Dictionary details-system Table

  1. Introduction to InnoDB, you can't actually see the system table. There are four basic system tables to store table metadata: table, column, index, index column, and so on. These four tables are SYS_TABLES, SYS_COLUMNS, SYS_INDEXES and SYS.

  2022-06-01 17:07:19 Views: 269
• 

  Creation and use of 15.PL_SQL--Function

  = Example 1 = [oracle@localhost notes] $vim s81.sqlCREATE OR REPLACE FUNCT

  2022-06-01 17:06:58 Views: 217
• 

  Solve the problem that the mysql open_files_limit configuration of ubuntu system does not take effect

  Recently took over the maintenance of a mysql server, the system is ubuntu 16.04 MySQL version 5.7. the installation mode is that when apt checks the mysql configuration parameters, it is found that open_files_limit is 1024, which is a little small and needs to be scaled up a bit first.

  2022-06-01 17:06:58 Views: 241
• 

  Django Model of 4Python full Stack Road Series

  The Django model of the Python full stack family MTV development model the concept of combining data access logic, business logic, and presentation logic is sometimes referred to as the Model-View-Controller (MVC) pattern of software architecture. In this mode, M

  2022-06-01 17:06:58 Views: 285
• 

  Python orm framework SQLAlchemy simple application (database operation)

  # _ * _ coding:utf-8_*_''' create SQLAlchemy application basic process 1, create a connection (create a connection with a relational database) 2, declare a mapping file (one-to-one mapping from python to classes and tables in the database, so that you can use py

  2022-06-01 17:06:51 Views: 237
• 

  MySQL insert data

  MySQL inserts data into the MySQL table using INSERT INTOSQL statements to insert data. You can insert data into the datasheet through the mysql > command prompt window, or through the PHP script. The syntax below is the number to MySQL

  2022-06-01 17:06:47 Views: 273
• 

  Oracle creates tablespace user authorization

  Create tablespace user authorization create tablespace liuzhen_tablespace datafile'D:\ liuzhen_oracle_data\ liuzhen_data.dbf' s

  2022-06-01 17:06:46 Views: 282
• 

  Create a new oracle database instance under linux

  1. Create an instance dbca using DBCA tool

  2022-06-01 17:06:42 Views: 253
• 

  What should I do if mysql forgets my password?

  How do I set a password for an administrator? External command set password mysqladmin-uroot password=' the password to be set by yourself 'sql statement sets password mysql > update mysql.user set passwor

  2022-06-01 17:06:42 Views: 269
• 

  MySQL bin-log

  What is 1.bin-log? Bin-log is a very important log for MySQL. It records all DDL and DML (except data query statements) statements in the form of events, as well as the time spent on the execution of the statements. The binary log of MySQL is transaction security.

  2022-06-01 17:06:42 Views: 261
• 

  Internal and external Network access of Kafka Cluster based on SASL+ACL

  Requirements: Kafka pseudo-cluster is deployed on Ali Cloud ECS server, which requires broker to use private network Nic when other machines in private network access, and public network Nic for external users to access IP: private network: 10.130.10.10 Public network: 12.12.12.12 solution:

  2022-06-01 17:06:41 Views: 291
• 

  AliSQL-5.6.32 compilation and installation

  1. System environment CentOS 6.8_X642, required software mirrors-alisql-master.zip and required dependency package centos-release-scl devtoolset-4-gcc-c+

  2022-06-01 17:06:41 Views: 276
• 

  Installation of MongoDB under Mac

  I haven't posted a blog for a long time ~ one today ~ less nonsense ~ GoOn. One: HomeBrew introduction and installation introduction: it is a software package management tool on mac that facilitates installation and uninstallation. Installation: open the terminal and enter the following command, during which you will enter one enter + two boot passwords. Rub

  2022-06-01 17:06:41 Views: 276
• 

  Mysql- rights management

  First, grant authorization (create and authorize users, users created in this way have to create databases, tables, etc.): grant permission type on library. Table / function / stored procedure to 'username' @ 'host' [identified by 'test

  2022-06-01 17:06:41 Views: 219
• 

  Installing Oracle 11G RAC on Linux 6

  Vi / etc/hosts10.254.28.11jwdb0110.254.28.12jwdb0210.254.28.13 jwdb01-vip10.254.28.14jwdb02-vip6.6.7.

  2022-06-01 17:06:40 Views: 312
• 

  Oracle learning note comparison operation

  < > = < = > = < > (not equal to)! = (not equal to): = (assigned) between... And (including boundaries in a range)-query salary select salary from empl for wages between 2000 and 5000

  2022-06-01 17:06:40 Views: 212
• 

  MySQL 5.5.32 compilation and installation

  1. Prepare the installation environment # wget-O / etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo# yu

  2022-06-01 17:06:40 Views: 235
• 

  JDBC connection database instance

  Package javacommon.base;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql

  2022-06-01 17:06:39 Views: 291
• 

  PHP PDO transaction preprocessing Gao Luofeng details PHP

  PDO error handling three modes / * * database abstraction layer PDO * A DSN consists of the PDO driver name, followed by a colon, and the connection syntax of the specific PDO driver. * PDO::ERRMODE_SILENT * PDO

  2022-06-01 17:06:39 Views: 238