NAV: SLTechnology News&Howtos > Database >

• 

  Oracle and MySQL md5 encryption

  Mysql > select MD5 (15201061106); +-- + | MD5 (15201061106)

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

  Create an external table (external table)

  Upload "Email-Match Export.csv" to the SFTP Server-create directorycreate directory xtern

  2022-06-01 07:16:48 Views: 260
• 

  Oracle 12c ORA-28040: No matching authentication protocol processing method

  Although it can be solved in sqlnet.oraplus SQLNET.ALLOWED _ LOGON_VERSION=8, because this parameter has been abandoned at 12c, if you continue to use it, you will report "Usin" endlessly in alert/log.xml.

  2022-06-01 07:16:48 Views: 258
• 

  Multi-column switching in oracle

  Method 1: through the wm_concat function, the function can be used in 10g, incompatible in 11g, removed from 12g, and the return type is varchar syntax: wm_concat (column) example: Select wm_concat

  2022-06-01 07:16:48 Views: 215
• 

  Mysql self-increasing column

  1. Mysql creates a table create table inc (id int (10) not null auto_increment,name varchar (20), primary key (id) with self-increasing columns)

  2022-06-01 07:16:47 Views: 252
• 

  Live Review | Database operation and maintenance is no longer difficult, database "autopilot" technology has arrived

  Tencent Cloud Database domestic database online technology salon is in full swing. Hao Zhigang's sharing has ended on March 26th. For those who have not had time to participate, don't worry. Here is the live video and text review. Follow the official account of "Tencent Cloud Database" and reply to "0326 Hao Zhigang", that is

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

  Automatic generate create table sql

  Click (here) to collapse or open-- CREATE PROCEDURE gen_createtbl @ tbl_name varchar (100)-- ASset nocount on-- declares the variable decla required by the cursor

  2022-06-01 07:16:27 Views: 264
• 

  Sql replaces the code with the translation corresponding to the code table

  The first table and the second table create the final demand simulation statement: create table a (id number,name varchar2 (30), code varchar2 (30)); insert into a valu

  2022-06-01 07:16:22 Views: 241
• 

  Rac stops resources

  Click (here) to collapse or open 10. 6. 69. 21 node110. 6. 69. 23 node1-vip192. 168. 6. 11 node1-priv10. six

  2022-06-01 07:16:15 Views: 215
• 

  Summary of several main parameter settings related to innodb in MySQL

  1). In order to improve performance, innodb_buffer_pool_size can merge the data to be written in the buffer buffer, and then send it to the next level of storage. Doing so can improve the efficiency of reading and writing. InnoDB Buffer Po

  2022-06-01 07:16:15 Views: 205
• 

  AWR, ASH, ADDM and consultant programs

  Automatic workload knowledge Base (AWR) Oracle collects a large number of statistical information about performance and activity, which is accumulated in memory and periodically written into a table called automatic workload knowledge Base (AWR). AWR as a set of tables in the database SYSAUX tablespace and its

  2022-06-01 07:16:14 Views: 262
• 

  Interpretation of PostgreSQL Source Code-background process # 3 (checkpointer process # 2)

  This section briefly introduces the background process of PostgreSQL: checkpointer, and mainly analyzes the implementation logic of CreateCheckPoint function. 1. Data structure CheckPointCheckPoint XLOG reco

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

  Database introduction and MySQL5.7 version compilation and installation (actual combat! )

  The basic concept data of the database: the symbolic records that describe things are called data (Data), including numbers, text, graphics, images, sound, archival records, etc., and stored in a unified format in the form of "records". Table: by organizing different records together, a "table" is used to store specific

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

  MYSQL max_user_connections back_log max_connections parameters and Max_used_connections

  Original please indicate source 1. The parameter max_user_connectionsmax_user_connections is the maximum number of sessions allowed to connect to a single user, and there is a similar limit when establishing a user. What is said here is only that the following parameter is

  2022-06-01 07:16:00 Views: 241
• 

  Detailed explanation of MySQL data and Redis cache consistency scheme

  There is generally no problem with reading Redis steps, but when it comes to data updates: database and cache updates, it is easy to have data consistency problems between cache (cache) and database (cache). Whether it is to write the MySQL database first and then delete the Redis cache; or first

  2022-06-01 07:15:59 Views: 218
• 

  Mysql_upgrade

  When configuring master and slave on the test environment: CHANGE MASTER TO MASTER_HOST='10.30.xx.xxx',MASTER_USER='repl',MASTER_PASSWORD='123456'

  2022-06-01 07:15:59 Views: 271
• 

  [Mysql] the construction of Mariadb multi-master and one-slave

  Background: at present, MySQL still only supports one Slave to copy data from one Master. Although it can also achieve the architecture of one master, multi-backup (M-> S) and two-master replication (M <-> M), it is still very limited. Due to the requirements of the project, the tables of each main library need to be integrated into one

  2022-06-01 07:15:58 Views: 233
• 

  DBA_TAB_STATISTICS view

  DBA_TAB_STATISTICS displays optimizer statistics for all tables in the database. Its columns are the same as those in ALL_TAB_STATISTICS. ALL_TAB_STATISTICS displays the optimizer family of tables that the current user can access

  2022-06-01 07:15:58 Views: 270
• 

  Mysql Basics (IX) Indexes and views

  Index: a special type of data stored in a specific storage format for SQL query indexes: clustered index and nonclustered index: whether the data is stored with the index primary key index and secondary index: whether the index is on the primary key with the left prefix index and overlay index: whether to truncate only

  2022-06-01 07:15:58 Views: 215
• 

  Mysql Learning 8: chapter 4: database Files-Log Files

  1.1. The error log file (error log) is stored in the data directory and ends with error.log by default. View file location: show variables like'% og_error%'; pay attention to warnin

  2022-06-01 07:15:57 Views: 286