NAV: SLTechnology News&Howtos > Database >

• 

  The use of PostgreSQL Database (3)

  System: Ubuntu 16.04.4 LTS PostgreSQL Database: PostgreSQL 10.5varchar (80) specifies a data type that can store any string up to 80 characters in length. Int is ordinary.

  2022-06-01 17:46:34 Views: 250
• 

  The method of complete uninstall of Oracle11 under windows

  Oracle11 complete uninstall method 1. Uninstall oracle before oracle11G will uninstall uncleanly, resulting in the failure of installation again. Open the service and stop all services of Oracle when running services.msc. II. Oracle

  2022-06-01 17:46:33 Views: 244
• 

  Oracle11G_PL/SQL

  PL/SQL: corresponding to T-SQL in SQL Server, which means the combination of process language and incoming call query language, supports multiple data types and is an extension of SQL. Execution process: the client sends the PL/SQL program block to the server, first by the PL/SQL engine

  2022-06-01 17:46:33 Views: 209
• 

  Set oracle Boot self-boot

  ORACLE setup self-boot instructions: generally speaking, the windows platform oracle server will start automatically, but linux will not, including monitoring, database, console emctl needs to be set available: method 1: use OS services: orat

  2022-06-01 17:46:33 Views: 227
• 

  Practical Network Monitoring Zabbix (1)-- remote Monitoring Host Service

  1. About Zabbix Zabbix is a highly integrated network monitoring solution that can provide enterprise-level open source distributed monitoring solutions. Updates are continuously maintained by a foreign team, the software can be downloaded and used freely, and the operation team makes a profit by providing technical support for a fee. Official

  2022-06-01 17:46:32 Views: 250
• 

  Technical or management

  Time cost: if you devote more time to one thing, you are bound to invest less time in another. As a manager, you have to spend more time on other things and less time on technology. Moreover, managers, if they want to bring their subordinates well, they need to be willing to take the blame for their subordinates. When there is a problem

  2022-06-01 17:46:29 Views: 239
• 

  Mongodb execution Plan description

  Create documents:for (iTuno: I < 1000000) {db.users.insert ({"I": I, "username": "user" + I, "age": Math.floor (Math)

  2022-06-01 17:46:01 Views: 243
• 

  The whole process of RMAN off-machine recovery

  At the beginning, the DBNAME of the source database and the target database are the same, and the archiving mode is enabled. The database version is oracle 11.2.0.4.01. Find the database that was backed up yesterday and all the archive logs after the backup on the source database, and copy it to the target database. Restore the control file (due to the parameter

  2022-06-01 17:46:01 Views: 275
• 

  Php service cache acceleration

  PHP service accelerates cache optimization PHP cache principle: when a client requests a PHP program, the server's PHP engine parses the PHP program and compiles it into a specific opcode (Operate Code referred to as opcode). The modified file executes the PHP generation.

  2022-06-01 17:45:55 Views: 260
• 

  Database setup failed to configure the server

  Another statement I saw on a BLOG: the cause of the problem: this problem belongs to sql server's bug, and GetComputerName is used to get the local computer name. The client network library component (DBMSLPCn.dll) sets the name

  2022-06-01 17:45:51 Views: 281
• 

  Spring4.3.7 integrates mongodb3.2.1

  A few days ago, I wrote a mongodb native tool class, refer to "http://ylcodes01.blog.51cto.com/5607366/1933342"," the project needs to be distributed, so now it is integrated into spring, and it ends today.

  2022-06-01 17:45:51 Views: 218
• 

  MS SQL splits commas and retrieves fields

  Create table curtest (djbh varchar (20) primary key,sales varchar (20)) goinsert curtestselect 'A1Jun Jian 01

  2022-06-01 17:45:45 Views: 288
• 

  Monitor the abnormal mirror status of SQL Server database and send alarm email

  Monitor SQL Server database abnormal mirroring status alarm email after database mirroring is deployed, we need to monitor the status of the master database and mirror database participating in mirroring, and send an alarm email if the status is abnormal. Then this script needs to be run on both the primary and mirror servers. Catalogue

  2022-06-01 17:45:42 Views: 258
• 

  Practice of mongodb installation and configuration

  First of all, download the mongodb installation package http://www.mongodb.org/downloads from the official website. My system is redhat5.8. All choose the corresponding version package for ok. Now the latest version is 3.0.3 and decompress mongodb-li.

  2022-06-01 17:45:38 Views: 262
• 

  I forgot my root password for MySQL. What should I do?

  When we install MySQL, the default root user does not have a password to log in to MySQL. What should we do when we set the password for the root user and forget the password when we log in again? Local root password reset: problem-solving ideas: 1. Modify the master configuration

  2022-06-01 17:45:18 Views: 284
• 

  Create the original database-create data, create tables

  Books: principles and Design of Database system (3rd Edition)-- Universal selection Liao Guoqiong and other editors task driven: because they can not find the original database, they have to create the database from scratch, design database diagrams, and input data. prepare the data for the further study of the database. Database version: SQL S

  2022-06-01 17:45:14 Views: 207
• 

  Avoid the tricky operation of replacing logical SQL by MySQL

  The difference between replace into and insert into on duplicate key the usage of replace is equivalent to insert when there is no conflict, and the default values of other columns are updated automatically when key conflicts, and replace conflicting columns

  2022-06-01 17:45:11 Views: 279
• 

  Django connection data mysql

  [background] system centos6.xpython version 3.4.3django 1.9.x the default database used by django is sqlite3, and what we commonly use is mysql. We need to connect to mysql and we need django at this time.

  2022-06-01 17:44:56 Views: 242
• 

  SQLserver full, differential, Log backup and restore commands

  All-sql-about_bak_restore (1): # full backup backup database record to disk ='E:\ backup\ record.bak' with retai

  2022-06-01 17:44:47 Views: 286
• 

  Oracle11g ORACLE not available

  After making something for my roommate with Oracle, I closed the database directly with shutdown abort, sent him the file created under the tablespace, then dropped the original file, and then reconnected to Oracle. First of all, log in s.

  2022-06-01 17:44:46 Views: 202