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 by Chandu yadav
Page 39 of 81
Priority of AND and OR operator in MySQL select query?
The AND has the highest priority than the OR operator in MySQL select query.Let us check how MySQL gives the highest priority to AND operator.The query is as followsmysql> select 0 AND 0 OR 1 as Result;The following is the output+--------+ | Result | +--------+ | 1 | +--------+ 1 row in set (0.00 sec)If you are considering the OR operator has the highest priority then MySQL will wrap up the above query like this.The query is as followsselect 0 AND (0 OR 1) as ResultFirst, solve the 0 OR 1, this will give result 1. After that ...
Read MoreDefining internet of things iot for businesses
In today’s world, the biggest technology trend is the ‘Internet of Things (IoT);’ and true enough it is defining our lives, the way we work; shaping and influencing businesses, and governments too. It is the ‘next big thing’ or is simply being termed as a revolution/progression of the web, and is being touted as far bigger than anyone has been able to fathom in technology, where machine to machine and man to machine interaction is moving towards new heights.GuesstimatesIt is estimated that by 2020 there will be around 26 billion devices (as per the firm Gartner) that will be connected ...
Read MoreHow do I add Vibrate and sound for Notification in Android?
This example demonstrate about How do I add Vibrate and sound for Notification 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. Step 3 − Add the following code to src/MainActivity.javapackage app.tutorialspoint.com.notifyme; import android.app.NotificationManager; import android.content.Context; import android.media.RingtoneManager; import android.net.Uri; import android.support.v4.app.NotificationCompat; import android.support.v7.app.AppCompatActivity; import android.os.Bundle; import android.view.View; import android.widget.Button; import java.util.Objects; public class MainActivity extends AppCompatActivity { private final static String default_notification_channel_id = "default" ; @Override protected ...
Read MoreGet only digits using regexp in MySQL?
If you want to get only digits using REGEXP, use the following regular expression( ^[0-9]*$) in where clause.Case 1 − If you want only those rows which have exactly 10 digits and all must be only digit, use the below regular expression.SELECT *FROM yourTableName WHERE yourColumnName REGEXP '^[0-9]{10}$';Case 2 − If you want only those rows with the digit either 1 or more, the following is the syntax −SELECT *FROM yourTableName WHERE yourColumnName REGEXP '^[0-9]*$';The above syntax will give only those rows that do not have any any characters.To understand the above syntax, let us create a table. The query ...
Read MoreSystem variables vs Local Variables in MySQL?
The local variable has the scope for only a set of statements or block of statement. Whenever a set of statements or block of statement has completed then local variable goes out of scope.For ExampleLocal variable can be used in stored procedure, function etc. It is used with the DECLARE keyword.The syntax is as follows to local variables.DECLARE yourVariableName dataType;The global variables or system variables has the scope across connections until server restart. It is set using GLOBAL keyword. The syntax is as follows −SET GLOBAL max_connections=value; OR SET @@global.max_connections=value;If you know port number then you can use system variable ...
Read MoreDigital Integrated Circuits
A microprocessor is digital is a digital circuit which is built using a combination logic functions. The microprocessor package contains an integrated circuit.Integrated CircuitAn integrated circuit is electronic circuit or device that has electronic components on a small semiconductor chip. It has functionality of logic AND or amplifying of a signal. These are mainly two types of circuits: Digital or Analog. Analog ICs handle continuous signals such as audio signals and Digital ICs handle discrete signals such as binary values.Types of Integrated CircuitsThere are different types of integrated circuits based various criteria. Based on intended application, the Integrated Circuit (IC) ...
Read MoreRead and write AIFF and AIFC files using Python (aifc)
Various functions in aifc module provide support for reading and writing AIFF (Audio Interchange File Format) and AIFF-C files. AIFF format is for storing digital audio samples in a file. Its newer version AIFF-C has the ability to compress the audio dataAudio file has number of parameters describing the audio data.The sampling rate or frame rate: number of times per second the sound is sampled.The number of channels: indicate if the audio is mono, stereo, or quadro.frame : consists of one sample per channel.The sample size: size in bytes of each sample.Thus a frame consists of channels * samplesize bytes. ...
Read MoreLocating and executing Python modules (runpy)
The –m option of command line option searches for a given module and execute it as the __main__ module. This mechanism is internally supported by runpy module from Python's standard module that allows scripts to be located using the Python module namespace rather than the filesystem.This module defines two functionsrun_module()This function executes the code of the specified module and return the resulting module globals dictionary.The mod_name argument should be an absolute module name. If the module name refers to a package rather than a normal module, then that package is imported and the __main__ submodule within that package is then ...
Read MoreChange date format (in DB or output) to dd/mm/yyyy in PHP MySQL?
You can change the date format in PHP using date() fucntion. The syntax is as follows −date(d/m/Y, yourDateTimeVariable);In PHP, convert string to date using strtodate(). Here is the PHP code used to format the datetime −$LogintDate = strtotime('2019-01-12'); echo date('d/m/Y', $LogintDate);The snapshot of code is as follows −The following is the output −12/01/2019You can achieve in MySQL with the help of date_format() function. The syntax is as follows −SELECT DATE_FORMAT(yourColumnName, ’%d/%m/%Y’) as anyVariableName FROM yourTableName;To understand the above syntax, let us create a table −mysql> create table Date_FormatDemo -> ( -> Id int NOT NULL AUTO_INCREMENT, -> ...
Read MoreHow to map keys to values for an individual field in a MySQL select query?
You can use CASE statement in MySQL to map keys to values for an individual field in select query. The syntax is as follows −SELECT yourColumnName1, yourColumnName2, yourColumnName3, .........N ( CASE WHEN yourColumnName = 1 THEN 'ENABLED' ELSE 'DISABLED' END ) AS anyVariableName FROM yourTableName;You can use IF() function also for the same purpose. The syntax is as follows −SELECT yourColumnName1, yourColumnName2, yourColumnName3, .........N ,IF(yourColumnName, 'ENABLED', 'DISABLED') as anyVariableName FROM yourTableName;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table MapKeys -> ( ...
Read More