Menu
I have a table with the columns: (this is only an example I have 50K records)
Name, Number Joe Null Michael Null Moses Null I to update the number with a sequence number from 1-3 so it will look like this:
Name, Number Joe 1 Michael 2 Moses 3 How can I do it in SQL for Mysql in one SQL command
584
MySQL UPDATE command can be used to update multiple columns by specifying a comma separated list of column_name = new_value. Where column_name is the name of the column to be updated and new_value is the new value with which the column will be updated.
First, specify the table name that you want to change data in the UPDATE clause. Second, assign a new value for the column that you want to update. In case you want to update data in multiple columns, each column = value pair is separated by a comma (,). Third, specify which rows you want to update in the WHERE clause.
MySQL UPDATE UPDATE with ORDER BY and LIMITIf the ORDER BY clause is specified in your update SQL statement, the rows are updated in the order that is specified. If LIMIT clause is specified in your SQL statement, that places a limit on the number of rows that can be updated.
SET @rank:=0; update T set Number=@rank:=@rank+1; UPDATE
alternative way with one statement
UPDATE T JOIN (SELECT @rank := 0) r SET Number=@rank:=@rank+1; If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
