Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Access表插入新表行记录，表名带下划线，启动提示表名不合法 #181

Closed
bodian520 opened this issue Dec 28, 2020 · 1 comment
Closed

Access表插入新表行记录，表名带下划线，启动提示表名不合法 #181

bodian520 opened this issue Dec 28, 2020 · 1 comment
Labels
Document 文档 文档 Question 使用问题 使用问题

Comments

@bodian520
Copy link

环境信息

  • 系统:
  • JDK:
  • 数据库:
  • APIJSON:

问题描述

https://my.oschina.net/tommylemon/blog/889074

1.按照该文档，在ACCESS表插入一行，原始表名为‘t_task’，插入行记录name或者alias='t_task'，启动报错，提示表名不合法，
但是't_task'应该是mysql的合法表名

错误信息
@TommyLemon
Copy link
Collaborator

请求 JSON 参数 和 Access 表中 APIJSON 表名都以大写字母开头
https://github.com/Tencent/APIJSON/blob/master/Document.md#3.1
image

数据库实际表名则不一定，因为 MySQL 默认大小写不敏感，大写小写都对，如果是 PostgreSQL 这种大小写敏感的，可以配置 alias

@TommyLemon TommyLemon mentioned this issue Dec 31, 2021
Open
@YaphetSLuu YaphetSLuu mentioned this issue May 14, 2022
Closed
@hahahamingF hahahamingF mentioned this issue Jul 14, 2022
Closed
@zhouyoutian zhouyoutian mentioned this issue Oct 22, 2022
Closed
@jundaodao jundaodao mentioned this issue Nov 23, 2022
Closed
@TommyLemon TommyLemon mentioned this issue Jan 29, 2023
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Document 文档 文档 Question 使用问题 使用问题
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@TommyLemon @bodian520