Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - Help explain this SQL statement! ! !
Help explain this SQL statement! ! !
This is a modification of an existing table, and a new field has been added to the table:

A new field is added to the enewsmod table. The name of the new field is qcom_post.

The new field is a small plastic TINYINT (length 1).

And the new field does not allow Not Null,

And set the default value of this new field to -0 (that is, when a new data is added to the table, the data of this field is written to 0 by default).

-

Grammar:

Add fields to change the table

The table inside is an existing table;

This field is the field to be added. Field name and field type (character type, numeric type, etc. ) Be sure to write. There are: null or non-null values (Null | Not Null, default is non-null not null), default values (that is, default values) and so on.