Loving this series so far. Great information and wonderfully presented. Thank you for providing links to the documentation as well. That really helps as I take notes.
Hi Steve, I'm loving the course. I think you're wrong about what tinyint(1) does though. My understanding is tinyint = 1 byte of data (-128 to 127). The 1 in parens specifies the display width, not the number of bits.
You can change the next available value for the auto increment but if you set it back to a value from a gap then it will fail when it reaches a conflict with an existing value.
Loving this series so far. Great information and wonderfully presented. Thank you for providing links to the documentation as well. That really helps as I take notes.
love shit this guy does
Awesome video!
Hi Steve, I'm loving the course. I think you're wrong about what tinyint(1) does though. My understanding is tinyint = 1 byte of data (-128 to 127). The 1 in parens specifies the display width, not the number of bits.
What you wrote is correct. tinyint does cover the range -128 to 127 OR 0 to 255 if unsigned.
If I said or implied otherwise I misspoke. Thanks.
is it possible to reset an auto incrementer? or to fill up space that has been deleted before.
You can change the next available value for the auto increment but if you set it back to a value from a gap then it will fail when it reaches a conflict with an existing value.