Vrundesha Joshi has Published 289 Articles

Where are iOS simulator screenshots stored?

Vrundesha Joshi

Vrundesha Joshi

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

2K+ Views

The screenshots taken on an simulator are stored usually on desktop of the system that you are using.There are multiple scenarios in which screenshots could have been taken, some of them are mentioned below.When the images are taken using "Command" + S, or from File menu's New Screenshot option, They ... Read More

8085 Assembly language program to find largest number in an array

Vrundesha Joshi

Vrundesha Joshi

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

3K+ Views

In this program we will see how to find the largest number from a block of bytes using 8085.Problem StatementWrite 8085 Assembly language program to find the largest number from a block of bytes.DiscussionIn this program the data are stored at location 8001H onwards. The 8000H is containing the size ... Read More

How to set background for Navigation Bar in iOS?

Vrundesha Joshi

Vrundesha Joshi

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

1K+ Views

To set the background color for a navigation bar we can either do it programmatically or through the storyboard if it is on storyboard.Method 1Let's see how to change the background color of a navigation bar through the storyboard editor.Create a new project, select it's view controller and embed in ... Read More

What is the equivalent of Java long in the context of MySQL variables?

Vrundesha Joshi

Vrundesha Joshi

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

3K+ Views

The equivalent of Java long in the context of MySQL variables is BigInt.In Java, the long datatype takes 8 bytes while BigInt also takes the same number of bytes.Demo of Java longHere is the demo of Java long −public class JavaLongDemo { public static void main(String[]args) { ... Read More

Select records from MySQL NOW() -1 Day?

Vrundesha Joshi

Vrundesha Joshi

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

2K+ Views

To get records from NOW()-1 Day, you can use the following syntax −select *from yourTableName where yourColumnName >=now()-interval 1 day;To understand the above syntax, let us first create a table. The query to create a table.mysql> create table GetRecordsFromNow −> ( −> YourDateTime datetime ... Read More

Check if a user exists in MySQL and drop it?

Vrundesha Joshi

Vrundesha Joshi

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

2K+ Views

To check how many users are present in MySQL, use MySQL.user table. The syntax is as follows to check how many users are present.mysql> SELECT User FROM mysql.user;The following output displays the users −+------------------+ | User | +------------------+ ... Read More

Compare DATE string with string from MySQL DATETIME field?

Vrundesha Joshi

Vrundesha Joshi

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

1K+ Views

You can compare DATE string with string from DATETIME field with the help of DATE() function in MySQL.The syntax is as follows −select *from yourTableName where DATE(yourColumnName) = ’anyDateString’;To understand the above syntax, let us create a table and set some datetime values in the table. The query to create ... Read More

Get the fields in each constraint in MySQL

Vrundesha Joshi

Vrundesha Joshi

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

103 Views

Let’s say we have a database “business” with number of tables. If you want to Get the fields in each constraint, then use the below query.The below query is to get the fields in each one of those constraints −mysql> select * −> from information_schema.key_column_usage −> where constraint_schema = 'business';The ... Read More

How to select domain name from email address in MySQL?

Vrundesha Joshi

Vrundesha Joshi

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

5K+ Views

To select domain name from email address, you can use in-built SUBSTRING_INDEX() function from MySQL.To understand the concept, let us create a table. The following is the query to create a table.mysql> create table selectDomainNameOnly −> ( −> UserEmailAddress varchar(200) −> ... Read More

Getting last 5 character of a string with MySQL query?

Vrundesha Joshi

Vrundesha Joshi

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

20K+ Views

To get the first n characters of string with MySQL, use LEFT(). To get the last n char of string, the RIGHT() method is used in MySQL.The syntax for RIGHT() method is as follows −SELECT RIGHT(yourColumnName, valueOfN) as anyVariableName from yourTableName;To understand the above concept, let us create a table. ... Read More

Advertisements