updating record in mysql
2 views (last 30 days)
Show older comments
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 Comments
Guillaume
on 18 Aug 2017
Edited: Guillaume
on 18 Aug 2017
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.
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!