To return record set order, you need to use FIND_IN_SET(). Let us first create a table −mysql> create table recordSetOrderDemo    -> (    -> EmployeeId int,    -> EmployeeName varchar(30)    -> ); Query OK, 0 rows affected (0.63 sec)Following is the query to insert some records in the ... Read More

To set blank spaces in column names with MySQL, you can use the concept of backticks. Let us first create a table. Following is the query −mysql> create table blankSpacesDemo    -> (    -> `Student Id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> `Student Full Name` varchar(100)   ... Read More

In order to check the current configuration of MongoDB, you can use getCmdLineOpts. The query is as follows −> db._adminCommand( {getCmdLineOpts: 1});The following is the output −{ "argv" : [ "mongod" ], "parsed" : { }, "ok" : 1 }In order to check live settings, you can use the below ... Read More

To view the auto_increment value for a table, you can use INFORMATION_SCHEMA.TABLES.Let us first create a table −mysql> create table viewtheauto_incrementValueForATableDemo    -> (    -> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> StudentName varchar(20)    -> ); Query OK, 0 rows affected (0.84 sec)Following is the query ... Read More

This example demonstrate about How to use contains () in Android text view.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml.       ... Read More

Before getting into example, we should know what sqlite data base in android is. SQLite is an open source SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation. SQLite supports all the relational database features. In order to ... Read More

This example demonstrate about How to use Sorted set interface in AndroidStep 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml.         ... Read More

PyMongo is a Python distribution containing tools for working with MongoDB. To perform regex queries with PyMongo, the syntax is as follows −db.yourCollectionName.find({'yourCollectionName':{'$regex':'^yourWords'}}).pretty();The above syntax will give all those documents that start from a specific word.To understand the syntax, let us create a collection with the document. The query to ... Read More

To compare two strings, which are numbers, let us first create a table. Following is the query −mysql> create table compareTwoStringsDemo    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> Value varchar(100)    -> ); Query OK, 0 rows affected (0.52 sec)Following is the query ... Read More

This example demonstrate about How to use compareTo () in Android textview.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml.         ... Read More