Rishi Rathor has Published 142 Articles

What are the limitations for replicating stored procedure and functions?

Rishi Rathor

Rishi Rathor

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

245 Views

Followings are the limitations for replicating stored procedure and functions −Type of Action − Actually the replication of stored procedure and functions depends upon the type of action. If the action, embedded in stored procedures, is nondeterministic (random) or time-based then it may not replicate properly. By their very nature, ... Read More

Create a procedure to list the tables with detailed information in a particular database.

Rishi Rathor

Rishi Rathor

Updated on 22-Jun-2020 06:51:19

118 Views

Suppose currently we are using a database named ‘query’ and it is having the following tables in it −mysql> Show tables in query; +-----------------+ | Tables_in_query | +-----------------+ | student_detail  | | student_info    | +-----------------+ 2 rows in set (0.00 sec)Now, following is a stored procedure, which will give ... Read More

What MySQL returns if I do not use the keyword ‘RIGHT’ or ‘LEFT’ while writing the query for RIGHT JOIN or LEFT JOIN?

Rishi Rathor

Rishi Rathor

Updated on 20-Jun-2020 11:00:48

106 Views

In both the cases i.e. on not using ‘RIGHT’ or ‘LEFT’ keyword in the query, MySQL will return the result by taking it as INNER JOIN query. It is because the only difference between RIGHT, LEFT and INNER JOIN is the keyword of RIGHT or LEFT. To understand it, we ... Read More

How can I check the character set of all the tables along with column names in a particular MySQL database?

Rishi Rathor

Rishi Rathor

Updated on 20-Jun-2020 07:33:43

168 Views

With the help of the following MySQL query we can check the character sets of all the tables in a particular database −mysql> Select Column_name, TABLE_NAME, CHARACTER_SET_NAME FROM        INFORMATION_SCHEMA.Columns Where TABLE_SCHEMA = 'db_name';ExampleFor example, the query below returns the character sets of all the tables along with ... Read More

How to use compound INTERVAL unit in MySQL?

Rishi Rathor

Rishi Rathor

Updated on 20-Jun-2020 06:26:43

164 Views

Compound INTERVAL unit keywords are made up of two keywords and separated by an underscore (_). For using them in MySQL the unit values must be enclosed in single quotes and separated by space.Example − Following query will add 2 years and 2 months in the date value.mysql> Select timestamp('2017-10-22 ... Read More

CSS3 Rounded corners

Rishi Rathor

Rishi Rathor

Updated on 19-Jun-2020 16:37:37

148 Views

CSS3 Rounded corners are used to add a special colored corner to body or text by using the border-radius property.A simple syntax of rounded corners is as follows −#rcorners {    border-radius: 60px/15px;    background: #FF0000;    padding: 20px;    width: 200px;    height: 150px; }The following table shows the ... Read More

What are some good sites for Java interview questions

Rishi Rathor

Rishi Rathor

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

171 Views

There are many sites which are a good resource for java interview questions-answers. Following is the list of most popular websites.Tutorialspoint  - www.tutorialspoint.comStackOverflow - www.stackoverflow.comDZone - www.dzone.comWikipedia - www.wikipedia.orgIBM Developer Works - www.ibm.com/developerworks/java/TechGig - www.techgig.comGitHub - www.github.comJava documentation - docs.oracle.com/javase/Coursera - www.coursera.org/JavaWorld - www.javaworld.com/Read More

What is the difference between new operator and object() constructor in JavaScript?

Rishi Rathor

Rishi Rathor

Updated on 17-Jun-2020 06:09:54

1K+ Views

The new operatorThe new operator is used to create an instance of an object. To create an object, the new operator is followed by the constructor method.In the following example, the constructor methods are Object(), Array(), and Date(). These constructors are built-in JavaScript functions.var department = new Object(); var books ... Read More

What is the shortest function of reading a cookie by name in JavaScript?

Rishi Rathor

Rishi Rathor

Updated on 16-Jun-2020 12:11:58

142 Views

Here’s the best way to read cookies by name in JavaScript. The following is the function −function ReadCookie() {    var allcookies = document.cookie;    document.write ("All Cookies : " + allcookies );    // Get all the cookies pairs in an array    cookiearray = allcookies.split(';');   ... Read More

How to create cookies in JavaScript?

Rishi Rathor

Rishi Rathor

Updated on 16-Jun-2020 11:51:30

778 Views

Using cookies is the most efficient method of remembering and tracking preferences, purchases, commissions, and other information required for better visitor experience or site statistics.The simplest way to create a cookie is to assign a string value to the document.cookie object, which looks like this.document.cookie = "key1=value1;key2=value2;expires=date";Here the expires attribute ... Read More

Previous 1 ... 3 4 5 6 7 ... 15 Next
Advertisements