Re: Array Type.

[Christian Mack]

"ÇãÁ¤¼ö" wrote:
> 
> Does MySQL support Array?
> 
> e.x) score INT[1]
> 
> I cannot find about array in Manual.
> 
> Can I use SET instead of array?
> 
> Please, give me some example creating Table with SET type.
> 
> and, inserting that table
> 
> Thanks A LOT

Hi

MySQL as all SQL92 DBMS does NOT support arrays as column type.

To use SET for arrays will NOT work.

CREATE example:
CREATE TABLE setTable ( pimitive SET('one','two','four','eight') );

INSERT example:
INSERT INTO
	setTable
VALUES
	('two')
	,('one,four')
	,('two,four,one')
	,('eight,two');

Tschau
Christian