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
What is the best iOS app for education?
Apps have become an integral part of our daily lives. We depend on our iPhones more than our computers. There are many education apps that can improve your language, memory, and many skills in different categories. Let us look at such apps.DuolingoElevateLumosityTEDPeakCourseraMath 42UdemyCreative CloudCodecademy
Read MoreHow to select yesterday's date in MySQL?
To select yesterday’s date, use the subdate() function from MySQL. The syntax is as followsselect subdate(yourDatetimeColumnName) as anyVariableName from yourTableName;To understand the above syntax, let us create a tablemysql> create table YesterdayDateDemo -> ( -> VisitedDateTime datetime -> ); Query OK, 0 rows affected (0.59 sec)Let us now insert date in the table using insert command. The query is as followsmysql> insert into YesterdayDateDemo values(now()); Query OK, 1 row affected (0.15 sec) mysql> insert into YesterdayDateDemo values('2012-12-26 13:24:35'); Query OK, 1 row affected (0.17 sec) mysql> insert into YesterdayDateDemo values('2013-10-22 12:20:32'); Query OK, 1 row affected (0.16 sec)Let ...
Read MoreHow to open and close a PDF file using Swift?
In this article we’ll see how to open a pdf file using swift in iOS. Here we’ll do it with an example of opening pdf in webView in iOS. Let’s create a project and add WKWebView to the storyboard.Connect it’s outlet to the ViewController class.Now we’ll see two different thingsOpening a PDF file from a URL on the web.To open a web view from a url, first we need to have a url with a pdf file. In this example I’ll be using a dummy URL https://www.w3.org/WAI/ER/tests/xhtml/testfiles/resources/pdf/dummy.pdfLet’s create a URL first, let url: URL! = URL(string: "https://www.w3.org/WAI/ER/tests/xhtml/testfiles/resources/pdf/dummy.pdf")Now the remaining steps ...
Read MoreEquivalent of SQL Server IDENTITY Column in MySQL?
Equivalent of Microsoft SQL Server IDENTITY column in MySQL is AUTO_INCREMENT. The IDENTITY in SQL Server acts like AUTO_INCREMENT in MySQL.The syntax is as follows −CREATE TABLE yourTableName ( yourColumnName1 dataType NOT NULL AUTO_INCREMENT, yourColumnName2 dataType, . . . N, PRIMARY KEY(yourColumnName1) );In MySQL, you need to use primary key if your column is auto_increment otherwise MySQL will give an error. Look at the error −mysql> create table EquivalentOfIdentityInMySQL -> ( -> ProductId int NOT NULL AUTO_INCREMENT, -> ProductName varchar(30) -> ); ERROR 1075 (42000) − Incorrect table definition; ...
Read MoreIn the future, will it be possible for robots to develop feelings?
Robotics is the fast emerging technology today. Robots are being designed to be used for various activities from daily domestic chores to military operations. These Robots are designed based on the idea of Artificial Intelligence.What is Artificial Intelligence?A machine is initially developed to take instructions from the user and process it according to a pre-designed program and give the output. Whereas if this machine can do something more extraordinary, other than simply taking the instructions and matching with previously fed data, that would be great. Such a thought is the basis for Artificial Intelligence. This can be understood as the ...
Read MoreWhat is the data type for unix_timestamp in MySQL?
The best data type for unix_timestamp in MySQL is integer. The integer data type is as followsint(11);The integer data type is useful for condition checking like ( > , create table UnixTime -> ( -> DueTime datetime -> ); Query OK, 0 rows affected (0.55 sec)Insert records in the form of date using insert command. The query is as followsmysql> insert into UnixTime values(now()); Query OK, 1 row affected (0.15 sec) mysql> insert into UnixTime values('2010-10-14'); Query OK, 1 row affected (0.15 sec) mysql> insert into UnixTime values('2020-09-24'); Query ...
Read MoreCheck if a string contains numbers in MySQL?
To check a string contains numbers, you can use regexp i.e. Regular Expressions. The syntax is as follows −SELECT *FROM yourTableName where yourColumnName REGEXP ‘[0-9]’;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table StringContainsNumber -> ( -> Id int not null auto_increment, -> Words text, -> primary key(Id) -> ); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into StringContainsNumber(Words) values('He12345llo'); Query OK, 1 row affected (0.19 sec) ...
Read MoreWhat is a Deemed University?
Deemed university is the other name of Deemed-to-be-University, which is an accreditation of a university awarded to higher educational institutions in India by the Department of Higher education. So basically, any university which is ‘deemed to be a university’ by the UGC under Section 3 of the UGC Act of 1956, is called a deemed university.What is a Deemed University?The main feature of Deemed University is Autonomous Control. In a deemed college or university, the management has complete control over anything and everything ranging from the student curriculum to Examinations and issues related to administration and management.The setting of the ...
Read MoreHow to programmatically add a UISegmentedControl to a container view?
To add a UISegmentControl in iOS with swift we’ll have to first create a segment control and it’s controller function, i.e. it’s action. Let’s see those steps.Let’s create a function to add a segmented control.func addControl() { let segmentItems = ["First", "Second"] let control = UISegmentedControl(items: segmentItems) control.frame = CGRect(x: 10, y: 250, width: (self.view.frame.width - 20), height: 50) control.addTarget(self, action: #selector(segmentControl(_:)), for: .valueChanged) control.selectedSegmentIndex = 1 view.addSubview(control) }This function may be called in our view controller to add the segmented control, let’s add action for ...
Read MoreUse boolean value to stop a thread in Java
A thread can be created by implementing the Runnable interface and overriding the run() method. Then a Thread object can be created and the start() method called.A thread can be stopped using a boolean value in Java. The thread runs while the boolean value stop is false and it stops running when the boolean value stop becomes true.A program that demonstrates this is given as follows:Exampleclass ThreadDemo extends Thread { public boolean stop = false; int i = 1; public void run() { while (!stop) { try { ...
Read More