a125366161的专栏

MySQL日期时间函数大全                                       DAYOFWEEK(date) 　返回日期date是星期几(1=星期天,2=星期一,……7=星期六,ODBC标准) mysql> select DAYOFWEEK('1998-02-03'); 　　-> 3 WEEKDAY(date) 　返回日期date是星期几(0=星

关联两表删除两表内容 delete t1,t2  from t_pic as t1 left join t_pic_muc_comments as t2 on t1.pmcid=t2.pmcid  where t1.pid=1

原因没有打开root的权限 在窗口运行下面指令 grant all privileges on *.* to 'root'@'%'identified by '';     flush privileges;     //刷新