如何为此表创建计算字段？

Question

SELECTbook.BookTitle,author.Name,author.Surname,book.YearofPublicationFROMbookLEFTJOINauthorONbook.AuthorID=author.AuthorID;在此处输入图像描述这是我当前的表格，我需要创建一个计算字段来告诉我这本书已经出版了多少年，但我的大脑已经崩溃了。有人可以帮忙吗？我尝试过使用xaamp查

P粉288069045 · Answer

试试这个：

SELECT book.BookTitle, author.Name, author.Surname, book.YearofPublication , YEAR(NOW()) - book.YearofPublication
FROM book
LEFT JOIN author ON book.AuthorID = author.AuthorID;