flyDeDog的博客

登录mysql -u mysql -p 或者 mysql -u mysql -p bank # bank是要用的库执行sql脚本source /home/mysql/LearningSQLExample.sql;查看当前时间select now(); 或 select now() from dual; # 为了与oracle兼容常用数据类型...

update时连表https://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sqlANSI/ISO:update ud set assid = ( select sale.assid from sale ...