I'm using InnoDB with foreign keys for my mysql tables, and I have a many-many situation (I think?) where many hosts can have many payment methods and many payment methods can have many hosts.. so I created my table structure like this:
I have 2 hosts in table 1 (test data to finish building my CRUD)..
When I go to insert a row using phpmyadmin, say for Table 2 host_id - the drop-down box gives me the options of either...
I was wondering if anybody could quickly explain which one I should be using in this instance? and if I should be altering my INSERT query to accomodate whichever one I should use? Does it even matter?
Just a little bit confused at the min, any help appreciated