Diegar Posted September 23, 2007 Report Share Posted September 23, 2007 I am new to MySQL, so my question is... Is it possible to insert an array into MySQL? Like have multiple values in one cell on a row for a single field? Link to comment Share on other sites More sharing options...
justsomeguy Posted September 24, 2007 Report Share Posted September 24, 2007 No, each field only has a single value, complex data types aren't allowed in fields.http://dev.mysql.com/doc/refman/5.0/en/data-types.html Link to comment Share on other sites More sharing options...
Diegar Posted September 24, 2007 Author Report Share Posted September 24, 2007 No, each field only has a single value, complex data types aren't allowed in fields.http://dev.mysql.com/doc/refman/5.0/en/data-types.html Thank you! Link to comment Share on other sites More sharing options...
Synook Posted September 29, 2007 Report Share Posted September 29, 2007 Well, you could create a pseudo-array (i.e. comma-delimited) and just split it up after you retreive it (e.g. in PHP using explode() ) and implode() it when storing again. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now