updating record in mysql

2 次查看（过去 30 天）

Maruthi Maruthi 2017-8-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/353066-updating-record-in-mysql

评论： Maruthi Maruthi 2017-8-21

In the above code, it is executing with out showing errors but the record is not update in the database.

function Reg_pwd_gen(uname1)
mm = floor(1000+(rand()*8999));
conn = database('mani','root','MARUTHI');
tablename='user2';
colnames = {'pwd'};
data={'mm'};
whereclause={'WHERE uname = ''{uname1} '''};
update(conn,tablename,colnames,data,whereclause);
commit(conn);
close(conn);
Reg_pwd = uicontrol('Style','text','FontSize',10,'FontWeight','bold',...
  'Position',[10 500 200 50],...
  'String','Please Remember the Password for Authention. ')
pwd1= uicontrol('Style','edit','FontSize',12,'FontWeight','bold',...
  'Position',[550 500 100 60],...
  'String',mm)
  % code
end

Please help me for my project and also send me the reply as early as posssible.

7 个评论
显示 5更早的评论隐藏 5更早的评论

Guillaume 2017-8-18

编辑：Guillaume 2017-8-18

I did not say you were wrong. I said we don't know. So, for the 3rd time, please run a SELECT * query with the exact same WHERE clause. If it returns records, then we know you're not wrong and we can start looking for other issues. If it returns nothing, then we can start seeing what is wrong with your WHERE.

Maruthi Maruthi 2017-8-21

thank you sir. can you please provide the syntax of update command if the data store in some other variable and at the same time where clause value also points to the value in the variable. i.e., data=mm; %uname=uname1; uname1 has some data. update (conn,'user2','pwd',data, where uname=uname1); is this correct?

请先登录，再进行评论。

请先登录，再回答此问题。