SQL Update example - Pure Example

同時更新在所有資料列裡多個欄位 的值 Sytax : Update table_name SET col_name1 = value1, col_name2 = value2, col_name3 = value3 ... SQL UPDATE Songs SET SongPlayCount = 2000 WHERE Artist = 'Kiss' 會輸出結果 Artist SongTitle SongPlayCount 30 ...

www.pureexample.com