Product Solutions Support
Try MemSQL

UPDATE

Updates data in a table.

Syntax

UPDATE tbl_name
    SET col_name1=expr [, col_name2=expr] ...
    [WHERE expr]
    [LIMIT row_count]

Remarks

Example

mysql> UPDATE mytbl
SET vehicle_id='X3023X';

mysql> UPDATE mytbl
SET vehicle_id='X3023X'
WHERE vehicle_model IN (SELECT model FROM all_models);
Was this article useful?