ERROR 1064 (42000) at line 15: 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 '{},

[yuqianglianshou]

你好作者，我在执行 mysql --user=root -p < schema.sql 时报了错误：ERROR 1064 (42000) at line 15: 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 '{}, 经验证，是schema.sql 文件中第17行代码导致的 ：round JSON default {}, 我不懂sql语句，互联网也没有查到与之相关错误信息，请作者帮忙分析一下，谢谢。

[mailgyc]

应该是版本问题，试一下MySQL 8.0版本

On Jan 3, 2023, at 00:35, 劉清揚 @.***> wrote:

你好作者，我在执行 mysql --user=root -p < schema.sql 时报了错误：ERROR 1064 (42000) at line 15: 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 '{}, 经验证，是schema.sql 文件中第17行代码导致的 ：round JSON default {}, 我不懂sql语句，互联网也没有查到与之相关错误信息，请作者帮忙分析一下，谢谢。

— Reply to this email directly, view it on GitHubhttps://github.com/mailgyc/doudizhu/issues/39, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA7TWXHDDWYRPX73VJO5RVDWQL7WLANCNFSM6AAAAAATO6N65Y. You are receiving this because you are subscribed to this thread.Message ID: @.***>

[wu5bocheng]

MySQL 5.7 introduced the JSON datatype, which matches your syntax.