NAV: SLTechnology News&Howtos > Database >

• 

  SQL statement optimization

  1. SQL statement optimization (1) View the table structure MariaDB [oldboy] > desc test1;+-+-+ | F

  2022-06-01 13:10:32 Views: 234
• 

  Mongo shell startup configuration file .mongorc.js (1)

  Mongo shell startup configuration file .mongorc.js (1) when started, mongo checks a JavaScript file .mongorc.js in the user's HOME directory. If found, mongo displays a prompt for the first time

  2022-06-01 13:10:32 Views: 290
• 

  Manipulate MySQL database

  What is SQL? SQL is a structured query language, a computer language used to store, manipulate, and retrieve data stored in relational databases. SQL is the standard language of relational database system. All relational database management systems, such as MySQL, MS Access

  2022-06-01 13:10:23 Views: 276
• 

  The correct posture in which the CVM binds the host name

  The correct posture for binding the hostname to a CVM. It is not recommended to install oracle on the CVM when I am working on the solution. But with the deepening of publicity, some people want to do this. The day before yesterday, I was asked to install oracle rac clusters in a certain degree of cloud. I really don't know how.

  2022-06-01 13:10:23 Views: 234
• 

  Postgresql configuration parameters

  # basedata_directory ='/ dbdata/data'hba_file ='/ dbdata/data/pg_hba.conf'ident_file ='/ dbdata/data/

  2022-06-01 13:10:10 Views: 271
• 

  Steps to complete incremental data backup and recovery using innobackupex

  Step 1. Use innobackupex to complete incremental data backup and recovery. Planning backup catalog and configuration and my.cnfmkdir / backup/mysql/fullmkdir / backup/mysql/daily1mkd

  2022-06-01 13:10:10 Views: 293
• 

  Using spark to analyze mysql slow logs

  Children's shoes who are familiar with oracle know that there are many views in oracle that record the metrics implemented by sql, and we can write scripts according to our own needs to get the performance cost of sql from oracle. As an open source database, mysql is no better than oracl

  2022-06-01 13:10:10 Views: 294
• 

  Grouping TOP N records with MariaDB Window Functions window function

  The window function is implemented in the MariaDB10.2 version, which simplifies the writing of complex SQL and improves readability. In some ways, window functions are similar to aggregate functions, but unlike aggregate functions, which return only one value per group, window functions can return multiple values for each group. As a kind of high

  2022-06-01 13:10:10 Views: 264
• 

  Triggers do work.

  MYSQL: create a trigger to automatically save the deleted data to a backup table when deleting a table, and add the deletion time: set up a backup table: CREATE TABLE `products_ `(prod_id int (11) N)

  2022-06-01 13:10:09 Views: 289
• 

  Oracle function-one-line function-conversion function, conditional expression

  One-line function = = characteristic: each line returns a result, and there is an one-to-one corresponding relationship between input and output that can be nested and used, a function

  2022-06-01 13:10:04 Views: 210
• 

  Sqlserver gets the current time

  Select'This + (replace (convert (varchar (23), getdate (), 121),'-','),','),':','

  2022-06-01 13:09:44 Views: 282
• 

  Mysql master-slave mycat installation Concise tutorial

  First, the database is basically installed with 1.down mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz2.install# yum install-y perl perl-Data-D

  2022-06-01 13:09:44 Views: 292
• 

  Build bugzilla by RHEL6.5/Centos6.5

  Install httpd, mod_ssl, mysql-server, mysql, php-mysql, gcc, perl*, mod-perl-devel [root@localhost]

  2022-06-01 13:09:44 Views: 271
• 

  Understand ORACLE REDO and UNDO

  When you record redo-- > undo-- > datafileinsert, the table and undo information will be put into redo, and before or before commit, redo information will be put on the hard disk. In case of failure, redo can recover.

  2022-06-01 13:09:43 Views: 216
• 

  Django web specifies the Chinese character set

  When creating a simplecmdb project with django under linux, if you use Chinese coding, you need to use uft8's character set CREATE DATABASE`cmdb` DEFAULT CHARACTER when creating a mysql database.

  2022-06-01 13:09:40 Views: 233
• 

  The meaning of the _ id field of MongoDB and the weight of MongoDB database

  Navicat Premium is a database development tool that allows you to connect to both MySQL,MariaDB,MongoDB,SQL Server,Oracle,PostgreSQL and SQLite data from a single application

  2022-06-01 13:09:34 Views: 209
• 

  Mysql creates a new user and authorizes access to the database

  1.mysql-uroot-p2. Enter password: 3.update mysql.user set authentication_string=password ('123456') where user=

  2022-06-01 13:09:33 Views: 270
• 

  Introduction to five types of redis

  1. Redis is most suitable for all data in-momory scenarios. Although Redis also provides persistence, it is actually more of a disk-backed function, which is quite different from persistence in the traditional sense.

  2022-06-01 13:09:25 Views: 211
• 

  Data pump-EXPDP

  EXPDP/IMPDP can only run in the database server segment: path upload and direct path loading technology are adopted to improve the execution efficiency. A large amount of data can be imported and exported in parallel with multiple threads on the database server. DBMS_DATAPUMP PL/SQL can be used

  2022-06-01 13:09:24 Views: 207
• 

  Redis single instance, multi-instance, master-slave synchronous actual combat

  [install redis single instance] yum-y install gcc gcc-c++ # install the compiler tool cd / optwget-c http://download.redis.io/releases/

  2022-06-01 13:09:24 Views: 268