NAV: SLTechnology News&Howtos > Database >

• 

  MySQL database and table operations

  -- create database-- create classroom database create database database name default character set character encoding collate collation; eg:create da

  2022-06-01 06:19:45 Views: 263
• 

  MySQL: an approximate flow of a simple insert statement

  Simple recording, which may be incorrect, mainly records important interfaces for later use. Operation instructions I built a simple table and inserted a simple data. Mysql > create table testin (id int); Query OK, 0 row

  2022-06-01 06:19:45 Views: 233
• 

  Summary between TIMESTAMP and TIMESTAMP WITH TIME ZONE

  TIMEZONE refers to the time difference between the local time and the prime meridian Greenwich time in England. Beijing is East eighth District (+ 08:00), that is, Beijing time-Greenwich = 8 hours. Beijing saw the sun SELECT DBTIMEZONE,SESS 8 hours earlier than Greenwich.

  2022-06-01 06:19:45 Views: 302
• 

  Gc buffer busy

  Gc buffer busyThis wait event, also known as global cache buffer busy prior to Oracle 10g,specifies

  2022-06-01 06:19:45 Views: 249
• 

  How to view redis memory usage

  Redis memory usage > how to view redis memory usage Redis is an open source (BSD licensed), in-memory data structure storage system that can be used as database, cache, and messaging middleware. One of the basic features of Redis is the in-memory database, because

  2022-06-01 06:19:44 Views: 244
• 

  Deeply parsing and customizing Oracle optimization tools

  First of all, I don't know how to Oracle. I think I can understand it. Haha, because I don't specifically talk about too detailed things in oracle. The content of this part is more general and can be used for reference. I will mix these ideas in my platform, in short, after there are goods and materials, plus time and energy, like Yang

  2022-06-01 06:19:39 Views: 255
• 

  An example of creating Index query for MySQL5.7 JSON Type column

  Create a table of type json test:mysql > CREATE TABLE test (data JSON); Query OK, 0 rows affected (0.47 sec) mysql > insert

  2022-06-01 06:19:39 Views: 204
• 

  Oracle EBS database password complexity setting

  To meet the audit requirements, the password of the default configuration file needs to be set in complexity. The specific steps are as follows: 1. Check the configuration file related to the password setting of Oracle database; SELECT * FROM Dba_Profiles d WHERE d.profile

  2022-06-01 06:19:34 Views: 203
• 

  Uninstall and reinstall GRID

  GRID needs to be reinstalled due to previous erroneous installation or other problems, the following error installation orace grid infrastructure prompt "[INS-40404] The installer has detected" appears

  2022-06-01 06:19:33 Views: 201
• 

  Summary of oracle dblink usage and expdp and impdp use dblink to pour in and export to local

  Database link in oracle is an object that defines the path from one database to another. Database link allows you to query remote tables and execute remote programs. In any distributed environment, dblink is necessary, and pay attention to da

  2022-06-01 06:19:25 Views: 276
• 

  The solution to oerr ora 000845 is to expand / dev/shm space

  Open the virtual machine to discover that the instance cannot be opened [root@wenxi ~] # su-oraclesq [oracle@wenxi ~] $sqlplus / as sysdbaSQL*Plus: Release 11.2

  2022-06-01 06:19:24 Views: 235
• 

  [OGG] collation of basic knowledge of OGG

  [OGG] OGG basic knowledge collation I. GoldenGate introduction GoldenGate software is a kind of structured data replication software based on log. GoldenGate can capture, transform and deliver a large amount of transaction data in real time, and realize the source database and target.

  2022-06-01 06:18:33 Views: 217
• 

  Compilation and Construction of Pure Source Code in apache+mysql+php Development Environment under linux (transfer)

  Build pure source code for apache+mysql+php development environment under linux [@ more@] record all the history of the apache+mysql+php development environment that I compiled through source code under fedora core 1

  2022-06-01 06:18:33 Views: 290
• 

  Mysql8.0.16 compilation and installation under Centos 7.6

  Centos 7.6.Compiler and installation of Mysql8.0.16 1. Minimize installation system 2. Install the base package yum-y install ntpdate gcc gcc-c++ ncurses ncurses-devel

  2022-06-01 06:18:30 Views: 270
• 

  Analysis of the problem of no response of insert statements in MySQL (R11 notes, day 21)

  Today, a classmate in development asked me a question about MySQL and said that he had not responded for a long time after executing an Insert statement in the test database. I see that the statement is a very regular statement in the form of insert into xxx values. It looks a little out of place.

  2022-06-01 06:18:30 Views: 288
• 

  The method of "replication" of mysql Database

  > mysqldump wap-u root-ppassword-- add-drop-table | mysql test-u root-ppassword is copied to the local wap database.

  2022-06-01 06:18:24 Views: 294
• 

  MySQL backup and recovery tool atlas

  I didn't organize it carefully before, and I feel that the backup tool is mysqldump,xtrabackup, but if you think about it, you will find that there are still many other rich features. For example, the logical export of data, such as the data of a table (all, part), etc. can be very convenient.

  2022-06-01 06:18:24 Views: 298
• 

  Oracle control file

  Oracle control file one. Oracle controls the contents of the file. We can view the contents of the control file through the v$controlfile_record_section view. S

  2022-06-01 06:18:23 Views: 210
• 

  Commands related to mysql lock analysis

  1. Server-level lock waiting can see the thread id waiting for the lock through the show (full) processlist, but it is impossible to know which thread holds the lock through the mysqladmin debug-related thread waiting for the lock and who holds the lock.

  2022-06-01 06:18:23 Views: 224
• 

  Migration of EAS attachment tables from database to FTP

  EAS attachment table is migrated from database to FTP environment description: EAS:EAS8.2DB:Oracle 11.2.0.1.0FTP: vsftpd-2.2.2FTP_OS: CentOS release 6.7 (Fin

  2022-06-01 06:18:18 Views: 215