ECommerce Technology

What is a network - Why Have Networks? - Network Types - Network Design - Network Topology - Intranet and Extranet

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