Support for vectors

[Daniel Feiglin]

I need to do something like this:

create table cards (
< some unique id stuff>
count int, # 0 - 99
results int[] # All 0 - 99 Permitted syntax under PostgreSQL
);

Other than stuffing a varchar with two byte ascii numbers (or similar) is there some kind of array syntax in MySQL version 4.0.18 or higher?

If not, does anyone know if support for arrays is even planned?

1. Apropos the app, it's not practicable to create records, each having one integer result, as someone has already suggested. The table is a fairly volatile transaction file with entries going in and out all the time. As it is there will be 10's of 1000's of these records floating around, so a neat solution is needed.
2. SQL conformance and all that - I don't care. It's got to work.