NAV: SLTechnology News&Howtos > Database >

• 

  Linux Learning-General commands use 1

  System user PS1 defines the format of the prompt for example: PS1=XXX current user name will be temporarily modified echo $PS1 [\ u @\ h\ W]\ $/ / u represents the user, h hostname W current folder # administrator $normal user command type

  2022-06-01 13:43:46 Views: 298
• 

  Establishment, deletion and expansion of oracle users and tablespaces

  Create user mcc identified by manager;, be careful not to use single quotation marks to enlarge passwords. Drop user mcc cascade; delete user create user mcc directly

  2022-06-01 13:43:45 Views: 225
• 

  Mysql-8.0.16-winx64 installation

  Suggestion [3Grand General]: the command / mysqld.exe cannot be found, but it does exist in the current location. By default, Windows PowerShell does not load commands from the current location. If you trust this command, please

  2022-06-01 13:43:45 Views: 253
• 

  PXC failed to open gcomm backend connection: 110

  If you want to learn the PXC highly available architecture, please leave me a message ~ ~ PXC starts the first node to report an error as follows: 2019-08-12T03:24:10.282944Z 0 [Note] WSREP: Current view of clus

  2022-06-01 13:43:45 Views: 293
• 

  Oracle operation record

  Delete all tables: select 'drop table' | | table_name |'; 'from cat where table_type='TABLE'; exports all user tables: exp user/passw

  2022-06-01 13:43:45 Views: 235
• 

  Sql splicing multiple information in the same field

  Write down what you inadvertently use today, such as the T_Stu_Hobby student interest table. Associate the student table and the interest table. How can the many-to-many relationship Stu_ID Hobby_ID=1 11 21 32 12 2 achieve such a result

  2022-06-01 13:43:44 Views: 301
• 

  Analysis of ORACLE 11G SPM (SQL PLAN manager)

  The SPM launched by 11g is an active and stable means of implementing the plan, ensuring that only the verified execution plan will be enabled. SPM not only takes the initiative to implement the plan steadily, but also retains the opportunity to continue to use the new more efficient execution plan. When SPM is enabled, every SQL

  2022-06-01 13:43:44 Views: 236
• 

  BUG occurs when impdp imports data

  An error occurred in importing data with the impdp data pump tool, and the import process was aborted unexpectedly. After checking the data on the Internet, it is found that this is a BUG of 11G, and the EXCLUDE=STATISTICS parameter needs to be added when importing. Error prompt: ORA-39126: Wor

  2022-06-01 13:43:44 Views: 293
• 

  Deploy the MongoDB database on CentOS

  About MongoDB MongoDB is a cross-platform, document-oriented database. It can achieve high performance, high availability, and can be easily scaled. Is an open source database system based on distributed file storage. In the case of high load, adding more nodes can ensure server performance.

  2022-06-01 13:43:44 Views: 226
• 

  Redhat 6.4Oracle10G installation environment configuration

  Oracle installation environment content 1. Edit / etc/sysctl.confkernel.shmmni = 4096kernel.sem = 32000 100100 128kernel.shmmax = 5

  2022-06-01 13:43:40 Views: 270
• 

  Upgrade from MySQL 5.6 to MySQL 5.7-version upgrade best practice

  1. Background MySQL 5.7 is the latest version of MySQL. Compared with MySQL 5.6, it has the following characteristics * performance and scalability: improving the scalability of InnoDB and the performance of temporary tables to achieve faster network and big data loading and other operations.

  2022-06-01 13:43:40 Views: 244
• 

  Mongodb installation, configuration and simple operation

  The developer has a requirement for me to install a mongodb. I have consulted some information on the Internet and tested several kinds of either wrong or mismatched database commands. The following is relatively simple and not easy to make mistakes. Get binary package wget http://fastdl.mongo

  2022-06-01 13:43:40 Views: 235
• 

  Common functions of MySQL

  1. Mathematical function ABS (X) absolute value CEIL (X) rounding up FLOOR (X) rounding down random number RAND (X) 0-1 ROUND (X) the integer closest to x ROUND (XMagi Y) retains the decimal place y after x, used in truncation

  2022-06-01 13:43:40 Views: 285
• 

  Summary of common errors in linux installation oracle

  PS: novice, did not install the database, basically encountered all kinds of errors. History of Blood and tears 1, open 11.2.0.3 install foot error, check the log. The cause of the error may be that dns did not return the IP of the service name, or it may be that hosts has been viewed / etc/hosts

  2022-06-01 13:43:39 Views: 202
• 

  MyBatis simple configuration and simple query

  1. Copy the required jar (mysql-connector-java-5.1.18-bin.jar and mybatis-3.3.0.jar) to the lib directory 2. 0. Write the entity class UserInfo3. Create my

  2022-06-01 13:43:24 Views: 282
• 

  Memory summary of mongodb

  Pure hand play, only summed up through a variety of ways to view the memory usage of mongodb, and failed to put forward an effective way to reduce the memory of mongodb. It is said that mongodb eats memory very much, and it is really good. My data level has reached 40 million, and the amount of data is about 1.

  2022-06-01 13:43:24 Views: 203
• 

  [MySQL] standardized installation tutorial

  Introduction: this article mainly introduces the installation steps of CentOS system binary installation of MySQL version 5.7.23. The installation process of other versions is similar. 1. | prepares to uninstall the old version of MySQL before viewing the rpm package rpm-qa | grep mysql can be used if available |

  2022-06-01 13:43:24 Views: 217
• 

  Problems with non-root users performing psql

  After installing postgresql, the average user executes the psql error:''Can't locate strict.pm: / usr/local/lib/x86_64-linux-gnu/perl/5.22.1/st

  2022-06-01 13:43:23 Views: 213
• 

  Quickly delete child nodes and their affiliated nodes using mysql cursors

  In the previous article, I wrote how to use html to show the tree structure stored in the database. In this article, I will talk about how to quickly delete a tree node and its affiliated nodes through stored procedures. There are already a lot of articles about the use of mysql cursors on the Internet. Why should I write this article?

  2022-06-01 13:43:20 Views: 218
• 

  Detailed explanation of the principle and usage of xtrabackup

  An open source database backup tool, you can download it from the official website and use percona-backupxtra for incremental backup of InonoDB. In the face of MyISAM, you can maintain a full backup of the data. 1 xtrabackup can only back up innodb and xt

  2022-06-01 13:43:20 Views: 232