MySQL CASE OPERATOR Tutorial

MySQL CASE Operator is used for  flow control. It is useful to create a complex conditional construct.

The Synatx is as follows :

CASE case_value
WHEN when_value THEN statement_list
[WHEN when_value THEN statement_list] ...
[ELSE statement_list]
END CASE

An example of MySQL CASE Operator is :

Refernce : MySQL CASE OPERATOR of w3resource MySQL Tutorial.

CROSS JOIN SQL

What does SQL CROSS JOIN do?

It produces number of rows in  the first table multiplied by the number of rows in the second table - a Cartesian Product.

Syntax 


FROM table1
CROSS JOIN table2;

What are the options to create table in PostgreSQL

Here is a list of ways you can Create Table in PostgreSQL

Command line

PgAdmin III

phpPgAdmin

Which way do you prefer?

JSON Tutorial

This page introduces you to JSON - JavaScript Object Notation. We have discussed definition, history, usage and Comparison with XML of JSON in this page.http://www.w3resource.com/JSON/introduction.php

NoSQL

NoSQL is a non-relational database management systems, different from traditional relational database management systems in some significant ways. It is designed for distributed data stores where very large scale of data storing needs (for example Google or Facebook which collects terabits of data every day for their users). These type of data storing may not require fixed schema, avoid join operations and typically scale horizontally. http://www.w3resource.com/mongodb/nosql.php

Schema.org tutorial

Schema.org is a Open Source project announced on June 2, 2011 by Bing, Google, Yahoo and sitemap.org.
The purpose of Schema.org is to introduce a set of schema (html tags). Upon using these tags in a website, search engines can understand the intention of using content(text, image, video) in that website better; which in turn would return better search results when a user is looking for a specific content through search engine.http://www.w3resource.com/schema.org/introduction.php

Twitter Bootstrap tutorial

Twitter Bootstrap is a toolkit to develop web apps and sites fast. It includes basic CSS and HTML for creating Grids, Layouts, Typography, Tables, Forms, Navigation, Alerts, Popovers etc.
In this and consequent pages, w3resource covers Twitter Bootstrap tool in detail, which will equip you to build web apps and sites using the tool.
 http://www.w3resource.com/twitter-bootstrap/tutorial.php

SQL insert into statement

Learn how to use insert rows in to a table .
Sql insert into statement
The Sql INSERT statement is used to insert a single record or multiple records into a table.
While inserting a row, if the columns are not specified, it means that vales are added for all of the columns of the table resulting addition of a single row. If it is required to insert values for one or more specific column(s), then it is necessary to specify the name(s) of the column(s) in the sql query.

Insert null


The SQL INSERT statement can also be used to insert NULL value for a column.

Insert for specific column
The SQL INSERT INTO statement can also be used to insert one or more specific columns for a row. It is required to mention the column(s) name in the sql query.

Inserting the result of a query in another table


All the rows or some rows of another table can also be inserted into the table using INSERT INTO statement. The rows of another table will be fetched based on one or more criteria using SQL SELECT statement.
Inserting the result of a query in another table using order by

An arranged order of rows (ascending or descending) of one table can also be inserted into another table by the use of SQL SELECT statement along with ORDER BY clause.

Inserting the result of a query in another table using group by
A group of rows of one table can be inserted into another table by the use of SQL SELECT statement along with GROUP BY clause. 


Inserting records using select with order by and group by
How records of another table can be inserted using SQL SELECT statement along with ORDER BY and GROUP BY in a INSERT INTO statement.

Insert using subqueries
Inserting rows of another table using subquery.

Insert using subqueries with where clause

How to insert rows using INSERT INTO statement, where rows are results of a subquery, made up of SQL SELECT statement with WHERE clause.

Insert using subqueries with any operator

How an ANY operator can participate in an INSERT INTO statement. 


Insert using subqueries with any operator and groupby

How an ANY operator with GROUP BY clause can participate in an INSERT INTO statement.

Insert using nested subqueries with any operator

How two or more subqueries can be implemented in an INSERT INTO statement to insert rows into a table.

Insert using nested subqueries with any operator and group by

How an ANY operator with GROUP BY can be used in an INSERT INTO statement to insert records in a table.

Insert using nested subqueries with any operator and group by and order by

How an ANY operator with ORDER BY and GROUP BY can be used in an INSERT INTO statement to insert records in a table.

Insert using subqueries with max function

How an MAX() function in a subquery can be used in an INSERT INTO statement to insert records in a table.

Learn web development

After working so many years as a developer, I feel like I should share my humble skill set with fellow developers and beginners. Sharing knowledge is awesome. You come to know what others are doing and learn new things. While there are millions of web developers out there those who are starting they journey. In this short post I would like to show a list of online (and free too) resources which can help you to learn.

1. HTML 4.01  : http://www.w3.org/TR/html401/, http://www.w3resource.com/html/HTML-tutorials.php
2. CSS 2.1 : http://www.w3.org/TR/CSS21/, http://www.w3resource.com/css/CSS-tutorials.php
3. JavaScript :  http://download.oracle.com/docs/cd/E19957-01/816-6408-10/http://www.w3resource.com/javascript/javascript.php,
4. PHP  : http://php.net/manual/en/index.php, http://www.w3resource.com/php/php-home.php
5. SQL : http://www.w3resource.com/sql/tutorials.php
6. MySQL : http://dev.mysql.com/doc/, http://www.w3resource.com/mysql/mysql-tutorials.php