Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
To fetch only the month part, use DATE_FORMAT().Let us first create a table −mysql> create table DemoTable753 (DueDate datetime); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert command −mysql> insert into DemoTable753 values('2019-06-21'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable753 values('2019-01-31'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable753 values('2018-12-01'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable753 values('2016-11-11'); Query OK, 1 row affected (0.23 sec)Display all records from the table using select statement −mysql> select *from DemoTable753;This will produce the following output -+---------------------+ ... Read More
To implement IN() for custom ordering, use ORDER BY CASE.Let us first create a table −mysql> create table DemoTable752 ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(100) ); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable752(Name) values('John'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable752(Name) values('Carol'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable752(Name) values('Bob'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable752(Name) values('Mike'); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable752(Name) values('Sam'); ... Read More
For this, you can use GROUP BY HAVING clause.Let us first create a table −mysql> create table DemoTable751 ( StudentName varchar(100), SubjectName varchar(100) ); Query OK, 0 rows affected (0.66 sec)Insert some records in the table using insert command −mysql> insert into DemoTable751 values('John', 'MySQL'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable751 values('John', 'MongoDB'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable751 values('Sam', 'MySQL'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable751 values('Carol', 'Java'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable751 values('David', 'MySQL'); ... Read More
Let’s say some of the columns values in a table has a specific keyword and you want only those records. For this, use the LIKE operator.Let us first see an example and create a table −mysql> create table DemoTable750 (Title varchar(200)); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable750 values('Java and MongoDB, MySQL'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable750 values('MySQL, SQL Server'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable750 values('PL/SQL, Python, MongoDB'); Query OK, 1 row affected (0.14 sec) mysql> ... Read More
To list logged-in MySQL users, you can use any of the following two methods −First MethodUse INFORMATION_SCHEMA.PROCESSLISTselect *from INFORMATION_SCHEMA.PROCESSLIST;Second MethodYou can use SHOW PROCESSLIST command as well. Following is the syntax −SHOW PROCESSLIST;Let us implement the above syntaxes in order to list logged in MySQL users −mysql> select *from information_schema.processlist;This will produce the following output -+----+-----------------+-----------------+------+---------+--------+-----------------------------+---------------------------------------------+ | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO ... Read More
For this, you can use custom IF() and set a value whenever 0 appears.Let us first create a table −mysql> create table DemoTable749 (Value int); Query OK, 0 rows affected (1.02 sec)Insert some records in the table using insert command −mysql> insert into DemoTable749 values(10); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable749 values(0); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable749 values(769); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable749 values(0); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable749 values(78); Query OK, 1 row affected (0.14 sec) ... Read More
To extract only the day instead of the entire date, you need to use DAYOFMONTH() function from MySQL.Let us first create a table −mysql> create table DemoTable747 (DueDate datetime); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command −mysql> insert into DemoTable747 values('2019-01-31') ; Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable747 values('2018-12-01'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable747 values('2017-09-14'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable747 values('2016-07-21'); Query OK, 1 row affected (0.14 sec)Display all records from the table using select ... Read More
This example demonstrates how do I show current location on a google map on Android.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. Step 3 – Add the following dependency in the build.gradle (Module: app)implementation 'com.google.android.gms:play-services-maps:17.0.0' implementation 'com.google.android.gms:play-services-location:17.0.0'Step 4 − Add the following code to src/MainActivity.javaimport android.Manifest; import android.content.pm.PackageManager; import android.location.Location; import android.os.Bundle; import android.widget.Toast; import com.google.android.gms.maps.CameraUpdateFactory; import com.google.android.gms.maps.SupportMapFragment; import com.google.android.gms.location.FusedLocationProviderClient; import com.google.android.gms.location.LocationServices; import com.google.android.gms.maps.GoogleMap; import com.google.android.gms.maps.OnMapReadyCallback; import com.google.android.gms.maps.model.LatLng; import com.google.android.gms.maps.model.MarkerOptions; import com.google.android.gms.tasks.OnSuccessListener; import com.google.android.gms.tasks.Task; import androidx.annotation.NonNull; import androidx.core.app.ActivityCompat; ... Read More
We can create a notifier for the events that occurred in Windows using Python. This is very simple with the win10toast module. If you are familiar with the Toast in Android then understanding the Toast notifications with Python is a piece of cake. We can generate notifications whenever an event occurs as a remainder. Let's see.Run the following command in command-line to install win10toast modulepip install win10toastIf the module successfully installed then, you will get the following result when you run the command.Collecting win10toast Downloading https://files.pythonhosted.org/packages/d4/ba/95c0ea87d9bcad68b90d8cb130a313b939c88d8338a2fed7c11eaee972fe/win10toast-0.9-py2.py3-none-any.whl Collecting pypiwin32 (from win10toast) Downloading https://files.pythonhosted.org/packages/d0/1b/2f292bbd742e369a100c91faa0483172cd91a1a422a6692055ac920946c5/pypiwin32-223-py3-none-any.whl Requirement already satisfied: setuptools in c:\users\hafeezulkareem\anaconda3\lib\site-packages (from win10toast) ... Read More
Carrier Ethernet is an application of Ethernet technology that allows network providers to offer Ethernet services to their customers and to use Ethernet technology. It enables Internet access and communication among local area networks (LANs) of business, academic, private and government organizations.The services and standards of carrier Ethernet have been defined by the Metro Ethernet Forum (MEF). MEF has also developed certification programs and it promotes the global adoption of carrier Ethernet.Carrier Ethernet versus EthernetThe primary attributes of Carrier Ethernet that differentiates it from Ethernet are −A carrier Ethernet network provides service to many organizations, while an Ethernet LAN renders ... Read More