从MySql仅选择年份 [英] Select only year from MySql

问题描述

我只需要从记录日期中选择年份.

I need to select only the year from the record date.

SELECT *, DATE_FORMAT('release','%Y') AS release_year FROM books

但不起作用. phpmyadmin中的结果为NULL.

but doesnt work. The result in phpmyadmin is NULL.

推荐答案

SELECT *, YEAR(`release`) AS release_year FROM books

我认为release是MySQL关键字.尝试将其包裹在``

I think release is a MySQL keyword. Try to wrap it around ``

这篇关于从MySql仅选择年份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！