如何在SQL字段中处理数组？
如何在SQL字段中处理数组？
I have a feed that comes from the State of Florida in a CSV that I need to load daily into MySQL. It is a listing of all homes for sale in my are
a. One field has a list of codes, separated by commas. Here's one such sample:
如何填志愿
ps抠图教程C02,C11,U01,U02,D02,D32,D45,D67
These codes all mean something (pool, fenced in area, etc) and I have the meanings in a separate table. My question is, how should I hand le loading these? Should I put them in their own field as they are in the CSV? Should I create a separate table that holds them?
If I do leave them as they are in a field (called feature_codes), how could I get the descriptions out of a table that has the descriptions? That table is simply feature_code, feature_code_description. I don't know how to break them apart in my first query to do the join to bring the des cription in.
Thank you
什么是网络营销
图⽚转代码服务由CSDN问答提供功能建议理科专业排名
我有⼀个源⾃佛罗⾥达州的CSV，我需要每天加载到MySQL中。这是我所在地区所有待售房屋的清单。⼀个字段有⼀个代码列表，以逗号分隔。这是⼀个这样的样本：
重阳节发朋友圈的说说C02，C11，U01，U02，D02，D32，D45，D67
这些代码都意味着什么（池，围栏等），我在⼀个单独的表中有意义。我的问题是，我应该如何处理这些？我应该将它们放在⾃⼰的字段中，因为它们在CSV中吗？我应该创建⼀个单独的表来保存它们吗？一首超好听的英文歌
如果我将它们保留在字段中（称为feature_codes），我怎样才能从具有该字段的表中获取描述说明？该表只是feature_code，feature
_code_description。我不知道如何在我的第⼀个查询中将它们分开以进⾏连接以使描述进⼊。
谢谢

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。