ECommerce Technology

 Site Map :: Contact Us

ECommerce >> Database Connectivity


Basic operations

 

There are four basic operations that we will learn about.

SELECT - retrieves data

INSERT - adds data

UPDATE - edits existing data

DELETE - removes data

 

Basic operators

 

The following operators can be used in SQL:

 

Operator Description

 

= Equality

<> Non-equality

!= Non-equality

< Less than

<= Less than or equal to

!< Not less than

> Greater than

>= Greater than or equal to

!>Not greater than

BETWEEN Between two specified values

IS NULL Is a NULL value

©2005 eCommerce Technology. All rights reserved