sentences

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;

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;

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], …..)

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, …);