SQLite – ALTER TABLE Command
SQLite ALTER TABLE command modifies an existing table without performing a full dump and reload of the data. You can rename a table using ALTER TABLE statement and additional columns can be…
Redis – Keys Rename Command
Redis RENAME command is used to change the name of a key. Return Value String reply OK or error. It returns an error if the old key and the new key names…
SQLite – INDEXED BY Clause
The "INDEXED BY index-name" clause specifies that the named index must be used in order to look up values on the preceding table. If index-name does not exist or cannot…
SQLite – Indexes
Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in…
Redis – Keys Random key Command
Redis RANDOMKEY command is used to get a random key from Redis database. Return Value String, a random key or nil, if the database is empty. Syntax Following is the basic syntax…
SQLite – Triggers
SQLite Triggers are database callback functions, which are automatically performed/invoked when a specified database event occurs. Following are the important points about SQLite triggers − SQLite trigger may be specified to fire…
Redis – Keys Ttl Command
Redis TTL command is used to get the remaining time of the key expiry in seconds. Return Value Integer value TTL in milliseconds, or a negative value. TTL in milliseconds.-1, if key…
SQLite – ALIAS Syntax
You can rename a table or a column temporarily by giving another name, which is known as ALIAS. The use of table aliases means to rename a table in a particular…
SQLite – NULL Values
SQLite NULL is the term used to represent a missing value. A NULL value in a table is a value in a field that appears to be blank. A field with a…
Redis – Keys Pttl Command
Redis PTTL command is used to get the remaining time of the key expiry in milliseconds. Return Value Integer value TTL in milliseconds, or a negative value. TTL in milliseconds.-1, if the…
- Go to the previous page
- 1
- …
- 624
- 625
- 626
- 627
- 628
- 629
- 630
- …
- 739
- Go to the next page