Rishi Rathor has Published 142 Articles

8085 program to generate Fibonacci sequence

Rishi Rathor

Rishi Rathor

Updated on 30-Jul-2019 22:30:24

7K+ Views

In this program we will see how to generate Fibonacci sequence.Problem StatementWrite 8085 Assembly language program to generate the first ten elements of the Fibonacci sequence using registers only and store them in memory locations 8050H to 8059H. DiscussionThis program will generate the Fibonacci numbers. The Fibonacci numbers follows this relation ... Read More

What is difference between UITableViewController and UIViewController?

Rishi Rathor

Rishi Rathor

Updated on 30-Jul-2019 22:30:24

603 Views

UItableViewController and UIViewController are two different objects of iOS UIKit framework. Both are used for different purpose.A UIViewController class manages a ViewContoller which is responsible for actions that happen within that View controller. This class is aware of actions that happen on view controller, like ViewDidLoad, ViewWillApper, ViewDidAppear, ViewWillDisapper, ViewDidDisapper.Whereas, ... Read More

8085 Program to perform sorting using bubble sort

Rishi Rathor

Rishi Rathor

Updated on 30-Jul-2019 22:30:24

721 Views

In this program we will see how to sort a block of bytes using bubble sorting technique.Problem StatementWrite8085 Assembly language program to sort numbers in ascending order where n number of numbers are stored in consecutive memory locations starting from 8041H and the value of n is available in memory ... Read More

How to insert new cell into UITableView using Swift?

Rishi Rathor

Rishi Rathor

Updated on 30-Jul-2019 22:30:24

1K+ Views

To insert a new cell into UITableView we'll first have to create a table view cell and then add it to the table view using Cell for row at method of Table view.We can create a cell using Storyboard or by creating a nib of class UITableViewCell.In the View controller ... Read More

How to change the column position of MySQL table without losing column data?

Rishi Rathor

Rishi Rathor

Updated on 30-Jul-2019 22:30:24

11K+ Views

You can change the column position of MySQL table without losing data with the help of ALTER TABLE command. The syntax is as follows −ALTER TABLE yourTableName MODIFY yourColumnName1 data type AFTER yourColumnName2;To understand the above concept, let us create a table. The query to create a table with some ... Read More

Update column size in MySQL and increase its size?

Rishi Rathor

Rishi Rathor

Updated on 30-Jul-2019 22:30:24

390 Views

To update the column size, you can use alter command. The syntax is as follows −alter table yourTableName change yourColumnName yourColumnName data type;To understand the above syntax, let us create a table. The query to create a table −mysql> create table DataTruncated −> ( ... Read More

Do a select in MySQL based only on month and year?

Rishi Rathor

Rishi Rathor

Updated on 30-Jul-2019 22:30:24

2K+ Views

To select MySQL based on month and year, use in-built function YEAR() and MONTH(). The syntax is as follows −select *from yourTableName where YEAR(yourColumnName) = YearValue AND MONTH(yourColumnName) = monthValue;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create ... Read More

Get the difference between two timestamps in seconds in MySQL?

Rishi Rathor

Rishi Rathor

Updated on 30-Jul-2019 22:30:24

933 Views

To get difference between two timestamps in seconds, use two in-built functions TIME_TO_SEC() and TIMEDIFF() in MySQL. The syntax is as follows −select time_to_sec(timediff(yourCoulnName1, yourCoulnName2)) as anyVariableName from yourTableName;To understand the above concept, let us first create a table. The query to create a table.mysql> create table TimeToSecond ... Read More

Set column charset in MySQL?

Rishi Rathor

Rishi Rathor

Updated on 30-Jul-2019 22:30:24

530 Views

Set column charset using character SET command. The syntax is as follows −ALTER TABLE yourTableName MODIFY youColumName type CHARACTER SET anyCharcaterSetName;You can use character set name utf8 or something elsE. To set column charset, let us first create a table. The query to create a table is as follows −mysql> ... Read More

Display all tables inside a MySQL database using Java?

Rishi Rathor

Rishi Rathor

Updated on 30-Jul-2019 22:30:24

1K+ Views

We will see here how to display all tables inside a MySQL database using Java. You can use show command from MySQL to get all tables inside a MySQL database.Let’s say our database is ‘test’. The Java code is as follows to show all table names inside a database ‘test’.The ... Read More

Advertisements