开发者

How I can set a column value for all my rows that already exist in the database with some sort of mysql statement

I want to set the value of the column 'character_hold' to 'no' for all my rows in my MYSQL database. Is there a SQL statement I can use i开发者_StackOverflow社区n phpmyadmin to set them all to 'no'?


UPDATE tableName set character_hold='no'

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜