NAV: SLTechnology News&Howtos > Database >

• 

  MySQL PXC deployment practice

  The article draws lessons from: https://www.cnblogs.com/zejin2008/p/5475285.htmlyum installation: wget https://www.percona.com/downloads/Pe

  2022-06-01 16:07:16 Views: 270
• 

  Mysql Foundation (4) user Rights Management and root password recovery

  The mysql user consists of a user and a host name. Using 'user'@'hosst', the user and permission information of mysql is stored in the mysql database. Mysql database table: user # user account, global permissions db # library level permissions host # master

  2022-06-01 16:07:07 Views: 273
• 

  Mysql does not need to copy three kinds of DDL of the table

  We only support partial online ddl when we know mysql5.6, but the following three ways of writing ddl do not need to copy the table: field comment alter table testtable change testcolumn testco

  2022-06-01 16:07:06 Views: 286
• 

  Database instance and listen for boot self-startup settings under linux

  Linux Database instance listening Boot setup 2016-5-16 zhanky script introduction before we start, let's introduce a few scripts that will be used. The orataboratab file is created when the database instance is created, and root is used during installation

  2022-06-01 16:07:06 Views: 226
• 

  Overview of commonly used SQL languages (DDL, DML, DQL)

  As we all know, SQL (Structure Query Language) is the core language of the database, recently learning the database, some of the basic concepts are a little ambiguous, today simply record these commonly used SQL concepts to make a distinction. Classification: DDL:

  2022-06-01 16:07:05 Views: 238
• 

  The usage of substr in oracle

  Select * from user where substr (user_flag,4,1) = 1 / / query the content where the first character of bit 4 of user_flag equals 1. Substr (content, which place to start, how many places to take)

  2022-06-01 16:07:05 Views: 245
• 

  It is easy to jump to different pages with different login permissions in servlet.

  Many friends first contact javaweb and servlet to manage different user roles in the system to enter the pages with corresponding permissions for corresponding permissions. Generally speaking, there are many ways. The easiest way to think of is to insert a column of fields with permissions (perm) directly in the user database.

  2022-06-01 16:07:05 Views: 233
• 

  Sqlite3 installation method

  Sqlite3 installation method official website: http://www.sqlite.org here is not in the form of the installation package, after download is the following two files: decompress to the same directory, as shown in the figure: after "installation" is completed, remember to add system environment variables for command-line operation

  2022-06-01 16:06:53 Views: 257
• 

  Redis-4.0.1 installation configuration (CentOS 6.6)

  I. Redis service installation configuration 1. Download the redis package # wget http://download.redis.io/releases/redis-4.0.1.tar.gz# tar zxvf re

  2022-06-01 16:06:47 Views: 293
• 

  Cursors for Oracle topic 12

  -what is a cursor? A cursor is a memory workspace of SQL, defined by the system or the user in the form of variables. The purpose of cursors is to temporarily store blocks extracted from the database. In popular terms, a cursor is a result set. Cursors are divided into explicit cursors and implicit cursors. 1. Show

  2022-06-01 16:06:47 Views: 243
• 

  Big data's essential database MongoDB 3.6 installation, stand-alone and multi-instance

  About MongDB MongoDB is a database based on distributed file storage. Written in C++ language. Designed to provide scalable high-performance data storage solutions for WEB applications. MongoDB is a product between relational database and non-relational database.

  2022-06-01 16:06:47 Views: 207
• 

  Mongodb Explain and Index

  There are three modes of Explain and Indexexplain: queryPlanner, executionStats, and allPlansExecution. In real development, executionSta is commonly used.

  2022-06-01 16:06:46 Views: 235
• 

  MapReduce on Hbase

  Org.apache.hadoop.hbase.mapreduceTableMapper TableReducer one region corresponds to one mapimport java.io.IOException;i

  2022-06-01 16:06:46 Views: 232
• 

  Several commonly used commands: df, dd, du, locate, find

  Df command: df-report file system disk space usagedf [OPTION]. [FILE]...-h,-- human-readble: unit conversion-l,-l

  2022-06-01 16:06:46 Views: 249
• 

  MySQL modify data table sql statement

  Mysql uses update to modify data, and UPDATE statements to change the column values of a single row, a set of rows, or all rows in a table. Here is a detailed description of update usage 1 update model UPDATE table_name SETcolumn_na

  2022-06-01 16:06:45 Views: 265
• 

  Oracle universal stored procedure

  Create or replace procedure proc_data_check is-- defines variables V_LOCK_ID INTEGER;v_lockhandle VARCHAR; V_RE

  2022-06-01 16:06:45 Views: 222
• 

  A brief introduction to the setting of scheduled tasks in the new version of the platform

  1. Send the same email content to fixed personnel 2. Send different email content to different personnel for details. Please see the original address of the document updated later: http://bbs.delit.cn/thread-1098-1-1.html reprint, please indicate the source:

  2022-06-01 16:06:43 Views: 242
• 

  OSPF header and various message formats

  To understand the working principle of OSPF routing protocol, especially the routing update mechanism, we must first have a comprehensive understanding of its various message formats. There are five main types of OSPF messages: Hello message, DD (Database Description, database description)

  2022-06-01 16:06:29 Views: 283
• 

  Linux installs the MySQL-MariaDB version

  Share a version that is easier and faster to install than the MySQL5.7 version: MariaDB. Before the start of the experiment, turn off the firewall: service firewalld stopsetenforce 0 and then configure ALI cloud source: wget

  2022-06-01 16:06:26 Views: 211
• 

  The correct definition of the sequence in the table (adhesion configuration between the table and the sequence)

  When the table sequence, structure and data are exported in the way of the specified table in the database, the table structure and data are exported, but the sequence is not exported, so it is sorted out to explain the correct way to create the sequence: first, the sequence creation method 1.serial primary key to establish the sequence test

  2022-06-01 16:06:26 Views: 213