Database w/multiple tables and IDs

I'm am just learning MySQL and SQL for that matter. If have create multiple tables
within (1) database, the Identifers (ID) for
each record in each table, do they all have to be different?

For example, if I call the a database with
(2) tables, one table called 'shoes' and
the other called 'tshirts'.

Is the ID in each table independent of each
other? Can I have an ID of 1 for a record
in 'shoes', and also have am ID of 1 for
a record in 'tshirts'?

I really appreciate if anyone can help me answer this?

Thanks

Joe

Yes.
When there are only a small amount of tables just using ID won't be too confusing but creating IDshirt and IDshoes would be a sensible design if the databse ever grew into one with hundreds of tables.

Andy J

Thanks Andy, alot!


<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by eaamj01:
Yes.
When there are only a small amount of tables just using ID won't be too confusing but creating IDshirt and IDshoes would be a sensible design if the databse ever grew into one with hundreds of tables.

Andy J[/quote]