MySQL Basic notes (iv)-Data basic operations

Data manipulation

New data: two different options.

1, plan one, to insert data into the whole table field, do not need to specify a list of fields, the order of the data must appear in accordance with the design of the table in the order in which the fields appear. Any non-numeric data that needs to be wrapped using quotation marks (single quotes are recommended).

 1insertintovalues(Value list)[, (Value list)];    -- You can insert multiple records at once. 

2, scenario two, to insert data for some fields, you need to select the field list, the field list appears in the order of the field is independent of the order, but the value list must match the order of the selected fields.

1 Insert  into Values (Value list) [, (Value list)];

　　View data:

1 Select */  from　　[where Condition ]; --View All data

1 -- View the specified field, specifying the condition data 2 Select where = a value;

　　Update data

 1updateset=[where condition];

Delete data

Delete  from [where Condition ];

Previous page: MySQL basic Note (iii)-table operation Basics

MySQL Basic notes (iv)-Data basic operations