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
List 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 MoreHow to get the dimensions of a view in iOS App?
Getting dimensions of a view is easy, In this post, we will see how one can get the dimensions of a view in iOS.Let’s get started, Step 1 − Open Xcode and create a single view application and name it SampleView.Step 2 − Open Main.storyboard and add UIView as shown below, Step 3 − Create @IBOutlet of the view in ViewController.swift.@IBOutlet var sampleView: UIView!Step 4 − In viewDidLoad of ViewController.swift write the following code, print(sampleView.frame.size)Run the application to see the size.Complete codeimport UIKit class ViewController: UIViewController { @IBOutlet var sampleView: UIView! override func viewDidLoad() { ...
Read MoreHow to create a WebView in an iOS App using Swift?
As an iOS developer, you will come across multiple scenarios where you have to display something in web, for that we use WebView.As per Apple, − It is an object that displays interactive web content, such as for an in-app browser.So in this post, we will be seeing how to create WebView and load the data in it.So let’s startStep 1 − Open Xcode and create a single view application and name it WebViewSample.Step 2 − Open ViewController.swift file and import the WebKit module. import WebKitStep 3 − Add a property of WebKit in ViewController.swift.var webView: WKWebView!Step 4 − Add ...
Read More