搞不懂了,数据库数据查询有关问题
程序员文章站
2022-05-15 16:14:08
...
搞不懂了,数据库数据查询问题。
搞不懂了,数据库数据查询问题。
数据库设计如下
l1 l2 l3 l4 l5 l6 dqs jqs zqs firstarea secondarea thirdarea ac
"1","1","2","3","4","5","6","21","0","3","4","6","0","0","0"
"2","1","2","3","4","5","7","22","0","4","5","6","0","0","1"
"3","1","2","3","4","6","7","23","0","3","4","6","0","0","1"
"4","1","2","3","5","6","7","24","0","4","5","6","0","0","1"
"5","1","2","4","5","6","7","25","0","3","4","6","0","0","1"
"6","1","3","4","5","6","7","26","0","4","4","6","0","0","1"
"7","2","3","4","5","6","7","27","0","3","4","6","0","0","0"
"8","1","2","3","4","5","8","23","0","3","4","6","0","0","2"
"9","1","2","3","4","6","8","24","0","2","3","6","0","0","2"
"10","1","2","3","5","6","8","25","0","3","4","6","0","0","2"
"11","1","2","4","5","6","8","26","0","2","3","6","0","0","2"
"12","1","3","4","5","6","8","27","0","3","3","6","0","0","1"
想根据已有条件选出来l1,l2,l3,l4,l5,l6的号码,设计了一张大表,包涵全部数据信息。。。
如,根据顾客利用表单提交的dqs,jqs,zqs,firstarea,secondarea,thirdarea等信息的值,挑选出l1到l6的号码都有什么。请问查询语句如何设计,还有表单的输入信息,如何传递给查询语句进行查询?
搞不懂了,数据库数据查询问题。
数据库设计如下
l1 l2 l3 l4 l5 l6 dqs jqs zqs firstarea secondarea thirdarea ac
"1","1","2","3","4","5","6","21","0","3","4","6","0","0","0"
"2","1","2","3","4","5","7","22","0","4","5","6","0","0","1"
"3","1","2","3","4","6","7","23","0","3","4","6","0","0","1"
"4","1","2","3","5","6","7","24","0","4","5","6","0","0","1"
"5","1","2","4","5","6","7","25","0","3","4","6","0","0","1"
"6","1","3","4","5","6","7","26","0","4","4","6","0","0","1"
"7","2","3","4","5","6","7","27","0","3","4","6","0","0","0"
"8","1","2","3","4","5","8","23","0","3","4","6","0","0","2"
"9","1","2","3","4","6","8","24","0","2","3","6","0","0","2"
"10","1","2","3","5","6","8","25","0","3","4","6","0","0","2"
"11","1","2","4","5","6","8","26","0","2","3","6","0","0","2"
"12","1","3","4","5","6","8","27","0","3","3","6","0","0","1"
想根据已有条件选出来l1,l2,l3,l4,l5,l6的号码,设计了一张大表,包涵全部数据信息。。。
如,根据顾客利用表单提交的dqs,jqs,zqs,firstarea,secondarea,thirdarea等信息的值,挑选出l1到l6的号码都有什么。请问查询语句如何设计,还有表单的输入信息,如何传递给查询语句进行查询?
- PHP code
我的想法 如下条件要同时满足
相关文章
相关视频
上一篇: C-Sharpcorner
推荐阅读
-
有关数据库SQL递归查询在不同数据库中的实现方法
-
oracle数据库查询没问题,正常显示两个汉字;但是java后台Hibernate查询的时候只显示第一个汉字怎么解决?
-
Android中的SQL查询语句LIKE绑定参数问题解决办法(sqlite数据库)
-
Mysql解决数据库N+1查询问题
-
数据库查询中遭遇特殊字符导致问题的解决方法
-
Oracle数据库中查询结果集中保留两位小数的问题
-
sql数据库查询结果字段包含换行符导致复制到Excel发生错位问题的解决
-
数据库~Mysql派生表注意的几点~关于百万数据的慢查询问题
-
有关mysql数据库中文排序问题
-
数据库分库分表和带来的唯一ID、分页查询问题的解决