Swarali Sree has Published 75 Articles

How can we get the sorted MySQL output?

Swarali Sree

Swarali Sree

Updated on 20-Jun-2020 06:21:03

61 Views

We know that MySQL SELECT command is used to fetch data from a MySQL table. When you select rows, the MySQL server is free to return them in any order, unless you instruct it otherwise by saying how to sort the result. But, we can sort a result set by ... Read More

What happens if I will add a UNIQUE constraint on the same column for multiple times?

Swarali Sree

Swarali Sree

Updated on 19-Jun-2020 11:51:15

481 Views

When we will add a UNIQUE constraint on the same column multiple times then MySQL will create the index on that column for a number of times we have added the UNIQUE constraint.ExampleSuppose we have the table ‘employee’ in which we have the UNIQUE constraint on ‘empid’ column. It can ... Read More

How can we apply UNIQUE constraint to the field of an existing MySQL table?

Swarali Sree

Swarali Sree

Updated on 19-Jun-2020 11:47:43

366 Views

We can apply the UNIQUE constraint to a column of an existing MySQL table with the help of ALTER TABLE statement.SyntaxALTER TABLE table_name MODIFY colum_name datatype UNIQUE;                     OR ALTER TABLE table_name ADD UNIQUE (colum_name);ExampleSuppose we have the following table named ... Read More

What is the difference between global and local Variables in JavaScript?

Swarali Sree

Swarali Sree

Updated on 15-Jun-2020 12:06:30

5K+ Views

The scope of a variable is the region of your program in which it is defined. JavaScript variables have only two scopes.Global Variables − A global variable has a global scope which means it can be defined anywhere in your JavaScript code.Local Variables − A local variable will be visible ... Read More

How to use formaction attribute in HTML?

Swarali Sree

Swarali Sree

Updated on 15-Jun-2020 11:28:54

250 Views

The formaction attribute works when let’s say you have two submit buttons in your form and you want both the buttons to work separately. Both the buttons send data to different pages. The formaction attribute overrides the form action attribute.Note − The formaction attribute is not supported in Internet Explorer 9 and earlier ... Read More

What is difference between

Swarali Sree

Swarali Sree

Updated on 15-Jun-2020 11:15:38

2K+ Views

In HTML, is used to create buttons in an HTML form. Inside the tag, you can place content like text or images. But, this is not the case with the buttons created with tag.Let’s see an example of button and ,HTML tagIt is used for creating ... Read More

How to determine if a variable is 'undefined' or 'null'?

Swarali Sree

Swarali Sree

Updated on 15-Jun-2020 09:13:24

534 Views

On getting the result of the following, you can find whether a variable is null or undefined. If the result is “false”, it means the variable is null and undefined.Here, the variable results in “True” −                    var age = 10;          if(age) {             document.write("True");          } else {             document.write("False");          }          

Is it required a configuration in SAP SM59?

Swarali Sree

Swarali Sree

Updated on 15-Jun-2020 06:54:12

253 Views

If you are only calling a Remote Function Module in SAP system, you don’t require any configuration in SM59.Considering a scenario where your SAP system has to call a function in the C# application, then you need to configure RFC destination using SM59. You can Transaction for defining HTTP destinations- ... Read More

What does the method sort(int[] a) do in java?

Swarali Sree

Swarali Sree

Updated on 13-Jun-2020 11:56:46

59 Views

The sort(int[]) method of the java.util.Arrays class sorts the specified array of integer values into ascending numerical order.Exampleimport java.util.Arrays; public class ArrayDemo {    public static void main(String[] args) {       int iArr[] = {2, 1, 9, 6, 4};       for (int number : iArr) { ... Read More

How to set all the background properties in one declaration with JavaScript DOM?

Swarali Sree

Swarali Sree

Updated on 23-May-2020 11:41:14

62 Views

To set the background in JavaScript, use the background property. It allows you to set the background color, image, position, etc.ExampleYou can try to run the following code to learn how to set all the background properties in a single declaration with JavaScript.Live Demo           ... Read More

Advertisements