开发者

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.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜