MySQL – Handling Duplicates
Generally, tables or result sets sometimes contain duplicate records. Most of the times it is allowed but sometimes it is required to stop duplicate records. It is required to identify…
Generally, tables or result sets sometimes contain duplicate records. Most of the times it is allowed but sometimes it is required to stop duplicate records. It is required to identify…
OBIEE components are mainly divided into two types of components − Server ComponentsClient Components Server components are responsible to run OBIEE system and client components interact with user to create…
Memcached stats command is used to return server statistics such as PID, version, connections, etc. Syntax The basic syntax of Memcached stats command is as shown below − stats Example stats STAT pid 1162…
A sequence is a set of integers 1, 2, 3, ... that are generated in order on a specific demand. Sequences are frequently used in the databases because many applications…
Memcached incr and decr commands are used to increment or decrement the numeric value of an existing key. If the key is not found, then it returns NOT_FOUND. If the key is not numeric, then…
Obtaining and Using MySQL Metadata There are three types of information, which you would like to have from MySQL. Information about the result of queries − This includes the number of…
OBIEE stands for Oracle Business Intelligence Enterprise Edition, a set of Business Intelligence tools and is provided by Oracle Corporation. It enables the user to deliver robust set of reporting, ad-hoc…
Memcached delete command is used to delete an existing key from the Memcached server. Syntax The basic syntax of Memcached delete command is as shown below − delete key If the key is successfully…
Memcached delete command is used to delete an existing key from the Memcached server. Syntax The basic syntax of Memcached delete command is as shown below − delete key [noreply] Output CAS command may…
Schema is a logical description of the entire database. It includes the name and description of records of all types including all associated data-items and aggregates. Much like a database,…