Archive for September 15th, 2009
Filename vs Folder Linux ext2 Note
by z3n on Sep.15, 2009, under Notes, Tips & Hints
No, you can’t have a filename and a folder with the same name on the same folder.
For example:
/path/to/happy
/path/to/happy/
Will not work. If happy is a regular file and you try to create a folder called happy (and vice-versa) at ‘/path/to’ you will fail.
Note that this amazingly works on windows.
Reset Auto Increment
by z3n on Sep.15, 2009, under Tips & Hints
Problem:
How to reset a auto_increment / identity value on a table?
Solution:
MySQL: alter table tablename auto_increment=1234;
MSSQL: dbcc checkident(‘tablename‘,RESEED,1234);