博文背景
MySQL中有values和value两个玩意,很多博客喜欢比较它们的区别,那么它们到底有什么区别呢?
具体操作
VALUE is a synonym for VALUES in this context. Neither implies anything about the number of values lists, nor about the number of values per list. Either may be used whether there is a single values list or multiple lists, and regardless of the number of values per list.
其实两者除了拼写有区别外其实压根没有区别的啦,上面是官网的描述,两个是同义词。
官网链接:https://dev.mysql.com/doc/refman/8.0/en/insert.html
进去过后 Ctrl + F 搜索一下synonym
就可以了。