Updating all rows of table with $wpdb

It will not work as the update statement requires a selector to narrow down what to update. You should use a general query. For your needs use this:

$wpdb->query( 
    $wpdb->prepare( 
        "UPDATE $wpdb->comments
         SET `comment_karma` = %s",
         '123'
    )
);

Related Posts:

  1. Get error messages when $wpdb->insert() returns false?
  2. Detecting errors generated by $wpdb->get_results()
  3. Does dbDelta delete columns as well?
  4. wpdb update add current timestamp not working
  5. How to fetch Data in WordPress using MySQLi or $wpdb
  6. WordPress Unit Testing – Cannot Create Tables
  7. How to define composite keys with dbDelta()
  8. Does wpdb add considerable overhead on queries with large result sets?
  9. Why does $wpdb return strings for mysql integer values?
  10. $wpdb->prepare() warning in WordPress 3.5
  11. Inserting data into custom tables
  12. Hook into $wpdb
  13. Display data from a non wordpress database on a page template
  14. How might I retrieve a featured post image from an external WP site and display it as a link back?
  15. Inserting Post Meta From SQL
  16. Why does dbDelta() not catch MysqlErrors?
  17. Connecting to external oracle database
  18. Can’t save ajax value to database
  19. What causes the “max_user_connections” warning on WordPress frontend?
  20. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  21. Safe way to find last inserted id in a table?
  22. Is $wpdb->prepare escaping to much? How to use it properly?
  23. Database slowdown after update to 3.4.1
  24. Remove database entries where post_date > expiration date
  25. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  26. Get data from database using $WPDB
  27. Getting all the users who have author privilege
  28. Multiple postmeta with same name for one post in wp_postmeta table
  29. WP Database Table to CSV file
  30. In what part of the WordPress core does the users table and usermeta table get joined?
  31. Modify Database in Multi-Site wp_usermeta table
  32. Advanced SELECT query with condtional statements
  33. $wpdb doesn’t like to store arrays
  34. WordPress choose wrong database
  35. Redirecting to old domain after migration website
  36. Create table from array with prepare
  37. Does WordPress $wpdb functions wait when table is locked?
  38. How Can I Put Meta_Compare in the Database-Query?
  39. WordPress running SQL query to update database from form
  40. I’m not able to get access to $wpdb [duplicate]
  41. WPDB SQL query with prepare() returning variable, not db value
  42. $wpdb error (Call to a member function insert() on a non-object)
  43. Is it important to have integers inserted using %d rather than %s?
  44. Problem in using wpdb
  45. How to fetch records from database WordPress
  46. Best practice to limit results in get_row()?
  47. Best practice to import user base (subscribers) from one website to another?
  48. AJAX wp-mysql running too slow
  49. Clear Terms from Taxonomy for Specific Post IDs?
  50. Trouble running $wpdb->query() with last_insert_id
  51. How to get a list of WordPress default database tables?
  52. Connecting to a different database
  53. Using $wpdb | checking entered email against existing emails in db
  54. Query Column of Specific ID from Database Table
  55. How to delete a particular row in a database table
  56. How to create more than one new wpdb object?
  57. Optimizing function that automatically creates internal links based on post title string
  58. Update multiple rows in one query
  59. How to connect and insert data in database of wordpress?
  60. Get results from wordpress data custom table
  61. Should I use an additional column in the DB?
  62. Outputting query results
  63. access JSON results from wordpress database with wpdb
  64. Getting value from database table depending on field value
  65. add_post_meta — not working
  66. Select From wpdb – Author/User Directory page
  67. Creating and Using Tables in the WordPress Database
  68. wpdb->insert not inserting first variable
  69. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  70. $wpdb->insert not inserting all rows
  71. wpdb Insert unknown post data dynamic foreach loop
  72. How do I get database rows from a custom table using wpdb?
  73. SELECT rows between two datetimes when the range is dynamic [closed]
  74. How to insert a value to decimal type field using wpdb->prepare?
  75. Insert NULL value using prepare()
  76. Help with $wpdb on custom code
  77. “BS_” rows in postmeta table
  78. $wpdb->insert duplicating rows
  79. How to rerieve comments and their replies from DB
  80. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  81. Help posting values to DB on submit using $wpdb->query
  82. WordPress Database Query works in phpMyAdmin but not in the code
  83. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  84. Correct and secure way to access a custom SQL database in a custom PHP template file
  85. Using $wpdb to insert data into a table
  86. How To connect to the same WordPress database with different database user
  87. Accessing content from third party as native posts in WordPress
  88. Call to a member function insert()
  89. I have include wp-config, should I add global $wpdb also?
  90. Processing a lot of $wpdb isn’t insert all the data
  91. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  92. How can I retrieve data from alternate database using wpdb class?
  93. Pulling values from a sepcific row in table
  94. Creating Tables in WordPress Database
  95. Inserting into data into external DB using WPDB
  96. Insert Extra fields added in the front end registration form to DB
  97. How to use remote db tables in current config? [duplicate]
  98. $wpdb->insert not working for last select option
  99. $wpdb->prepare returns empty array
  100. Uploading to WordPress Database