Most importantly signed tells the database to also keep track of negative numbers where unsigned simply keeps track of positive integers. Two's compliment is a common way of handling this in binary. So unless your planning on having negative number primary keys, your essentially wasting half of your avaliable integers hence as Topodian mentioned unsigned gives your PK a bigger range, specifically 2x the range.
Also, the audio is choppy and out of sync for me, in firefox.
this guy sucks!!!
85alexpr 9 months ago
Please re-do this video! Excellent subject but as one other guy said 'Sound needs to be sorted'! I gave up listening
web2stu 11 months ago
Is there a text version of this?
swimdfree 3 years ago
See the 'fusion on Earth' group.
JonThm 4 years ago
Is there a higher quality version of this anywhere?
jtref 4 years ago
sound quality is terrible.
cracksavings 5 years ago
Most importantly signed tells the database to also keep track of negative numbers where unsigned simply keeps track of positive integers. Two's compliment is a common way of handling this in binary. So unless your planning on having negative number primary keys, your essentially wasting half of your avaliable integers hence as Topodian mentioned unsigned gives your PK a bigger range, specifically 2x the range.
Also, the audio is choppy and out of sync for me, in firefox.
roymartin1 5 years ago
Why are you unchecking the UNSIGNED option on primary keys? UNSIGNED gives your Ids a bigger range.
Topodian 5 years ago