Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Get all the records with two different values in another column with MySQL
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 MoreSelect records from a table on the basis of keywords in MySQL
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 MoreList logged-in MySQL users?
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 MoreUpdate all the zero values with a custom value in MySQL with a function similar to ISNULL()
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 MoreMySQL query to extract only the day instead of entire date
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 MoreHow to show current location on a google map on Android?
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 MoreHow to create Picker programmatically from array in iOS?
A picker view displays one or more wheels that the user manipulates to select items. Each wheel—known as a component—has a series of indexed rows representing the selectable items.UIPicker is one of the important components and almost used in most of the applications. You’ll see them mostly in form-based applications.You can read more about it here: https://developer.apple.com/documentation/uikit/uipickerviewIn this post, we will be seeing how to create UIPicker programmatically from and array and load array values into it.So let’s get started, Step 1 − Open Xcode and create a single view application and name it PickerSample.Step 2 − Open ViewController.swift, Since ...
Read MoreHow to dismiss the Alert with click on outside of the alert in iOS?
Understanding and implementing UIAlert can be tricky especially if you’re new to iOS Development, In this post, we will be seeing how we can dismiss the alert when the user taps outside the alert box.For this demo, we will be using UIAlert class, to configure alerts and action sheets with the message that you want to display and the actions from which to choose. After configuring the alert controller with the actions and style you want, present it using the present(_:animated: completion:) method. UIKit displays alerts and action sheets modally over your app's content.You can read more about it: https://developer.apple.com/documentation/uikit/uialertcontrollerSo ...
Read MoreHow to change screen brightness programmatically in iOS?
To change the brightness of the screen we have to use the brightness property of the screen, This property is only supported on the main screen. The value of this property should be a number between 0.0 and 1.0, inclusive.Brightness changes made by an app remain in effect until the device is locked, regardless of whether the app is closed. The system brightness (which the user can set in Settings or Control Center) is restored the next time the display is turned on.It’s an instance property, To implement this in your iOS Application (any application) add below line in viewDidLoad ...
Read MoreHow can I change the text color of the Navigation Bar on iOS?
Changing the text color of the navigation bar is tricky and easy at the same time, In this post, we will be seeing how one can change the text color of navigation bar in swift.So let’s get started, Embed your view controller in Navigation controller as shown below and name navigation item for that particular controller as a tutorial as shown, Now navigate to AppDelegate.swift and add below lines in didFinisheLaunchingWithOptions method.func application(_ application: UIApplication, didFinishLaunchingWithOptions launchOptions: [UIApplication.LaunchOptionsKey: Any]?) -> Bool { // Override point for customization after application launch. let textColor = [NSAttributedString.Key.foregroundColor:UIColor.green] UINavigationBar.appearance().titleTextAttributes = textColor ...
Read More