与mysql有关的问题 [英] Question related to mysql
问题描述
先生,我的一个医院管理系统在apache Tomcat Manager服务器上运行
我用mySql作为数据库
我上传每个患者的序列号问题是序列号是如果没有2分配给一个病人然后4分配给其他患者我想要没有按顺序分配
我尝试过:
先生我的一个医院管理系统在apache Tomcat Manager服务器上运行
我使用mySql作为数据库
我为每个患者提出序列号没有问题是序列号是跳跃,如果没有2分配给一个病人然后4分配给其他病人我想要没有以连续方式分配
< blockquote>没有你的代码,我们无法确定,但首先要查看你的数据库。如果你的序列没有列没有使用AUTO_INCREMENT: MySQL :: MySQL 5.7参考手册:: 4.6.9使用AUTO_INCREMENT [ ^ ]
如果是,则查看列配置的参数 - 您可能指定了不是1的增量值。
借用此提示 [ ^ ]并使其适应您在Java中的开发。
sir my one hospital management system runnning on apache Tomcat Manager server
and i used mySql for database
I AM GENRATEING SERIAL NO FOR EACH PATIENT problem is serial no is jumping like if no 2 assigend to one patient then 4 assigend to other patient i want no assigned in serial way
What I have tried:
sir my one hospital management system runnning on apache Tomcat Manager server
and i used mySql for database
I AM GENRATEING SERIAL NO FOR EACH PATIENT problem is serial no is jumping like if no 2 assigend to one patient then 4 assigend to other patient i want no assigned in serial way
Without your code, we can't be certain, but start by looking at your DB. If your serial no column isn't using AUTO_INCREMENT than it should: MySQL :: MySQL 5.7 Reference Manual :: 4.6.9 Using AUTO_INCREMENT[^]
If it is, then look at the parameters the column is configured to have - you may have specified an increment value that isn't 1.
Borrow this tip[^] and adapt it to your development in Java.
这篇关于与mysql有关的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!