Posts

Showing posts from April, 2018

DROP DATABASE statement in SQL

Image
The DROP DATABASE statement is used to drop the existing database. Syntax: DROP DATABASE databasename; DROP DATABASE EXAMPLE DROP DATABASE test; Note:  Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database! Make sure you have admin privilege before dropping any database otherwise you will not able to drop the database. Once a database is dropped, you can check it in the list of databases with the following SQL command: SHOW DATABASES;

CREATE DATABASE statement in SQL

Image
The CREATE DATABASE statement is used to create a new database. Syntax: CREATE DATABASE databasename; CREATE DATABASE EXAMPLE CREATE DATABASE test;   Note:  Make sure you have admin privilege before creating any database. Once a database is created, you can check it in the list of databases with the following SQL command: SHOW DATABASES;

The Difference Between ID and Class in CSS

Image
The difference between an ID and a class is that an ID can be used to identify one element, whereas a class can be used to identify more than one. The benefit of this is that you can have the same HTML element, but presented it differently depends upon its class and id properties.  HTML elements can have both class and Id  selectors. <div class = "box"  id = "header">     .............     ............. </div> In the CSS, a class selector is a name preceded by a  full stop  (“.”) and an ID selector is a name preceded by a  hash character  (“#”).    ID's are unique Each Element can has only one id. Each page can have only one element with that ID. CLASSES are Not unique we can use same class on multiple elements we can use multiple class on the same elements

.serializeArray() in Jquery

The  serializeArray()  method serializes all forms and form elements, The serializeArray() method creates an javascript array of objects (name and value) by serializing form values. <form action="#" method="post" name="formForDesignation" id="formForDesignation">                              <input type="text" placeholder="Project managet" name="designation_name" id="designation_name"  required="true">                                                                 <input type="text" placeholder="PM"  name="desig_code" id="desig_code" required="true">                                             ...