Mkotla has Published 77 Articles

Set a delay for the CSS transition effect

mkotla

mkotla

Updated on 24-Jun-2020 05:33:49

178 Views

Use the transition-delay property to set a delay for the transition effect with CSS. You can try to run the following code to set a 1-second delay of transition:ExampleLive Demo                    div {             width: 150px; ... Read More

Usage of CSS [attribute] Selector

mkotla

mkotla

Updated on 23-Jun-2020 15:03:03

303 Views

Use the [attribute] selector to select elements with an attribute, for example, an alt attribute or a target attribute, etc.You can try to run the following code to implement the CSS[attribute] selector,ExampleLive Demo                    img[alt] {             border: 3px solid orange;          }                              

How to write PHP script by using MySQL JOINS inside it to join two MySQL tables?

mkotla

mkotla

Updated on 22-Jun-2020 14:11:18

5K+ Views

We can use the syntax of MySQL JOIN for joining two tables into the PHP function – mysql_query(). This function is used to execute the SQL command and later another PHP function – mysql_fetch_array() can be used to fetch all the selected data.To illustrate it we are having the following ... Read More

C# Equivalent to Java Functional Interfaces

mkotla

mkotla

Updated on 22-Jun-2020 12:50:16

3K+ Views

Equivalent of Java’s Functional Interfaces in C# is Delegates.Let us see the implementation of functional interface in Java −Example@FunctionalInterface public interface MyInterface {    void invoke(); } public class Demo {    void method(){       MyInterface x = () -> MyFunc ();       x.invoke();    } ... Read More

How can we simulate the MySQL MINUS query?

mkotla

mkotla

Updated on 22-Jun-2020 12:47:50

675 Views

Since we cannot use the MINUS query in MySQL, we will use JOIN to simulate the MINUS query. It can be understood with the help of the following example −ExampleIn this example, we are two tables namely Student_detail and Student_info having the following data −mysql> Select * from Student_detail; +-----------+---------+------------+------------+ ... Read More

What kind of information is displayed by MySQL DESCRIBE statement?

mkotla

mkotla

Updated on 22-Jun-2020 08:26:00

120 Views

The DESCRIBE statement gives information about MySQL table’s structure.ExampleConsider the constructing of the following table name ‘Employee’ with Create Table statement as follows −mysql> Create table Employee(ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, Name Varchar(20)); Query OK, 0 rows affected (0.20 sec)Now with the help of ‘DESCRIBE Employee‘ statement, we ... Read More

How can we perform ROLLBACK transactions inside a MySQL stored procedure?

mkotla

mkotla

Updated on 22-Jun-2020 07:26:52

3K+ Views

As we know that ROLLBACK will revert any changes made to the database after the transaction has been started. To perform the ROLLBACK in MySQL stored procedure we must have to declare EXIT handler. We can use a handler for either sqlexception or SQL warnings. It can be understood with the help of ... Read More

How can we perform COMMIT transactions inside MySQL stored procedure?

mkotla

mkotla

Updated on 22-Jun-2020 07:02:12

920 Views

As we know the START transaction will start the transaction and COMMIT is used to made any changes made after starting the transaction. In the following example, we have created a stored procedure with COMMIT along with START transaction which will insert a new record and commit changes in table ... Read More

Add different styles to hyperlinks using CSS

mkotla

mkotla

Updated on 22-Jun-2020 06:00:28

336 Views

To set different styles to hyperlinks, such as font-size, background color, etc, you can try to run the following code:ExampleLive Demo                    a.first:link {color:#ff0000;}          a.first:visited {color:#0000ff;}          a.first:hover {color:#ffcc00;}         ... Read More

Role of CSS :nth-last-of-type(n) Selector

mkotla

mkotla

Updated on 21-Jun-2020 08:48:30

188 Views

Use the CSS :nth-last-of-type(n) selector to select every element that is the second element of its parent, counting from the last child.ExampleYou can try to run the following code to implement the :nth-last-of-type(n) selector:Live Demo                    p:nth-last-of-type(2) { ... Read More

Advertisements