这篇博客介绍了在MySQL数据库作业中遇到的问题和解决方案，包括时间戳差值计算，函数定义的语法，以及在特定查询条件下的顾客线路筛选问题。作者探讨了如何正确处理时间戳相减的结果，并解释了在触发器中更改分隔符以避免歧义。此外，还讨论了尝试处理不确定线路数量时遇到的'缺少END'错误。
keep updating...
the script and document of this assignment can be downloaded from 点击打开链接
And here are notes about problems in this assignment:
Q2.
what format of data will it return if we compute two timestamp data?
so we know that, timestamp is shown as YYYY(year)MM(month)DD(day)HH(hour)MM(month)SS(second).
so if we compute (endTime - startTime) directly, the result will be (endTime(minute) - startTime(minute)) * 100 + (endTime(second) - endTime(second)).
so we should call time_to_sec to change this type of data to the type we want.
Q6.
Here, i'd like to discuss the usage of function.
this is the format of a simple function:
最低0.47元/天 解锁文章
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
