sentences

Még több ilyen

Web 2.0 & Critical Thinking

Szerző: Megan Bilodeau

Customize Fields (Single/Mutli EIN)v1

Szerző: mamta bhandari

ENTORNO PERSONAL DE APRENDIZAJE Paola Tovar Flores

Szerző: PAOLA ISABEL TOVAR FLORES

ICt lessonn 2012

Szerző: Bryan Khua

sentences

Insert

Add rows of data to a table.

The general format is: INSERT INTO table_name (column_name, …) VALUES (column_value, …); or INSERT INTO table_name VALUES (column_value, …);

Create Table

The SQL CREATE TABLE command is used to create a database table and defines its data columns.

It has the following format: CREATE TABLE tablename (column_name datatype [constraint_name constraint type], …..)

Delete

Delete rows of data from a table.

The general format is: DELETE FROM tablename WHERE condition(s); e.g. DELETE FROM company WHERE company_ID = 10;

Update

To change a column value in a row or rows the UPDATE command can be used.

This has the following format UPDATE tablename SET condition WHERE condition e.g. UPDATE company SET company_name = ‘BMB’ WHERE company_ID = 10;