MySQL inserting, updating, deleting data

1, insert the data: Because the ID of the following table will be self-increment, it is assigned null.

Note: string with ' single quotation mark, cannot double quotation mark, English state.

You can write a partial property name for an insert operation, such as Booktypeid not written, default null.

You can also write all the property names to insert the operation:

Insert more than one data at a time, with the emphasis on VALUES (), (), (),..... ();

========================================================

2. Update data

Before a single update:

After a single update:(attribute names are separated by commas in English)

Before multiple updates:

After several updates: This uses the like for fuzzy queries.

===============================================================

3. Delete data:

Before deleting a single piece of data:

After deleting a piece of data: Id=9 's data has been deleted.

Before deleting multiple strips:

After deleting multiple strips:

MySQL inserting, updating, deleting data