Vrundesha Joshi has Published 289 Articles

Working of the 8257 DMA controller

Vrundesha Joshi

Vrundesha Joshi

Updated on 29-Jun-2020 12:56:38

2K+ Views

Initially the processor programs 8257. Here the processor behaves as the master and 8257 here works in the slave mode. The channel of the program is obtained by writing to the Address Register from the starting address of memory for transferring Data, and writing to the Counter Register where the ... Read More

Can we use LIKE and OR together in MySql?

Vrundesha Joshi

Vrundesha Joshi

Updated on 29-Jun-2020 11:17:03

18K+ Views

You can use LIKE with OR operator which works same as IN operator.Let us see the syntax for both the cases −Case 1 − Using Like with OR operator.select *from yourTableName where yourColumnName Like ‘Value1’ or yourColumnName Like ‘Value2’ or yourColumnName Like ‘Value3’ . . . NCase 2 − Using ... Read More

int(5) vs. int(10) in MySQL?

Vrundesha Joshi

Vrundesha Joshi

Updated on 29-Jun-2020 09:11:10

2K+ Views

The value in the parentheses is used to display only the width and sets the zerofill. The width is 5 for int(5), whereas 10 for int(10). Let us see another example with a different width value set for int.Let us first create a table. Here, we have set the int ... Read More

How to subtract 3 hours from a datetime in MySQL?

Vrundesha Joshi

Vrundesha Joshi

Updated on 29-Jun-2020 07:53:22

4K+ Views

Subtract 3 hours from DateTime in MySQL, using any of the following ways. The first approach is as follows −Case 1 − Using DATE_ADD()select date_add(yourColumnName, interval -3 hours) from yourTableName;Case 2 − Using DATE_SUB()select date_sub(yourColumnName, interval 3 hours) from yourTableName;Firstly, use now() to get the current date-time −mysql> select now();The ... Read More

Maintaining order in MySQL “IN” query?

Vrundesha Joshi

Vrundesha Joshi

Updated on 29-Jun-2020 07:42:46

743 Views

You can maintain the order in MySQL IN query with the help of field command. The syntax is as follows −select *from yourTableName anyVariableName where anyVariableName.yourColumnName in(value1, value2, ......N) order by field(anyVariableName.yourColumnName, value1, value2, ......N);To implement the above syntax let us create a table −mysql> create table OrderInDemo    −> ... Read More

How to change Table Engine in MySQL?

Vrundesha Joshi

Vrundesha Joshi

Updated on 29-Jun-2020 07:37:52

383 Views

You can change table engine with the help of alter command. The syntax is as follows −alter table yourTableName ENGINE = yourEngineName;To understand the above syntax let us create a table with engine MyISAM. Later you can change any other engine. The following is the query to create a table.mysql> ... Read More

MySQL command for display current configuration variables?

Vrundesha Joshi

Vrundesha Joshi

Updated on 29-Jun-2020 07:26:17

249 Views

You can use SHOW VARIABLES command to display current configuration variables. The syntax is as follows −SHOW VARIABLES;If you want any specific information, then implement the LIKE operator. The syntax is as follows −SHOW VARIABLES LIKE ‘%AnySpecificInformation%’;Now we will implement the above syntax −mysql> show variables like '%variable%';The following is ... Read More

How to add a day to datetime field in MySQL query?

Vrundesha Joshi

Vrundesha Joshi

Updated on 29-Jun-2020 07:18:12

274 Views

To add a day to datetime field, use the DATE_ADD() function. The syntax is as follows −SELECT DATE_ADD(yourColumnName, interval yourIntegerValue day) as anyVariableName from yourTableName;Let us first create a table −mysql> create table AddOneDayDemo −> (    −> YourDay datetime −> ); Query OK, 0 rows affected (1.37 sec)Insert current ... Read More

Rotate In Up Left Animation Effect with CSS

Vrundesha Joshi

Vrundesha Joshi

Updated on 29-Jun-2020 07:17:22

87 Views

To create a rotate in up left animation effect with CSS, you can try to run the following code −ExampleLive Demo                    .animated {             background-image: url(/css/images/logo.png);             background-repeat: no-repeat;   ... Read More

How to store custom objects in NSUserDefaults?

Vrundesha Joshi

Vrundesha Joshi

Updated on 27-Jun-2020 13:44:37

630 Views

In this article we’ll learn how to store custom objects in our application, but before you learn how to store custom object let’s see what are custom object?A custom object is any class or structure or any other data that is not a native data type like Int, Double, String ... Read More

Advertisements