仅当

You can use double quotes in identifiers only if the ANSI_QUOTES SQL mode is enabled.

SET sql_mode='ANSI_QUOTES';

这里是 SQLFiddle 演示

Here is SQLFiddle demo

否则，如果您的标识符不在保留字列表中，则只需使用反勾号或什么都不用.

Otherwise just use back ticks or nothing at all if your identifiers are not in a reserved words list.

CREATE TABLE `login` (
  `IdUser` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(45) CHARACTER SET latin1 NOT NULL,
  `pass` varchar(45) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`IdUser`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
;

CREATE TABLE `photos` (
  `IdPhoto` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET latin1 NOT NULL,
  `IdUser` int(11) NOT NULL,
  PRIMARY KEY (`IdPhoto`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
;

这里是 SQLFiddle 演示

Here is SQLFiddle demo

进一步阅读架构对象名称