SQL DML Commands

Select Statements

• Select All Fields
• Select * from <TableName>
• Select Specific fields 
• Select <fieldName1,fieldName2,.. fieldNamen> from <TableName>
• Select With a condition
• Select <FieldNames> from <TableName Where (Condition)

Insert Statements

• Insert into <TableName> Values(Value1,Value2,..Value n)
• Insert into<TableName>( FieldName1, FieldNames2,.. FieldName n) Values(Value1,Value2..Value n)

Update Statement

• Update <TableName> Set(FieldName1=Value 1,..FieldName=Value n)

Delete Statement

• Delete All Values From Table
• Delete from <TableName>
• Delete Field with a Condition
• Delete from <TableName> Where (Condition)
• Delete A Table
• Drop Table <TableName>