mysql insert Q

[dreams4000]

hi all, just a quick question about mysql...
I have a dynamic table that is generating a 15x15 table kinda like excel. I am wondering if there is any advantage in having each row of that table be an insert in the mysql database (15 inserts with 15 columns) and hooked together somehow... vs just doing one insert with 225 columns. It seems easier to grab the data with simple sql calls with the one database insert, but is there any advantage to the other route? Thanks for any advice!

[nemonoman]

No advantage, and also the possiblity for difficulties that would be difficult to correct. One insert is the better method

[dreams4000]

very cool. this is how I have done it but have heard the other way might be better for the database. Just wanted to get thoughts of everyone to see if there was any advantage the other path. Glad it seems like the one insert is the best way. If anyone else has any thoughts, all open for them. Thanks for the info!🙂