Categories
MySQL

Understanding MySQL LEFT JOIN

MySQL LEFT JOIN allows you to get result set from two or more tables for certain matches. Suppose you have two tables i.e. A and B. So if you join A to B using left join then all rows from the A tables will be displayed with matches a row from the B table. Example […]

Categories
Css Css3

Difference between @import and link

Using both @import and link tag you can include style sheet in a webpage. But there is a difference. For performance “link” has a much better advantage. Example of @import and link: <link href=”style.css” type=”text/css” /> <style type=”text/css”> @import url(“style.css”); </style> As @import allows you to import one style sheet into another but older browsers […]

Categories
MySQL

Referential integrity

It is relational database concept in which multiple tables shares consistent relationship based on the data stored on tables. For example, a school X has 2 tables, a student table, and a student fee table. In the student table we have 2 columns – the student ID and the student name. In the student fee […]

Categories
Html

HTML Lists

In html two different lists of elements are present i.e. unordered list and ordered list. Unordered lists: This lists enclosed with <ul> element and are bullet lists. <ul> <li>List 1</li> <li>List 2</li> <li>List 3</li> </ul> You can also change the type of bullet i.e. <ul type=”square”><li>…</li></ul> <ul type=”circle”><li>…</li></ul> <ul type=”disc”><li>…</li></ul> Ordered lists: These are used […]

Categories
MySQL

MySQL UPDATE Statement

Using MySQL UPDATE statement you can update existing data in a table. it can be a single column or multiple rows. Here is a simple example of MySQL UPDATE: UPDATE users SET user_address = ‘Kolkata, India’, user_state = ‘WB’ WHERE user_id = 247 You can also update fields depends on JOIN query on two or […]

Categories
MySQL

MySQL Storage Engines

When you create a database you have to choose the storage engine for storing data into the database. MySQL supports various types of storage engines i.e. MyISAM, InnoDB, MERGE, MEMORY (HEAP), ARCHIVE, CSV, FEDERATED. Each storage engines has different performance of the database and has advantages or disadvantages. Here is the list of MySQL Storage […]

Categories
MySQL

MySQL INNER JOIN

Using MySQL INNER JOIN you can match rows in one table with another table and get result set that contain columns from both tables. Suppose we have two tables user and order. So Using this join we will get the result row where userid from user table and userid from order table matches. Read Also: […]

Categories
MySQL

Primary Key, Unique Key, Key, Foreign Key

A primary key is a column or multiple columns that uniquely identify each row in a table.Basic key of primary key:– This must contain unique values– For multiple columns, the combination of values must be unique– Primary key is not null– Only one primary key will be present in a table As MySQL works faster […]

Categories
MySQL

MySQL ORDER BY & LIMIT

To sort a table columns in ascending or descending order you use ORDER BY clause. Using ASC and DESC you can get the result in ascending or descending order. You can also apply both order for different columns at the same time. ORDER BY EXAMPLE: SELECT name, address FROM users WHERE state = ‘AL’ ORDER […]

Categories
AngularJS

AngularJS Views

Using ng-view and ng-template directives and $routeProvider services you can provide single page application via multiple views on a single page. ng-view: A place holder where a corresponding view can be placed.ng-template: Used to create an html view using script tag with the help of “id” attribute.$routeProvider: Set the configuration of urls and map them […]