optimism Posted December 2, 2008 Share Posted December 2, 2008 Hi i am new and wish your help .. i can not really update the tables in the MYSQl after i created them first time ... maybe the problem is in the permission & the role .. but really it dosen't work with me any one can help me to the right way to set the permission .. Quote Link to comment Share on other sites More sharing options...
Cosizzle Posted December 2, 2008 Share Posted December 2, 2008 information on your query is nice... but an update query should be UPDATE table_name SET column1=value, column2=value2 WHERE some_column=some_value Quote Link to comment Share on other sites More sharing options...
crtreedude Posted December 6, 2008 Share Posted December 6, 2008 If you are having a problem updating tables due to permissions, look at the GRANT command. This should help. A way to isolate and to to this is the problem is to see if you update command works just fine if you are the dbo (database owner) - if it works for the dbo, but not for a user, then it is very possible you have a permission issue, which can be solved by granting permissions with the GRANT command. hope it helps Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.