NAV: SLTechnology News&Howtos > Database >

• 

  Insert, update, and delete data tables using T-SQL statements

  When managing data, using SSMS for data maintenance has the advantages of visualization and convenience, but in batch maintenance or repeated maintenance, it is not convenient to use SSMS, and it is easy to make mistakes, so it is necessary to write SQL statements to maintain the database SQL and T-SQLSQL is Str.

  2022-06-01 10:42:54 Views: 268
• 

  MySQL database permission operation

  Operation object: online and test all MySQL Plus database creation users: create user 'testname'@'%' identified by' 123456users; view the permissions of the testname user show

  2022-06-01 10:42:54 Views: 287
• 

  Basic operation of Mongodb-basic installation and multi-instance operation

  NoSQL introduces NoSQL (NoSQL = Not Only SQL), which means "not just SQL". In modern computing systems, a huge amount of data is generated on the network every day. A large part of this data is generated by the relational database management system (RDBM).

  2022-06-01 10:42:53 Views: 262
• 

  How to back up and restore data in Redis RDB mode

  How to back up and restore data in Redis RDB mode? 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 data backup instance 127.0.

  2022-06-01 10:42:53 Views: 259
• 

  SQLServer data column

  CREATE PROCEDURE [dbo]. [dxd_mx] @ dxd_id VARCHAR =''ASBEGIN--set nocount ondeclare @ sql1 nVARCHAR (

  2022-06-01 10:42:53 Views: 255
• 

  An example Analysis of the problem of MySQL automatic shutdown

  This article mainly explains the example analysis of the problem of MySQL automatic downtime, the content is clear, interested friends can learn, I believe it will be helpful after reading. Recently, I did a project for someone else. MySQL always stops running on the machine after a while. Just opened

  2022-06-01 10:42:53 Views: 298
• 

  [NoSQL] abandon VIP and use consul and sentinel to build a highly available system for redis

  Background: 1. The traditional redis high availability solution only adds sentinel. After the failure of the main library, you can select the master and then switch the read-only parameters, but for the application, you need to change the connected IP or change the resolution in the hosts. It's kind of semi-automatic. two。 Using cons

  2022-06-01 10:42:37 Views: 285
• 

  Mysql grouping by expression or function, grouping multiple fields, sorting

  Group by expression or function: # case: group by the length of employee's name, query the number of employees in each group, filter the number of employees greater than five SELECT COUNT (*), LENGTH (last_name) FROM employeesG

  2022-06-01 10:42:34 Views: 292
• 

  Talking about the basic types of Partition Table in MySQL

  Editor to share with you this time is to talk about the basic types of partition tables in MySQL, the article is rich in content, interested friends can learn about it, I hope you can get something after reading this article. An overview of MySQL partition tables as MySQL becomes more and more popular, Mysql

  2022-06-01 10:42:34 Views: 245
• 

  Detailed explanation of MySQL Partition Table

  What the editor wants to share with you this time is to explain the MySQL partition table in detail. The article is rich in content. Interested friends can learn about it. I hope you can get something after reading this article. Preface in the recent project, we need to save a lot of data, and these data are valid.

  2022-06-01 10:42:34 Views: 233
• 

  MySQL: performance optimization-index, statement, configuration (based on 5.7)

  Xiaosheng blog: http://xsboke.blog.51cto.com------- thank you for your reference, if in doubt, welcome to communicate 1, the type of database 1) the first generation database: the hierarchical database based on hierarchical model and mesh model is more classic.

  2022-06-01 10:42:04 Views: 217
• 

  The SQL Server server name does not match the default instance name

  Use master go select @ @ servername,serverproperty ('servername')-

  2022-06-01 10:42:03 Views: 276
• 

  Inexplicable downtime of oracle on RHEL 7 ORA-27300

  Phenomenon: oracle executes job:expdp, and the database instance goes down directly. The error is as follows: ORA-27300: OS system dependent operation:semctl failed with sta

  2022-06-01 10:42:03 Views: 221
• 

  Import and export of MySQL data (for personal learning and review)

  This example will practice the import and export operation of MySQL: import the / etc/passwd file into the userdb library user table and number each record to export the first 10 records in the userdb library user table with UID less than 100. save as / mydata/

  2022-06-01 10:42:03 Views: 246
• 

  Alter user identified by values in 11g

  First, the requirement is to migrate some data to the new database, and the developer requires it to be consistent with the original database password. It is troublesome and error-prone for us to collect passwords one by one. What should we do at this time? The alter user statement of Oracle provides an identifie

  2022-06-01 10:42:03 Views: 275
• 

  Application of Media Capital data Storage in EonStor GS Grand Theater

  A grand theatre, which covers an area of more than 270000 square meters in the ancient capital Nanjing, shows a strong artistic concept with its unique dripping architectural style. Show the audience all kinds of opera, music, dance, drama, opera and other performance activities, and successively held a number of brilliant performances by the world's top artists.

  2022-06-01 10:41:51 Views: 213
• 

  The Story of Index and data Integrity

  It is said that the database also has important metrics, so performance and security are absolutely two important parts, where performance refers to the speed of processing and responding to client services, and security is the data integrity rules. Why use an index? We know that when we use select to query the contents of a table, or

  2022-06-01 10:41:40 Views: 254
• 

  Centos7 mysql installation

  -- force-- nodeps forcefully ignores dependencies to query whether there is a mysql:rpm-qa | if grep-I mysql shows that it is installed, delete it: sudo yum-y remove mysql-libs* has been deleted

  2022-06-01 10:41:40 Views: 266
• 

  BLOB save file

  1. Insert the text INSERT INTO lobdemo (key, clob_col, blob_col, bfile_col) VALUES (51, 'This is another c) into the blob field

  2022-06-01 10:41:39 Views: 232
• 

  A detailed explanation of the use of self-summarized redis

  As an example, redis is an in-memory database, a simple key-value structure, and a nosql database. Because the structure is simple and memory is used, the speed is very fast. As for the question, how fast? As we all know, the speed of the previous mechanical hard disk is actually quite good.

  2022-06-01 10:41:36 Views: 241