sql-mother icon indicating copy to clipboard operation
sql-mother copied to clipboard

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

Open ryuusennka opened this issue 1 year ago • 1 comments

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

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

ryuusennka avatar Sep 26 '23 08:09 ryuusennka

数据库不是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

htfc786 avatar Oct 05 '23 02:10 htfc786