java - 无法删除、更改、更改...列名称 'number of shares' 带空格

Question

我从access导入了一个数据库到mysql，但其中一个表的列名“股数”带有空格，但我尝试更改、替换甚至删除列名，但失败了。任何人都可以帮助解决这一问题

String UpdateQuary = "UPDATE master SET trn_date=?,account_master=?,"
        + "title=?,first_name=?,sir_name=?,sex=?,birth_date=?,marital_status=?,"
        + "highest_educ_level=?,home_parish=?,centre=?,hiika=?,mobile1=?,"
        + "mobile2=?,email=?,kampala_residence=?,occupation=?,employer=?,"
        + "category_of_membership=?,"
        + "value_of_shares =?,number of shares=?";

Answer 1

您需要使用反引号转义该列:

update master set `number of shares` = 100 where user_id = 3;

例如。如果您可以在项目中避免重命名该列，我建议您只重命名该列。

编辑要重命名，请尝试以下操作:

alter table master change `number of shares` number_of_shares int(11);