Mysql:[Err] 1630

 Mysql错误 [Err] 1630

1. 错误 1630
[SQL]select date_format(now (),'%Y%m%d');
[Err] 1630 - FUNCTION db.now does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual.

#这是因为select语句中的now函数与括号()分开了,不应该写成now (),而是直接写成now().

#即写成:
select date_format(now(),'%Y%m%d');
# 参考:https://blog.csdn.net/rendeyishi/article/details/25118893

posted on 2019-10-30 10:43  落日峡谷  阅读(1662)  评论(0编辑  收藏  举报

导航