Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Python Using Databases in Python Meet Peewee Meet Peewee, Our ORM

Arcee Palabrica
Arcee Palabrica
8,100 Points
Posted by Arcee Palabrica
Arcee Palabrica
8,100 Points

Clarification on Database tables and rows (and columns perhaps)?

So how does tables and rows work? like when Kenneth Love mentioned adding another row when you save? are they like the spreadsheet with rows and columns? I can't seem to get the picture... any help is greatly appreciated... thanks so much

2 Answers

Steve Hunter
Steve Hunter
57,712 Points

Hi there,

Yes, a row is a single record containing the information held within that table. So, for a table of Person, that could be name, address, date of birth etc. One row is one individual. The columns are the lists of one piece of info, e.g. all the dates of birth, or surnames; whatever.

The table as a whole is a list of records/rows of multiple people containing multiple bits of information about each person.

I hope that makes sense ... my painkiller dose is high today so I may be talking nonsense!!

Steve.

Arcee Palabrica
Arcee Palabrica
8,100 Points
Arcee Palabrica
Arcee Palabrica
8,100 Points

Perfect! Thanks man. wow those painkillers are so effective. I might need some of those. ?

Steve Hunter
Steve Hunter
57,712 Points

They're good, yes! :smile:

Glad to help. :+1: