The basic syntax for adding, deleting, modifying and querying sql is as follows:

1, "Insert? INTO "statement, which is used to add a new row to the table.

2. The "delete" statement is used to delete rows in the table.

3. The "update" statement is used to modify the data in the table.

4. The "select" statement is used to select data from the table.

The characteristics of sql language:

SQL can independently complete all activities in the database life cycle, including a series of operations such as defining relational schema, inputting data, establishing database, querying, updating, maintaining, reconstructing database and controlling database security, which provides a good environment for the development of database application systems. After the database is put into operation, the mode can be modified step by step as needed without affecting the operation of the database, so that the system has good scalability.