coffeecup Posted January 17, 2010 Share Posted January 17, 2010 I am looking at a 7 item, line item, character storage for up to 300 clients. should i break that up to 7 tables, one table for each line item. or would i be insane to place item_1 through item_7 in one table with a char (250). current MySQL V = 5.1.37 and will upgrade to most recent V when i go online. Thank you Quote Link to comment https://forums.phpfreaks.com/topic/188738-preliminary-table-set-up/ Share on other sites More sharing options...
ignace Posted January 17, 2010 Share Posted January 17, 2010 item_1 through item_7 in one table is bad design. Give us some more details and I may help you normalize your database. Quote Link to comment https://forums.phpfreaks.com/topic/188738-preliminary-table-set-up/#findComment-996526 Share on other sites More sharing options...
coffeecup Posted February 6, 2010 Author Share Posted February 6, 2010 item_1 through item_7 in one table is bad design. Give us some more details and I may help you normalize your database. Thank you, i went back read and re read many times the normalization and made seven tables. Quote Link to comment https://forums.phpfreaks.com/topic/188738-preliminary-table-set-up/#findComment-1008046 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.