INSERT

    • represents the value of corresponding field, which is a constant. The correspondence between field type and inserted value is maintained by users themselves.
    • json_value should be a valid JSON expression. And when inserting a JSON value, remember to put s around it.
    1. INSERT INTO weather (cityId, temperature, humidity) VALUES (11254469, 12, 65);