25.9 C
Bacolod City
Friday, September 21, 2018

SQL Primary Key Constraint

This constraint is used to uniquely define an identify any entry in the table. There are certain conditions like a primary key value can’t...

SQL Regular Expressions

Following is the table of pattern, which can be used along with REGEXP operator in a query for a selected table in the database. Pattern What the pattern...

SQL NULL Values

When SELECT command is used along with WHERE clause  in order to fetch data from MySQL table of a given database, but the condition implied doesn’t have any...

SQL Join Command

Join Command is basically used to get the data from different tables using a single query into a single table. A user can use JOIN...

SQL AND & OR Operators

We can link multiple WHERE statements by AND/OR statements. AND means that all the conditions are TRUE. OR means, at least, one condition is TRUE.   For example,...

SQL ALTER Table Statement

Using ALTER Table Statement, we were able to Add, Delete or Modify Columns in an existing table.   Syntax to add a column: ALTER TABLE ADD ...

SQL ORDER BY keyword

ORDER BY used to define how the records are to be sorted. By default, it is to order in ascending order(ASC). If we want to sort in...

SQL LIKE Clause

A “where” command is used when a user wants the exact result .For example, a user wants to search for the name Rajat Sharma...

SQL WHERE Clause

SQL WHERE clause is an optional clause used to define what records are to be included in the query. We use conditional operators like...

SQL INSERT INTO Statement

A user can insert the data into MySQL table using SQL INSERT INTO command. It can be done in two ways:-   1.) By using mysql>...

SQL Drop Table

MySql Drop Table declaration allow deleting tables from the MySql Database. After dropping tables, it removed all of its data permanently by using the...

SQL Create Table

Create is used to define new tables. Syntax : CREATE TABLE ( Constraint Primary Key, , .................................. ) ;   The...

SQL Delete Statement

If you want to delete a record from any MySQL table, then you can use SQL DELETE Statement. 1.)command at mysql> prompt 2.) any script like...

SQL UPDATE Statement

A user  can do so by using SQL UPDATE Statement. This will help in modifying  any field value of any MySQL table in a given database....

SQL SELECT Statement

The SELECT statement tells what is to be returned. ‘*’means all the columns from all tables in the from statement are to be returned.   Syntax:   SELECT...

Follow us on Facebook

SuperWebTricks Loading...

Subscribe For Latest Updates

Signup for our newsletter and get notified when we publish new articles for free!