List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:May 21 1999 6:32pm
Subject:Re: Array Type.
View as plain text  
"ÇãÁ¤¼ö" 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

Thread
Array Type.wertyu21 May
  • Re: Array Type.Christian Mack21 May