Adglob Infosystem Pvt Ltd

SQLite – UNION Clause

Post author:S J
Post published:August 17, 2021
Post category:SQLite
Post comments:0 Comments

SQLite UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows. To use UNION, each SELECT must have the same number of columns…

Redis – Keys Persist Command

Post author:K Z
Post published:August 17, 2021
Post category:Redis
Post comments:0 Comments

Redis PERSIST command is used to remove the expiration from the key. Return Value Integer value 1 or 0 1, if timeout is removed from the key.0, if the key does not…

SQLite – JOINS

Post author:S J
Post published:August 17, 2021
Post category:SQLite
Post comments:0 Comments

SQLite Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to…

SQLite – Constraints

Post author:S J
Post published:August 17, 2021
Post category:SQLite
Post comments:0 Comments

Constraints are the rules enforced on a data columns on table. These are used to limit the type of data that can go into a table. This ensures the accuracy…

SQLite – PRAGMA

Post author:S J
Post published:August 17, 2021
Post category:SQLite
Post comments:0 Comments

SQLite PRAGMA command is a special command to be used to control various environmental variables and state flags within the SQLite environment. A PRAGMA value can be read and it can also…

Redis – Keys Move Command

Post author:K Z
Post published:August 17, 2021
Post category:Redis
Post comments:1 Comment

Redis MOVE command is used to move a key from the currently selected database to the specified destination database. Return Value Integer value 1 or 0 1, if the key is moved.0,…

Redis – Keys Command

Post author:K Z
Post published:August 17, 2021
Post category:Redis
Post comments:0 Comments

Redis KEYS command is used to search keys with a matching pattern. Return Value List of keys with a matching pattern (Array). Syntax Following is the basic syntax of Redis KEYS command. redis 127.0.0.1:6379>…

Redis – Keys Pexpireat Command

Post author:K Z
Post published:August 17, 2021
Post category:Redis
Post comments:0 Comments

Redis Pexpireat command is used to set expiry of key in unix timestamp specified in milliseconds. After the expiry time key will not be available in redis. Return Value Integer value 1…

Redis – Keys Pexpire Command

Post author:K Z
Post published:August 17, 2021
Post category:Redis
Post comments:0 Comments

Redis Pexpire command is used to set the expiry of the key in milliseconds. After the expiry time, the key will not be available in Redis. Return Value Integer value 1 or…

Redis – Keys Expireat Command

Post author:K Z
Post published:August 17, 2021
Post category:Redis
Post comments:1 Comment

Redis Expireat command is used to set the expiry of key in Unix timestamp format. After the expiry time, the key will not be available in Redis. Return Value Integer value 1…