What commands are used to change the composition of the database records?
August 31, 2020 | Education|
Information in databases is subject to frequent changes. In our hypothetical DBMS, there are two commands for these purposes. The first one allows you to delete rows from a table.
Its format is as follows:. remove where <boolean expression>
To delete one specific record from the database, you need to specify the value of the key for this record.
If you need to add new records to the finished database, you can always do this using the command you already know: add record.
This command gives the user the opportunity to enter the values of the fields of a new record, which will be entered at the end of the table.
Remember: The process of learning a person lasts a lifetime. The value of the same knowledge for different people may be different, it is determined by their individual characteristics and needs. Therefore, knowledge is always needed at any age and position.