can you group tables in MySQL?

[ibnpaul]

Hi all,

This may sound odd, but I want to store a table within a table field in MySQL, for example have a table that has configuration values stored in one field, in another table. Is this possible? Any ideas if not? Thanks.

[guelphdad]

well you could store it in a blob or text field, but you would be defeating the purpose of a relational database since you wouldn't be able to access any info from it.

why don't you tell us what exactly it is you are trying to do and we could offer a solution that will be best for you.

[GJay]

Not really, no.

There exist 'schemas' (in certain database systems, postgres being one) that are kind-of like 'namespaces', so you can group tables.
The default is 'public', and can be omitted when referring to the table, others are then referred to with dot-notation, e.g. company1.invoices.

This isn't really appropriate for what you're asking though.

Perhaps if you expanded on what you want to do, we can try and suggest the best way of doing it?