NAV: SLTechnology News&Howtos > Database >

• 

  Database management tool Navicat Premium, which validates data using triggers in MySQL 8

  Navicat Premium is a set of database management tools that allow you to connect to MySQL, MariaDB, SQL Server, SQLite, Oracle and PostgreSQL databases simultaneously using a single program. it

  2022-06-01 16:29:19 Views: 246
• 

  Postgresql view table structure and field comments

  Postgresql view table structure and field notes 1: view table structure (field) information: Select table_name,column_name,data_type,character_maximum_length f

  2022-06-01 16:29:19 Views: 224
• 

  Sys.dm_os_ring_buffers inside story

  Sys.dm_os_ring_buffers insider translation from: https://mssqlwiki.com/2013/03/29/inside-sys-dm_os_ring_buffers/Sys.dm_os

  2022-06-01 16:29:18 Views: 213
• 

  ORACLE solves the problem of unable to drop

  The reason that the database object cannot DROP is that the object is being executed, and the other is that the resource is not released after the object execution. The first case is to cancel or pause calls to objects that may be deleted. In the second case, kill a session in oracle uses the following statement: s

  2022-06-01 16:29:18 Views: 239
• 

  What are the implementation methods of Redis distributed lock

  Distributed lock is a way to control synchronous access to shared resources between distributed systems. In distributed systems, it is often necessary to coordinate their actions. If one or a group of resources are shared between different systems or between different hosts of the same system, mutual exclusion is often needed to prevent access to these resources.

  2022-06-01 16:29:12 Views: 218
• 

  Note: tips for using xshell

  After switching accounts with su in xshell, an error will be reported if the command entered is related to the graphical interface. First log in with the root account, then su switch to oracle to execute the command: log in directly with the oracle account and execute the command:

  2022-06-01 16:29:12 Views: 238
• 

  Initially immediate and initially deferred

  Initially immediate initialization executes immediately. Initially deferred initialization delays execution. Table constraint definition: [CONSTRAINT name] {PR

  2022-06-01 16:29:11 Views: 230
• 

  Separation of SQL Learning and additional Database

  1. To separate a database is to delete a database from the list of SQL Server databases so that it is no longer managed and used by SQL Server, but the files (.MDF) and corresponding log files (.LDF) of the database are intact. After the separation is successful, we can

  2022-06-01 16:29:02 Views: 274
• 

  First contact with Oracle stored procedure

  CREATE TABLE STUDENT (ID NUMBER (10) NOT NULL, NAME VARCHAR2 (10), SEX CHAR (1), AGE Number (3), CREATIONDA

  2022-06-01 16:29:02 Views: 249
• 

  Shell reads the oracle table and exports it to a file

  Export ORACLE_BASE=/opt/oracleexport ORACLE_HOME=/opt/oracle/product/11gR1/dbexport ORACLE_SID=ORALD

  2022-06-01 16:28:32 Views: 259
• 

  Installation and configuration of mysql server

  MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility. The SQL language used by MySQL is the most commonly used standardization for accessing databases

  2022-06-01 16:28:32 Views: 278
• 

  Detailed explanation of mysql authorization method for remote connection

  Today, there is a mysql database on the server, remote access, do not want to publish the root account, so, created a demo account, allowing the demo account to access the shandong library in the mysql database anywhere. Plan 1: transport it on the machine where mysql is installed

  2022-06-01 16:28:31 Views: 275
• 

  Oracle 11gR2 silent silent installation

  1. Download oracle 11g http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html2, system

  2022-06-01 16:28:31 Views: 216
• 

  Date format problem when oracle imports files

  Date format problem load datainfile'/ iot/opthb/TIBS_HOME/xcx/test/loadfile.txt'truncate into table zh when oracle imports a file

  2022-06-01 16:28:31 Views: 266
• 

  RDBMS data is collected regularly to HDFS.

  [toc] it is not difficult to regularly collect RDBMS data into the preface of HDFS, that is, to use sqoop to import from MySQL to HDFS, mainly the knowledge of the use of sqoop commands and the operation of Linux scripts. The scene in our scene, we need to set the

  2022-06-01 16:28:30 Views: 250
• 

  Sorted sets type and operation of redis

  Sorted sets type and operation sorted set is an upgraded version of set, which adds a sequence attribute based on set, which can be specified when adding modified elements. After each assignment, zset will automatically re-adjust the order according to the new value.

  2022-06-01 16:28:30 Views: 224
• 

  Linux centos7 install mysql5

  Install under Linux centos7 mysql installation 1.1 installation package ready to install mysql under Linux source code installation and rpm installation are the main installation methods. This note uses rpm to install mysql5.5.48.

  2022-06-01 16:28:13 Views: 288
• 

  Installation and deployment of MongoDB in Windows

  MongoDB installation and deployment test environment in Windows: Microsoft Windows 7 (flagship 64-bit) MongoDB 3.0.2 (Windows 64-bit 2008 R2 +) installation text

  2022-06-01 16:28:10 Views: 202
• 

  Linux system quota and RAID

  This article: first, system quota under Linux 2, RAID 1 under Linux, system disk quota setting and checking disk quota on file system to prevent users from using more space than allowed, but also to prevent the entire file system from being accidentally filled. An overview of the implementation of file systems in the kernel

  2022-06-01 16:28:07 Views: 291
• 

  Basic installation configuration of Mongodb

  Download the software, version mongodb-linux-x86_64-2.0.2.tgz extracted directory: mongodb-linux-x86_64-2.0.2 and then transferred to the directory / usr/local/mongodb

  2022-06-01 16:27:37 Views: 276