~ overflow ~

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.

Leave a Comment :, , more...

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);

Leave a Comment :, , , , , more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!