Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Storage Area Networks are typically used to provide access to data storage. These make sure that storage devices such as disks, tape drives etc. can be accessed by an operating system as system storage devices.Storage Area Networks are quite cheap and so are used both by large conglomerates and small businesses.An image that illustrates storage area networks is as follows −Components of Storage Area NetworksThe different components in storage area networks are −Host LayerAll the servers that provide access to the storage area network collectively constitute the host layer. These servers have host bus adapters that allow the operating system ... Read More
A subquery is best defined as a query within a query. Subqueries enable you to write queries that select data rows for criteria that are actually developed while the query is executing at runtime. More formally, it is the use of a SELECT statement inside one of the clauses of another SELECT statement. In fact, a subquery can be contained inside another subquery, which is inside another subquery, and so forth. A subquery can also be nested inside INSERT, UPDATE, and DELETE statements. Subqueries must be enclosed within parentheses.A subquery can be used any place where an expression is allowed ... Read More
In symmetric multiprocessing, multiple processors work in parallel and share resources like system bus and memory. It is a type of multiprocessing system and much more complex than asymmetric multiprocessing system.Symmetric Multiprocessing ArchitectureThe image depicting symmetric multiprocessing architecture is as follows −Some points explaining the above figure are −All the processors in the symmetric multiprocessing architecture contain a common bus and main memory. That is why symmetric multiprocessing is known as tightly coupled multiprocessing.Each of the processors in symmetric multiprocessing are equal and can execute different processes as required no matter where these processes are stored in memory. This is ... Read More
We can easily disable input box(textbox,textarea) using disable attribute to “disabled”.$(‘elementname’).attr(‘disabled’,’disabled’);To enable disabled element we need to remove “disabled” attribute from this element.$(‘elementname’).removeAttr(‘disabled’);Example ed $(document).ready(function () { $('#btn1').click(function () { $('input').attr('disabled', 'disabled'); }); $('#btn2').click(function () { $('input').removeAttr('disabled'); }); }); Disable Enable
We can see only the list of stored functions in a particular MySQL database by the following query −mysql> SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'query' AND ROUTINE_TYPE = 'FUNCTION'// +--------------+--------------------+ | ROUTINE_TYPE | ROUTINE_NAME | +--------------+--------------------+ | FUNCTION | factorial | | FUNCTION | Hello | +--------------+--------------------+ 2 rows in set (0.07 sec)
You can use .is(‘:visible’) selects all elements that are visible.Example divvisible $(document).ready(function () { $("button").click(function () { var dim = $('#div1').is(":visible"); if (dim == false) { $('#div1').css({ "display": "block", "color": "red" }); } }); }); Div is visible Click Here
We can see the list, along with other information, of stored functions in a particular MySQL database by the following query −mysql> SHOW FUNCTION STATUS WHERE db = 'query'\G *************************** 1. row *************************** Db: query Name: factorial Type: FUNCTION Definer: root@localhost Modified: 2021-11-16 14:04:48 Created: 2021-11-16 14:04:48 Security_type: DEFINER ... Read More
For getting the current URL you can use attr() method or window.location.Example url $(document).ready(function () { $("button").click(function () { alert($(location).attr('href')); alert(window.location); }); }); Display URL
We can sort the result set groups by using group functions in the ORDER BY clause. By default, the sort order is ascending but we can reverse it by using DESC keyword.Examplemysql> Select designation, YEAR(Doj), count(*) from employees GROUP BY designation, YEAR(DoJ) ORDER BY Count(*) DESC; +-------------+-----------+----------+ | designation | YEAR(Doj) | count(*) | +-------------+-----------+----------+ | Prof | 2009 | 2 | | Asst.Prof | 2015 | 1 | | Asst.Prof | 2016 | 1 | | Prof ... Read More
As we know that SOUNDEX() function is used to return the soundex, a phonetic algorithm for indexing names after English pronunciation of sound, a string of a string. In the following example, we are taking the data from ‘student_info’ table and applying SOUNDEX() function with LIKE operator to retrieve a particular record from a table −mysql> Select * from Student_info; +------+---------+------------+------------+ | id | Name | Address | Subject | +------+---------+------------+------------+ | 101 | YashPal | Amritsar | History | | 105 | Gaurav | Chandigarh | Literature | | 125 | Raman | Shimla ... Read More