what are the minimum privileges a user needs in MySQL to use the replace command?
The title is basically the question; what are the minimum privileges a MySQL user needs to use the REPLACE
command? My initial guess is SELECT
, DELETE
, and INSERT
, but I want to make sure that the user doesn't need UPDA开发者_开发技巧TE
as well.
From the manual
http://dev.mysql.com/doc/refman/5.0/en/replace.html
To use REPLACE, you must have both the INSERT and DELETE privileges for the table.
精彩评论