Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

网站数据库是什么?应该不是mysql吧? #53

Closed
ryuusennka opened this issue Sep 26, 2023 · 1 comment
Closed

网站数据库是什么?应该不是mysql吧? #53

ryuusennka opened this issue Sep 26, 2023 · 1 comment

Comments

@ryuusennka
Copy link

请问该练习网站的数据库是什么?

select datetime() as 'datetime'

http://sqlmother.yupi.icu/#/learn 上面运行没有问题,

在我本地 mysql:5.7.36 上面执行报错,提示

select datetime() as 'datetime'
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() as 'datetime'' at line 6
> Time: 0.001s

而换成

select CURRENT_TIMESTAMP as 'datetime';

则可以得的到期待的

datetime
2023-09-26 16:15:15
@htfc786
Copy link
Contributor

htfc786 commented Oct 5, 2023

数据库不是MySQL,是使用前端sql.js实现的,具体请看:https://github.com/liyupi/sql-mother#3%E7%BA%AF%E5%89%8D%E7%AB%AF-sql-%E6%89%A7%E8%A1%8C

@liyupi liyupi closed this as completed Jun 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants