Sreemaha has Published 68 Articles

Execute a script when a file is ready to start playing in HTML?

Sreemaha

Sreemaha

Updated on 24-Jun-2020 11:49:44

146 Views

You can use the oncanplay attribute for the following attributes − , , and .Example                                        Your browser does not support the video element.                      alert("I am ready to begin.");          

CSS animation-play-state property

Sreemaha

Sreemaha

Updated on 24-Jun-2020 06:08:23

69 Views

Use the animation-play-state property to set whether the animation is running or paused.You can try to run the following code to implement the animation-play-state property:ExampleLive Demo                    div {             width: 150px;       ... Read More

How to specify the bottom position of 3D elements with CSS

Sreemaha

Sreemaha

Updated on 23-Jun-2020 16:24:15

230 Views

To specify the bottom position of 3D elements, use the perspective-origin property.You can try to run the following code to implement the perspective-origin property:ExampleLive Demo                     .demo1 {             position: relative;         ... Read More

How to write PHP script to update an existing MySQL table?

Sreemaha

Sreemaha

Updated on 22-Jun-2020 14:01:31

198 Views

We can use the SQL UPDATE command with or without the WHERE CLAUSE in the PHP function – mysql_query(). This function will execute the SQL command in a similar way it is executed at the mysql> prompt. To illustrate it we are having the following example −ExampleIn this example, we ... Read More

How can I get the records from MySQL table in result set in a particular way?

Sreemaha

Sreemaha

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

142 Views

For getting the records from MySQL table in the result set in a particular way either ascending or descending, we need to use the ORDER BY clause along with ASC or DESC keywords. If we will not use any of the above-mentioned keywords then MySQL by default return the records ... Read More

How to get last 2 characters from string in C# using Regex?

Sreemaha

Sreemaha

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

812 Views

Set the string −string str = "Cookie and Session";Use the following Regex to get the last 2 characters from string −Regex.Match(str, @"(.{2})\s*$")The following is the code −Example Live Demousing System; using System.Text.RegularExpressions; public class Demo {    public static void Main() {       string str = "Cookie and Session"; ... Read More

What is the use of WITH ROLLUP modifier in MySQL?

Sreemaha

Sreemaha

Updated on 22-Jun-2020 11:25:12

2K+ Views

“WITH ROLLUP” is a modifier that is used with GROUP BY clause. Mainly, it causes the summary output to include extra rows that represent higher-level summary operations.ExampleIn the example below, WITH ROLLUP modifier gave the summary output with total price value in the extra row.mysql> Select Item, SUM(Price) AS Price ... Read More

CSS overflow: scroll

Sreemaha

Sreemaha

Updated on 22-Jun-2020 08:59:58

417 Views

In the CSS overflow property with value scroll, the overflow is clipped and a scrollbar gets added. This allows the user to read the entire content.ExampleYou can try to run the following code to implement CSS overflow: scroll property −Live Demo                 ... Read More

How can we see the list, along with complete information, of stored functions in a particular MySQL database?

Sreemaha

Sreemaha

Updated on 22-Jun-2020 07:54:15

63 Views

We can mysql.proc to see the list, along with complete information, of stored functions in a particular MySQL database by the following query −mysql> Select * from mysql.proc where db = 'query' AND type = 'FUNCTION' \G *************************** 1. row ***************************                   ... Read More

How can we perform START transactions inside MySQL stored procedure?

Sreemaha

Sreemaha

Updated on 22-Jun-2020 06:50:09

315 Views

As we know the START transaction will start the transaction and set the auto-commit mode to off. In the following example, we have created a stored procedure with a START transaction which will insert a new record in table employee.tbl having the following data −mysql> Select * from employee.tbl; +----+---------+ ... Read More

Advertisements