NAV: SLTechnology News&Howtos > Database >

• 

  The creation of tables in SQL server Database and the manipulation of data tables using T-SQL statements

  The creation of tables and the use of T-SQL statements one, table creation and basic concepts A table is a database object that contains all the data in the database, and the table definition is a collection. Data is grouped in the table

  2022-06-01 12:42:49 Views: 232
• 

  Hbase configuration and installation

  HBase configuration installation hbase0.98.5 is installed on the rhel6.2 system using hadoop2.2.0. Download hbase-0.98.5-hadoop2-bin.tar.gz and upload it to the server and use the command to extract [roo]

  2022-06-01 12:42:48 Views: 273
• 

  Proficient in SQL structured query-Learning Notes 3

  For the sorting of Chinese characters, it is sorted in the order of the first letter. There is a price to pay for using DISTINCT; because to remove duplicate values, the result relationship must be sorted, and the same tuples are arranged together. Only by grouping tuples in this way can duplicate values be removed.

  2022-06-01 12:42:39 Views: 215
• 

  What is the default port number of redis?

  What is the default port number for redis? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something. Redis is an open source program written in ANSI C

  2022-06-01 12:42:39 Views: 265
• 

  Share a script EXP that backs up ORACLE to local disk under LINUX, and keep it for 7 days

  Please do not put the backup script under backup_dir, add it to crontab and run #! / bin/shexport ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 regularly.

  2022-06-01 12:42:38 Views: 238
• 

  Sqlplus'! @ # /! As sysdba' can't understand it?

  Share today, spent a day in the bank today, can have a rest tomorrow, I wish you all a good weekend! If you see the following ways of writing, what will you think? What's the difference? Tell you that these writing methods can log in to the database by default. $sqlplus xxx/xxx

  2022-06-01 12:42:38 Views: 205
• 

  DotConnect for Oracle getting started Guide (6): using transactions

  [download the latest version of dotConnect for Oracle] dotConnect for Oracle (formerly known as OraDirect.NET) is based on ADO.NET technology and provides services for applications based on Oracle databases

  2022-06-01 12:42:38 Views: 296
• 

  Mysql5.7.17 installation configuration

  First, create a msql user # add a user running mysql, prohibit the user from logging in to the system [root@openstack-01 ~] # useradd mysql-s / sbin/ nology II, create a related directory # create a directory

  2022-06-01 12:42:38 Views: 229
• 

  This is how Fundebug backs up data.

  Summary: the data still needs to be backed up, what if the database is deleted? This article code warehouse: fundebug-mongodb-backup introduction in August this year, Tencent Cloud unexpectedly lost the customer's cutting-edge data. Fundebug carried out some simple technologies at the first time.

  2022-06-01 12:42:29 Views: 283
• 

  The implementation principle of InnoDB MVCC and the Analysis of Source Code

  1. Principle introduction: multi-version of data (MVCC) is one of the main ways for MySQL to achieve high performance. By not locking ordinary SELECT and directly using MVCC to read the value of finger version, it avoids the process of repeatedly locking data. InnoDB supports multiple MVCC.

  2022-06-01 12:42:25 Views: 277
• 

  Election of Redis Cluster Node (experiment)

  Election of Redis cluster nodes: when the master is dead, one of the slave in the cluster will be selected to replace the mater role, thus ensuring the integrity of the redis cluster slot. If one of the mster and its slave is dead, it will lead to

  2022-06-01 12:42:25 Views: 271
• 

  Sybase deployment

  Deployment environment: 32-bit SUSE10.2 linuex (IP address 192.168.117.120), ASE12.5.3 step 1. Create a service account groupadd sybaseuseradd-g sybase syb

  2022-06-01 12:42:10 Views: 231
• 

  How to connect the HTML web page to the database?

  This article shows you how to connect a HTML page to a database. The code is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something from the detailed introduction of this article. HTML cannot read the database. HTML is the front-end scripting language of the page.

  2022-06-01 12:41:44 Views: 232
• 

  Database external connection and MySQL implementation

  MySQL query is divided into inner join query and outer join query. The difference between them is that the two representations of inner join query are peer-to-peer, which are matched according to conditions; the outer join is mainly based on a certain table, and two tables are associated according to conditions. The outer connection is divided into left outer connection, right outer connection and full external connection. This article

  2022-06-01 12:41:44 Views: 277
• 

  MySQL Storage engine-Federated Best practice

  1. Background * the local MySQL database must access the data in the tables of the remote MySQL database through the FEDERATED storage engine. * somewhat similar to database links (DBLINK) in Oracle. To allow this storage engine

  2022-06-01 12:41:44 Views: 261
• 

  What is range ()? Why not produce iterators?

  What is range ()? Why not produce iterators? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem. Iterator is the most commonly used one of 23 design patterns (one)

  2022-06-01 12:41:43 Views: 227
• 

  Zabbix installation document 1

  1. Production environment: OS: CentOS release 6.8 (Final) Web server software: Apache/2.2.15 (Unix) PHP running environment: PHP 5.4.45 (cli) (built: a

  2022-06-01 12:41:43 Views: 300
• 

  Practice of informix onbar backup and recovery

  Description: host1 server as onbar backup test, host2 server as onbar recovery test. 1. Configure the backup parameter onmode-wf BAR_BSALIB_PATH=/home/informix/lib/li

  2022-06-01 12:41:43 Views: 249
• 

  A small example of JAVA database application

  Write it casually, with the hearth as the background, write a small example for reference, first put on the SQL table: if OBJECT_ID ('card_pool') is not nulldrop table card_pool;create tab

  2022-06-01 12:41:43 Views: 258
• 

  How many libraries are there in redis

  How many libraries are there in redis? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something. Redis is a dictionary-structured storage server, when in fact an R

  2022-06-01 12:41:43 Views: 266