Running Basic SQL Queries

In this article I will explain about basic SQL queries. I will show the most used, to select the necessary information, to edit data, delete and order detailed information.

CREATE

This command creates an object within the database manager. It can be a database, table, index, stored procedure or view.

create

CREATE syntax (create table example)

CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
….
)

SELECT

Displays information about the data stored in the database. Such information may belong to one or more tables.

select

SELECT basic syntax

SELECT column_name1, column_name2

FROM table_name;

WHERE

Specifies a condition that must be met for data to be returned by the query. It supports the logical operators AND and OR.

where

WHERE basic syntax

SELECT column_name1, column_name2

FROM table_name

WHERE column_name operator value

INSERT

Add one or more records to one (and only one) table in a relational database.

insert

INSERT basic syntax

INSERT INTO table_name

(column_name1, column_name2, ….)

VALUES

(value1, value2, ….)

UPDATE

The UPDATE statement is used to update existing records in a table.

update

UPDATE basic syntax

UPDATE table_name

SET column1=value1,column2=value2,…

WHERE some_column=some_value

DELETE

The DELETE statement is used to delete records in a table.

delete

DELETE basic syntax

DELETE FROM table_name

WHERE some_column=some_value

And that’s it! Using these basic commands help you manage your databases. These are basic SQL queries you should know how they work.

This concludes Running Basic SQL Queries

Looking for quality Windows Hosting? Look no further than Arvixe Web Hosting!

Happy Hosting!

Tags: , , , , , , | Posted under ASP .NET 2, ASP .NET 4.0, DotNetPanel Administration | RSS 2.0

Author Spotlight

Rodolfo Hernandez

I like photography and reading books. Currently working for Arvixe as Elgg Community Liaison. Elgg Security Expert Web Security Expert CEO of UDP SW Social Web

Leave a Reply

Your email address will not be published. Required fields are marked *