I want to build my first tables and wonder:
1) can table/field names have white spaces and unlimited number of characters?
2) I call the table 'einheiten'. This table has about 25 fields which I?ve already created. I defined only one field as the primary key: 'id-key'. However, when creating the fields I left default settings like 'TINYINT'. When I changed this for the 'key' field to 'TINYTEXT' and it became a Primary Key, I didn't put any atention to this. However, when defining the 'logo' field as 'BLOB', it became Primary Key too, and when defining another field as 'TEXT', it became Primary as well.
I thought I should have only one Primary Key for each table.
Thank you in advance