Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
Well, if you are looking to learn a programming language for your career growth and advancement there are many programming languages out there. There are hundreds of programming languages on the web which can be learned online itself. There is no particular programming language which will help you in your career growth.Programming languages are dynamic in nature and one has to adopt any new technology by learning new programming languages. Of course, there are some popular programming languages which will help you in terms of career growth.SQLSQL(Structured Programming Language) is a popular programming language in the present scenario.It has been ... Read More
You can increment a database using update command. The syntax is as follows −UPDATE yourTableName set yourColumnName=yourColumnName+1 where condition;To understand the above syntax, let us first create a table. The query to create a table is as follows −mysql> create table IncrementBy1 -> ( -> Id int, -> Name varchar(100), -> CounterLogin int -> ); Query OK, 0 rows affected (0.63 sec)Insert some records using insert command. The query to insert records in the table is as follows −mysql> insert into IncrementBy1 values(100, 'John', 30); Query OK, 1 row affected (0.17 sec) mysql> insert ... Read More
To detect swipe in scrollView we will need to make use of some tricks as scroll view does not natively give the directions of scroll made on it. We’ll see this with help of an example.Create an empty project, add scroll view to the view as per your requirement.Give them constraint as required in the application.From the object library, drag and drop a swipe gesture recognizer right above the Scroll View.Select the gesture recognizer, go to its attribute inspector and from there, select the swipe option and set the value as “up”.When you do this, now your gesture recognizer can ... Read More
To populate a table from query results, use the following syntax:INSERT yourTableName(yourColumnName1, yourColumnName2, yourColumnName3, ..........N) SELECT yourColumnName1, yourColumnName2, yourColumnName3, ..........N FROM yourAnotherTableName;To understand the above syntax, let us create a table. The first table is as follows with some records. The query to create a table is as follows:mysql> create table PopulateTableDemo -> ( -> Id int NOT NULL AUTO_INCREMENT, -> Name varchar(20), -> Amount int, -> ArrivalDateTime datetime, -> PRIMARY KEY(Id) -> ); Query OK, 0 rows affected (0.68 sec)Now you can insert some records in the table using insert command. The ... Read More
Microsoft Office provides you with a feature of encrypting or protecting your powerpoint presentations from opening and modifying by other people. Even if you allow others to change your document, still you can restrict the changes others can do to your document.The only hitch is Microsoft cannot retrieve your forgotten passwords. So be careful with your passwords.The encryption offered by Microsoft is very strong. In a word document, you need not to change the encryption length unless you have a specific reason to alter the settings. Microsoft uses AES with a 128bit key, plus SHA1 salt and cipher block chaining ... Read More
Airwave is an OTA (Over-The-Air) antenna. Unlike cable TV, this is a wireless antenna that offers you with all the stuff that a normal cable TV used to offer such as local news, daily soaps, prime-time shows, sports etc. with crystal clear HD quality. This is the first OTA antenna that works with the help of your Wi-fi network.Mohu AirwaveMohu is the maker of Mohu Sky, which has launched Mohu Airwave in the last year’s International Consumer Electronics Show. The Airwave is an OTA antenna which can be placed anywhere in the house and provides optimal signal reception that makes ... Read More
In this program we will see how to add a blocks of data using 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to add numbers in an array, where the size of the array is N. The value of N is provided.DiscussionIn this problem we are using location 8000H to hold the length of the block. The main block is stored from address 8010H. We are storing the result at location 9000H and 9001H. The 9000H holding the lower byte, and 9001H is holding the upper byte.Repeatedly we are taking the number from the memory, then adding it with accumulator and ... Read More
To change MySQL default character set to UTF-8 in my.cnf, firstly reach the location of my.cnf file.The following is the screenshot of “my.cnf” file. Firstly, open the C: directory and the “Program Data” folder −Now, click on “MySQL” folder −Now, click the MySQL Server 8.0 folder and open it −After opening MySQL Server 8.0, you will get “my.cnf” file location.After opening my.cnf file, you will get the character-set. Open the file and the following contens are visible −Now you can change the character-set to utf8.
For this, you can insert using MySQL dual table. Let us create a table to understand the concept conditional insert. The query to create a table is as follows −mysql> create table ConditionalInsertDemo -> ( -> UserId int, -> TotalUser int, -> NumberOfItems int -> ); Query OK, 0 rows affected (0.58 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into ConditionalInsertDemo values(101, 560, 780); Query OK, 1 row affected (0.19 sec) mysql> insert into ConditionalInsertDemo values(102, 660, 890); Query OK, 1 row affected (0.20 sec) ... Read More
The fishes that can survive without water for a good amount of time are known as amphibious fishes. Convergent evolution plays an important role in these species, as the next generation species receives analogous structures that have similar function but were not present in the last generation.Many fishes are amphibious, which means they can naturally survive out of the water. These fishes have developed limbs or use lateral undulation (that is, wave-like movement patterns that act to propel an animal forward) for terrestrial locomotion. They leave water bodies for many reasons like escaping predators, low oxygen environments etc.Ancient fish had ... Read More