How do I store XML data into a mysql database? I don't want foreign keys like crazy

data-structures, database, mysql, xml

Solution

The "regular" way is to store XML in a CLOB (Character Large Object) and MySQL supports CLOB with 4 data types:

- TINYTEXT - A CLOB column with a maximum length of 255 (2**8 - 1) characters.

- TEXT - A CLOB column with a maximum length of 65,535 (2**16 - 1) characters.

- MEDIUMTEXT - A CLOB column with a maximum length of 16,777,215 (2**24 - 1) characters.

- LONGTEXT - A CLOB column with a maximum length of 4,294,967,295 or 4GB (2**32 - 1) characters.

Using one or the other depends on your needs.

Problem

Original source