Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
Neptune is the coldest planet in the solar system as Pluto has been excluded as it was regarded as a dwarf planet. It is the eighth and farthest known planet from the Sun. It has 17 times the mass of Earth and is the fourth largest planet in the solar system. It takes 164.8 years for Neptune to finish one revolution around the sun and the elliptical orbit of Neptune is inclined 1.77° compared to that of Earth.Voyager 2 is the only spacecraft that visited Neptune. It analyzed Neptune's rotation, tilt, weather conditions and also its moons and ring systems.Physical ... Read More
There are two types of Input Output ports. They are Programmable Input Output ports and Non-Programmable Input Output ports. Since the functions of Programmable Input Output ports changed by software they became more popular. We don't need to change the wiring rather the hardware of the I/O port to change the function. Intel 8255 is a popular Input Output chip based on port. Whereas the I/O ports which are non-programmable needs to change the wiring or the hardware to change its complete function. We will see in later that the connection needs to be changed when 8212 works like an ... Read More
Commodity trading is trading in derivatives and commodity spot. There are two different categories of commodities we have to trade: Agricultural commodities and non-agricultural commoditiesAgricultural Commodities: These include grains and oilseeds (soybean, chana, corn, groundnut etc.), livestock, dairy products, bio-fuels etc.Non-Agricultural Commodities: These include Metals like gold, silver, copper etc.Also, there are 24 commodity exchanges in India and three national level commodity exchanges to trade in all permitted commodities.They are Multi Commodity Exchange of India Ltd, Mumbai (MCX), National Multi Commodity Exchange of India Ltd, Ahmedabad (NMCE) and National Commodity and Derivative Exchange, Mumbai (NCDEX)How Does It Work?When you buy ... Read More
You can use phpMyAdmin, since it is one of the best free tools. This can be used for every system with PHP and MySQL. It is a free and open source administration tool for MySQL and MariaDB. PHPMYADMINHere is the URL to download −https://www.phpmyadmin.net/downloads/The following are the features of phpMyAdmin −Open source toolMySQL and MariaDB database management.One of the most popular MySQL administration toolsEasily Import data from CSV and SQLExport data to various formats. These include : CSV, SQL, XML, PDF, Word, Excel, LaTeX, etc.Administering multiple serversYou can also use EMMA. This is also a light-weight application.Read More
To get the first 40 characters from a text field, use LEFT() function from MySQL. The syntax is as follows −SELECT LEFT(yourColumnName, 40) as anyVariableName from yourTableName;To understand the above concept, let us create a table. The query to create a table is as follows −mysql> create table retrieveFirst40Characters −> ( −> AllWords text −> ); Query OK, 0 rows affected (0.59 sec)Now you can insert some record in the table with the help of insert command. The query is as follows −mysql> insert into retrieveFirst40Characters values('This is a query demo ... 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 N 1-byte numbers. 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 increase the register E content when carry flag is ... Read More
To add a submit button at the end of a table view, we can make use of table view footers. Let’s see this with help of an example where we’ll add a footer view to our table, and inside the table, we will add code for adding button at the bottom of the table view.Create a new project first, then inside the view controller add the following code which will initialize the table, add a section and a few rows to the table.func initTableView() { let tableView = UITableView() tableView.frame = self.view.frame tableView.dataSource = self tableView.delegate ... Read More
To cut only the first character, use the substr() function with UPDATE command. The syntax is as follows.UPDATE yourTableName set yourColumnName=substr(yourColumnName, 2);To understand the above syntax, let us first create a table. The query to create a table is as follows.mysql> create table CutStringDemo -> ( -> Value varchar(100) -> ); Query OK, 0 rows affected (0.66 sec)Now you can insert some records in the table using insert command. The query is as follows.mysql> insert into CutStringDemo values(', 12, 3456'); Query OK, 1 row affected (0.14 sec) mysql> insert into CutStringDemo values(', 23, 9867'); Query OK, 1 row affected ... Read More
A rocket can be an aircraft, spacecraft or a missile which is propelled by a rocket engine. A rocket engine works on the principle of Newton's Third law, that is, for every action, there is an equivalent and opposite reaction. Rocket propellant is the fuel which burns and produces thrust to propel the rocket.The propellants are usually fueled together with the oxidants. Oxidants are required to burn the fuel efficiently. Thus the chemical reaction in the combustion chamber produces the required energy for thrust.The propellant is burnt in a controlled manner in the combustion chamber of the rocket engine and ... Read More
Zaveri Bazaar is the oldest gold market in India and objects made of silver like napkin rings, picture frames in old silver can be bought from this market. Zaveri Bazaar, as the name suggests, is a jewellery market, to the north of Crawford Market.LocationIt is located close to Chhatrapati Shivaji Terminus and there are a number of trains that stop at this station. One can easily reach Zaveri Bazaar by boarding a local bus from the railway station or by an auto-rickshaw.Big brands such as 'Tanishq' and 'Tribhovandas Bhimji Zaveri' can be found here but here there are no shopping ... Read More