是“日期"吗? mysql中的关键字? [英] Is "Date" a keyword in mysql?

问题描述

我正在尝试使用更新查询来更新名为日期"的列，如下所示. UPDATE db1 SET Date ='20130304'WHERE Date ='3/4/2013';

I am trying to update a column, named 'Date' using an update query as follows. UPDATE db1 SET Date = '20130304' WHERE Date = '3/4/2013';

但是更新没有发生.是日期"在MySQL中的关键字吗?如果是，那么如何将其包括在查询中，以便将其视为变量而不是MySQL的关键字.

But the update is not taking place. Is "Date" a keyword in MySQL? If yes, then how to include it in a query so that it gets treated as a variable instead of as a keyword of MySQL.

推荐答案

日期是mysql中的关键字

Date is a keyword in mysql

UPDATE db1 SET Date = '20130304' WHERE Date = '3/4/2013';

应该是

UPDATE db1 SET `Date` = '20130304' WHERE `Date` = '3/4/2013';

这篇关于是“日期"吗? mysql中的关键字?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！