Linkage
Visual Studio Debugging of Websites
One of the annoyances in Visual Studio with web based projects is that if you stop debugging or choose "view in browser", it's a couple of clicks to attach the Debugger, until Microsoft implement an option that offers the associated WebDevServer as the preferred choice to Attach to in these scenarios, this Visual Studio macro will do the job nicely!
MySQL Identity (Auto-increment) column values
Found here, the easiest way to reset the identity value on a column in a MySQL database table is:
ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234
It's also interesting to note that the link claims (not checked!) that DELETE FROM theTableInQuestion will reset the identity but DELETE FROM theTableInQuestion WHERE Column=x won't, even if this covers all rows in the table.
One of the annoyances in Visual Studio with web based projects is that if you stop debugging or choose "view in browser", it's a couple of clicks to attach the Debugger, until Microsoft implement an option that offers the associated WebDevServer as the preferred choice to Attach to in these scenarios, this Visual Studio macro will do the job nicely!
MySQL Identity (Auto-increment) column values
Found here, the easiest way to reset the identity value on a column in a MySQL database table is:
ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234
It's also interesting to note that the link claims (not checked!) that DELETE FROM theTableInQuestion will reset the identity but DELETE FROM theTableInQuestion WHERE Column=x won't, even if this covers all rows in the table.
