I'm new to databases and have a couple of doubts

1. I created a database with MySQL. it has a few fields but I started with an incremental numeric ID, even though I do not need it. It is a static database used only for a search facility.

Is it necessary to have that numeric ID or can I simply get rid off it?

2. 3 of the fields are meant to have a yes/no content. When I tried to access the database I got a "0". What do I have to do? I have them as tinyint(1), Null (yes), Default...


Poster :