|
Posted by Jerry Stuckle on 02/23/06 21:39
monomaniac21 wrote:
> Thanks noone, how can you convert a text field into an array? or how
> can you create an array field in mysql?
>
You don't create an array field in MySQL. Rather, you create a second
table with a one-to-multiple linkage.
In this case you would have two columns - id and numval (or a more
appropriate name for whatever you're using it for). id would match the
id in the first table. numval would hold one value in each row. So,
you might end up with something like:
id numval
4 1
4 1.2
4 4
4 5.6
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|