Krantik Chavan has Published 278 Articles

Shorthand property to set all the animation properties with CSS

Krantik Chavan

Krantik Chavan

Updated on 24-Jun-2020 06:11:27

167 Views

The shorthand property to set all the animation properties is animation. It sets the animation duration, animation name, etc.You can try to run the following code to work with animation shorthand property:ExampleLive Demo                    div {         ... Read More

How to set the alignment between the items inside a flexible container when the items do not use all available space with JavaScript?

Krantik Chavan

Krantik Chavan

Updated on 23-Jun-2020 13:00:21

107 Views

Use the alignContent property in JavaScript to set the alignment between the items inside a flexible container.ExampleYou can try to run the following code to implement alignContent property in JavaScript −                    #box {             border: 1px ... Read More

What is to be done when text overflows the containing element with JavaScript?

Krantik Chavan

Krantik Chavan

Updated on 23-Jun-2020 11:36:08

94 Views

Use the textOverflow property to counter the text overflow issue. Add ellipses if the text overflows the containing element.ExampleYou can try to run the following code to learn what is to be done when text overflows the containing element with JavaScript −             ... Read More

Where can I find documentation on formatting a date in JavaScript?

Krantik Chavan

Krantik Chavan

Updated on 23-Jun-2020 06:50:58

101 Views

The Date object is a datatype built into the JavaScript language. Date objects are created with the new Date( ) as shown below −new Date( ) new Date(milliseconds) new Date(datestring) new Date(year, month, date[, hour, minute, second, millisecond ])The following method is used to Manipulate Dates in JavaScript −Sr.NoMethod & ... Read More

Write an example to establish MySQL database connection using PHP script?

Krantik Chavan

Krantik Chavan

Updated on 22-Jun-2020 13:22:49

164 Views

We can use following PHP script to make a MySQL database connection having user ‘guest’ and password ‘guest123’.           Connecting MySQL Server                  

How will GROUP BY clause perform without an aggregate function?

Krantik Chavan

Krantik Chavan

Updated on 22-Jun-2020 12:31:12

6K+ Views

When we use GROUP BY clause in the SELECT statement without using aggregate functions then it would behave like DISTINCT clause. For example, we have the following table −mysql> Select * from Student_info; +------+---------+------------+------------+ | id   | Name    | Address    | Subject    | +------+---------+------------+------------+ | 101 ... Read More

How can we use both built-in-commands (G & g) and semicolon (;) in a single MySQL statement?

Krantik Chavan

Krantik Chavan

Updated on 22-Jun-2020 11:32:31

158 Views

As we know that built-in-commands (\G and \g) send the command to MySQL server for execution and with the help of Semicolon (;) MySQL determines the end of the statement. For using all three and getting the result without error, we need to write three queries, one query with \G, ... Read More

Create a MySQL stored procedure that counts the number of rows gets affected by MySQL query?

Krantik Chavan

Krantik Chavan

Updated on 22-Jun-2020 08:13:41

1K+ Views

Following is a procedure that counts the number of rows get affected by MySQL query −mysql> Delimiter // mysql> CREATE PROCEDURE `query`.`row_cnt` (IN command VarChar(60000))     -> BEGIN     -> SET @query = command;     -> PREPARE stmt FROM @query;     -> EXECUTE stmt;     ... Read More

How can we access tables through MySQL stored procedures?

Krantik Chavan

Krantik Chavan

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

374 Views

We can access one or all the tables from the MySQL stored procedure. Following is an example in which we created a stored procedure that will accept the name of the table as a parameter and after invoking it, will produce the result set with all the details from the ... Read More

How can I create a stored procedure to insert values in a MySQL table?

Krantik Chavan

Krantik Chavan

Updated on 22-Jun-2020 05:34:45

14K+ Views

We can create a stored procedure with an IN operator to insert values in a MySQL table. To make it understand we are taking an example of a table named ‘student_info’ having the following data −mysql> Select * from student_info; +------+---------+-----------+------------+ | id   | Name    | Address   ... Read More

Previous 1 ... 4 5 6 7 8 ... 28 Next
Advertisements