This is an automated archive.

The original was posted on /r/mysql by /u/kthomas360 on 2023-11-29 17:33:48+00:00.

I’m trying to replicate a type of table I’ve seen in use before… though I’ve never actually built one. The table has a row for each attribute (as opposed to a column).

My usual data:

Name          Address                   City           State           Zip

Bill Gates     123 Windows Ave Seattle      WA          90210

I’ll be dealing with a lot of attributes, more than MySQL can handle, so I know I’ve got to stack the attributes on top of one another like so:

fieldid fieldname fieldtext

1 name Bill Gates

2 address 123 Windows Ave

3 city Seattle

4 state WA

5 zip 90210

Is there a site that can walk me through being able to use this type of table within CRUD? Is there another name this goes by? Searching for “mysql stacked data” gave me a lot of results that I didn’t need.