NAV: SLTechnology News&Howtos > Database >

• 

  Transaction and stored procedure

  1. Transaction management * (1) concept: a transaction refers to a logical set of operations that make up the units of this set of operations, either successful or unsuccessful. (2) MySQL comes with its own transaction by default, but the transaction that comes with MySQL is a statement that monopolizes a transaction. (3) it can also be its own.

  2022-06-01 08:49:21 Views: 251
• 

  Get all database names, table names, and field names

  -- get all database names select name from master..sysdatabases where name = 'Fly'-- get all table names select name from Fly..

  2022-06-01 08:49:20 Views: 298
• 

  [enterprise Framework Integration] Springmvc+mybatis+restful+bootstrap Framework Integration

  1. Use Alibaba Druid connection pool (efficient, powerful and scalable database connection pool, monitor database access performance, support Common-Logging, Log4j and JdkLog, monitor database access) 2. Provide highly concurrent JMS messages

  2022-06-01 08:49:19 Views: 307
• 

  An example of QT accessing QSqlite database

  The QtSql module provides an interface to access the SQL database independent of the platform and database type, which is supported by a set of classes that integrate the database and the user interface using the model view structure of Qt. The QSqlDatabase object symbolizes the association of the database. Qt uses drivers

  2022-06-01 08:49:19 Views: 271
• 

  Redis client operation command

  1. Command exists (key) for value operation: confirm whether a key exists del (key): delete a keytype (key): return the type of value keys (pattern): return all ke that satisfy a given ke

  2022-06-01 08:49:18 Views: 221
• 

  MongoDB aggregate aggregation

  Aggregate is equivalent to group in mysql and a series of operation official website introduction address: http://docs.mongodb.org/manual/reference/sql-aggregation-

  2022-06-01 08:49:18 Views: 209
• 

  Oracle sort operation

  SQL statement with the largest number of queries sorted: WITH sql_workarea AS (SELECT sql_id | |'_'| | child_number sql_id_child,operation_type o

  2022-06-01 08:49:17 Views: 229
• 

  MongoDB Notes Nine-Index

  Manufacturing data for (var iTuno name I < 20 000 switch I +) {db.persons.insert ({number:i,name:i+ "name"})} / / it takes about 100 seconds to insert. 1. Check that there is no cable.

  2022-06-01 08:49:17 Views: 222
• 

  Compile and install Mysql5.5 database software

  Preparation environment: Centos6.5 (6 series operating system) [root@localhost ~] # yum-y install gcc gcc-c++ ncurses-devel libxml2-devel zl

  2022-06-01 08:49:16 Views: 240
• 

  Basic use of database

  1. Log in and log out of the mysql server: mysql-h hostname-u username-p password-e "sql command" example 1:mysql-uroot-p123456 # root user, password 123456 login to the database. Example 2Rom

  2022-06-01 08:49:16 Views: 232
• 

  The problem of time conversion in oracle

  Http://www.cnblogs.com/hanyun/archive/2009/05/14/1456772.html1). When using Oracle's to_date function for date conversion, you may intuitively use "

  2022-06-01 08:49:16 Views: 291
• 

  Text search tool: grep egrep fgrep

  The grep name comes from g/re/p (globally search a regular expression and print, global lookup and printing in regular notation) and is a command line originally used for the Unix operating system

  2022-06-01 08:49:01 Views: 290
• 

  Mysql memory is constantly occupied, resulting in an automatic restart every other month. After modifying the database configuration, the problem is solved.

  At the beginning of this month, through zabbix monitoring, it was found that the remaining memory space of one mysql database was decreasing. Examining the previous monitoring history chart, it is found that due to the increasing memory footprint, every other month, there will be a serious shortage of memory, resulting in 1 mysql of this server.

  2022-06-01 08:48:54 Views: 286
• 

  Basic additions, deletions, changes, queries and table structure of the database

  Basic database additions, deletions, modifications, queries 1, add-add / insert data insert into insert which table, those columns, what values, statements: insert into table name (column 1, column 2, column 3) values (value 1, value 2, value 3); you can not follow the sequence of the original column

  2022-06-01 08:48:54 Views: 269
• 

  Rman configuration DataGuard using Backup-based duplication with a target connection with filesystem

  Environment hostname, database version, dbnamedb_unique_nameIP address, system version, Jason1 (primary) oracle11204Jasonjason1192.168.1.99rhel6.6_x86_64ja

  2022-06-01 08:48:54 Views: 301
• 

  Spring mvc configuration + dbcp data source + jdbcTemplate

  Recently, I intend to study spring carefully, starting with spring mvc, which has been used for 2 years. Beginners can take a look at it. The great god will be fine with pass, hehe. First, go to the spring official website to download the complete spring package, including libs, docs and s

  2022-06-01 08:48:51 Views: 269
• 

  Oracle RAC Study-- Cache Fusion

  Oracle RAC Study-- Cache FusionConcept of cache fusionCache Fusion basically is about fusing the mem

  2022-06-01 08:48:50 Views: 297
• 

  Linux command: the ninth of MySQL series-- MySQL isolation level and setting

  The SQL standard defines four types of isolation levels, including specific rules that define which changes inside and outside the transaction are visible and which are not. Low-level isolation levels generally support higher concurrent processing and have lower system overhead. Read Uncommitted (read

  2022-06-01 08:48:24 Views: 267
• 

  Backup and restore of InnoDB Storage engine based on xtrabackup

  In the InnoDB storage engine, xtrabackup can be carried out completely in the form of hot backup, realize fast and reliable full backup and partial backup, support incremental backup, support point-in-time restore, do not disturb the transaction operation in the backup process, compress function effectively save disk space, and backup is finished.

  2022-06-01 08:48:21 Views: 213
• 

  Oracle related web sites

  [1] my support https://support.oracle.com/epmos/faces/MosIndex.jspx?_afrLoop=772106189111605&_afrWind

  2022-06-01 08:48:21 Views: 278