请解决此问题 [英] Please Resolve this Issue

问题描述

37 Futuresoft Baterry，HDD，Active 5/2/2014 9945678958 [e-mail] Okhla Okhla阶段111

38未来印度硬盘，操纵杆，笔记本电脑屏幕，活动4/28/2014 9971269129 [e-mail]诺伊达诺伊达

39 Tech_M Baterry，笔记本电脑屏幕，鼠标，活动4/29/2014 9945678955 [e-mail]诺伊达诺伊达

46 dgd Baterry，硬盘，操纵杆，Active 5/3/2014 9945678958 [e-mail]

NULL NULL NULL NULL NULL NULL NULL NULL NULL

我有一个如上所述的数据库。这里的产品用逗号分隔。我在会话中有一个产品名称。我将如何检查我的会话值是否存在于产品列表中。请帮忙。

37 Futuresoft Baterry,HDD, Active 5/2/2014 9945678958 [e-mail] Okhla Okhla phase 111
38 Future India HDD,joystick,Laptop Screen, Active 4/28/2014 9971269129 [e-mail] Noida Noida
39 Tech_M Baterry,Laptop Screen,Mouse, Active 4/29/2014 9945678955 [e-mail] Noida Noida
46 dgd Baterry,HDD,joystick, Active 5/3/2014 9945678958 [e-mail]
NULL NULL NULL NULL NULL NULL NULL NULL NULL
I have a database as above. here the Products are separated by comma. I have an product name in session. how will i check whether my session value is present in the product lists or not. please help.

推荐答案

基本上，不要。

这是一个非常糟糕的设计理念 - 你应该使用单独的表：一个用于您拥有的行（少于逗号分隔列），一个用于逗号分隔的项目（每行一个带有ID），第三个用于将它们链接在一起：

Basically, don't.
It's a very bad design idea - you should be using separate tables: one for the rows you have (less the comma separates column), one for the comma separated items (one per row with an ID), and a third to link them together:

37	Futuresoft	Active	5/2/2014	9945678958	[e-mail]	Okhla	Okhla phase 111
38	Future India	Active	4/28/2014	9971269129	[e-mail]	Noida	Noida
39	Tech_M	Active	4/29/2014	9945678955	[e-mail]	Noida	Noida
46	dgd	Active	5/3/2014	9945678958	[e-mail]	
NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL

1       Baterry
2       HDD
3       joystick
4       Laptop Screen
5       Mouse

37      1
37      2
38      2
38      3
38      4
...

然后，您可以非常简单地添加，删除或检查线索。

SQL不擅长字符串操作，像你这样的数据库设计会带来很多问题，浪费了大量的时间和资源。

You can then add, delete, or check vlues very simply.
SQL is not good at string manipulation, and a database design like yours gives enormous problems and wastes a lot of time and resources.

这篇关于请解决此问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！