NAV: SLTechnology News&Howtos > Database >

• 

  Postgresql service deployment

  PostgreSQL is a very complex object-relational database management system (ORDBMS), and it is also the most powerful, rich and complex free software database system at present. Os:centos6.5 x64ip:192.168.85

  2022-06-01 13:02:02 Views: 203
• 

  Shopnc framework database query limit of 30 records

  Shopnc framework database query method: Model ()-> table ("table name")-> select (); if the data in your table is greater than 30, only 30 items will be displayed in the results you find. The solution is: if the limit method, that is, Mo, is used in the query statement

  2022-06-01 13:01:51 Views: 232
• 

  Experimental process of database data recovery

  When entering the database operation, there will inevitably be some misoperations. At this point, we need to recover the data. Here is a description of how to delete the contents of the table and restore the process. First of all, let's simulate the experimental environment: after installing the database, go to / etc/my.cnf to see if

  2022-06-01 13:01:51 Views: 224
• 

  Safely delete database users

  SET SERVEROUT ONCREATE OR REPLACE PROCEDURE gracefullyDropUser (v_username IN VARCHAR2) ISl_cnt integ

  2022-06-01 13:01:50 Views: 280
• 

  Oracle digital function

  Numeric function 1, take the entire function (ceil rounded up, floor rounded down) select ceil (66.6) N2 from dual;2, take the power (power) and find the square root (sq)

  2022-06-01 13:01:50 Views: 239
• 

  Oracle IMP Import error IMP-00003: ORACLE error 2298

  A project: the database needs to be migrated from the old server to the new server. When importing imp exported data from exp into exp export backup, you encounter the following error prompt: IMP-00017: following statement failed with OR

  2022-06-01 13:01:50 Views: 261
• 

  The basis of mysql (2) commonly used SQL statements

  SQL statement type: DDL: database definition language create,drop,alter DML: data manipulation language insert,delete,update,select

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

  Mysql Partition and Sub-Table (2)

  Mysql partition table (2) Test non-partition table and partition table performance re-create new test database and non-partition table back1 create partition table back2, according to the year-to-month distinction maxvalue put all the values for 2005 in the p11 area to create larger data (convenient for testing

  2022-06-01 13:01:27 Views: 247
• 

  ORA-00845 Raised When Starting Instance (document ID465048.1)

  ORA-00845 Raised When Starting Instance (document ID465048.1) APPLIESTO:OracleDatabase-Enterprise Edition

  2022-06-01 13:01:24 Views: 285
• 

  OGG Operation and maintenance Optimization script (16)-Information synchronization Class-additional Log check

  Filename checktrandata.sh path $HOME/ggscript/ggtrandata the purpose of this script is to verify the additional days of the tables configured in the EXTRACT process through the infotrandata directive included with ogg

  2022-06-01 13:01:24 Views: 251
• 

  Pgpool Concise use tutorial

  System Environment 172.16.3.226 (master) 172.16.3.228 (slave) 172.16.3.229 (pgpool) # yum install-y gcc-c++ zlib-devel

  2022-06-01 13:01:24 Views: 253
• 

  PostgreSQL-- the Secret of sequence and self-increasing id

  1. The essence of self-increasing id serial1.2 and serial of PostgreSQL when creating tables, we often need to use self-increasing id, which is often written like this, create table test (id serial, # make

  2022-06-01 13:01:24 Views: 289
• 

  The mysql service restarts when mysql imports a very large sql file

  When a sql file of more than 100g is imported, it will be broken automatically in more than an hour, and an error is reported: in the mysql lost connection during query log, mysql is found to have traces of restart, looking for Guantian cron and so on.

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

  Solution and steps for Oracle client unable to connect to server

  The client cannot connect to the server database due to problems such as network, configuration, file access, and whether the database service has been started. The general troubleshooting steps are as follows: 1. Check that the operating system level network is unobstructed ping 192.168.10.12. Check the database layer network

  2022-06-01 13:01:20 Views: 239
• 

  SQL Server Technical discussion Special QQ Group

  Highly recommended SQL Server technology discussion special QQ group QQ group number: 213291913 Note: this QQ group is limited to AC SQL Server technology, please do not pour water, otherwise directly kick people. After joining the group, please change the group nickname to your real name, which is convenient for you.

  2022-06-01 13:01:20 Views: 299
• 

  View Oracle automatic optimization recommendations

  After Oracle has been running for a period of time, the system will automatically give some tuning suggestions, which are placed in the dba_advisor_actions view. The main fields of the view are as follows: task_name-- optimization task name execution_name-- implementation

  2022-06-01 13:01:20 Views: 276
• 

  Snapshot and baseline of oracle

  1. View the current AWR save policy select * from dba_hist_wr_control;DBID,SNAP_INTERVAL,RETENTION,TOPNSQL860524039,+00 01

  2022-06-01 13:01:19 Views: 206
• 

  SQL Server- focuses on UNIOL ALL/UNION query

  First of all, let's go over the basic concepts and usage of UNION and UNION ALL. UNION and UNION ALL are JOIN of two or more tables. Of course, the data type of the table must be the same. For UNION, it removes duplicate values, and

  2022-06-01 13:00:48 Views: 300
• 

  Password file of Oracle and remote SYSDBA login

  The password file (password file) is an optional file that allows remote SYSDBA or administrators to access the database. When you start Oracle, there is no database available to validate passwords. When you start Oracle on the local system, Oracle takes advantage of the operation

  2022-06-01 13:00:40 Views: 290
• 

  Backup and restore of Cacti data

  one。 Backup 1. Export the database file and execute the following command: mysqldump-ucactiuser-pcactipw cacti > mysql123.sql means: mysqldump directory-u user-p password

  2022-06-01 13:00:40 Views: 282