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
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
Html

HTML Entities

In many different language HTML language is used. So it contains different types of symbols or entities which are not english alphabet. These entities starts with ampersand character and finish with semicolor character. For e.g. &quot; Here is a list of entities examples: &quot; “ &apos; ‘ &amp; & &lt; < &gt; > &pound; £ […]

Categories
Css3

A Little Known CSS Facts

As you have been writing css for several years day by day you are getting new things that you have never used previously. Each and every well trained front-end developer feature-tests before using any features which a browser may not have. This feature testing has always done with scripting, and most of the people use […]

Categories
MySQL

MySQL UNION Operator

Using MySQL UNION Operator you can combine two or more result set from a multiple table into a single result set. UNION operator eliminates duplicate rows from the result set even you forgot to use DISTINCT operator. UNION ALL allows duplicate rows remain in the result. In the corresponding SELECT statements the number of columns […]

Categories
Html

Element Structure of HTML

HTML documents consists of multiple element structure which includes start tag, attribute, body element, end tag etc. Element Structure: The main tag of HTML is <html> and </html> which is start tag and end tag.The content element is written between two tags i.e. body tag.For example, <p>Hello there!</p> Few HTML elements have no body i.e. […]

Categories
AngularJS

Include files on AngularJS

In HTML you can not include files like HTML into another HTML pages. To achieve this functionality you had to choose either Ajax call or server side includes like php, jsp. But using AngularJS you can embed HTML page within a HTML page using ng-include directive. By default, for same domain and protocol as a […]

Categories
MySQL

Database Manage in MySQL

Database Manage in MySQL is a first priority to maintain a database. Here you will learn how you can manage database i.e. create a new database in MySQL, remove existing database etc. A database is nothing but a container of data that stores any kind of data. Here is how database manage: Creating DatabaseCREATE DATABASE […]

Categories
AngularJS

AngularJS Controller

To control the flow of data AngularJS mainly relies on controllers. It is defined using ng-controller directive. Controller contain attributes, properties and functions. Example of Controller: <html> <head> <title>AngularJS Controllers</title> <script src=”http://ajax.googleapis.com/ajax/libs/angularjs/1.3.14/angular.min.js”></script> </head> <body> <h2>AngularJS Controllers</h2> <div ng-app=”ngApp” ng-controller=”nameController”> First name: <input type=”text” ng-model=”name.firstName”><br><br> Last name: <input type=”text” ng-model=”name.lastName”><br> <br> Full name: {{name.fullName()}} </div> <script> […]