Information is stored in the MySQL database in the form of tables. Each table has several columns and an arbitrary number of rows. As a rule, information is placed in rows, and its structure is determined by the names of the columns.
You can delete rows with a Query Delete MySQL query, but your own way of storing data is preferable. This allows you to determine the procedure for deleting information designed by the developer, and not provided for by the database query language .
Syntax and usage of Delete MySQL operator
Typically, to delete records, the developer uses simple forms of queries to the MySQL database:
- delete from `ex_customs` - delete all records from the ex_customs table;
- delete from `ex_customs` where` aCol` = '12 .13.14 '- deletes only those entries that have the value '12 .13.14' in the column `aCol`;
, Delete MySQL .
(order by) , (where). Limit .
:
`is_cache` , `owner_code` = 'CA011712011116164842'.
, , .
, .
, Limit. , , , .
, , , , .
MySQL Query: delete, insert update , .
. , : .
, :
- (iLineIns, iLinesAdd);
- (iLineUpd);
- (iLineDel);
- (iLineSel).
: , , , , .
, - . delete, MySQL . , .
-
MySQL: delete from * where & , (*) (&). MySQL - , , .
, . .
, . ( ), . , , .
- . - Delete MySQL, , .
oj_store, , ( oj_line). oj_name, oj_code - oj_owner.
With this decision, recording and deletion are performed at the object level, not the database rows. This translates the delete operation into a property of the object system, not using a particular query operator.