TutorialNinja Logo
Forgot Password • Register • Login
PHP 48 Visual Basic 15 Javascript 14 HTML 12 Adobe Photoshop 10
Adobe Fireworks 1 Adobe Photoshop 10 Adobe Illustrator 0 Adobe InDesign 0 Gimp 0
C/C++ 3 Python 1 Visual Basic 15 Visual C# 1
Adobe Dreamweaver 0 Adobe Muse 0 ASP.net 0 .htaccess 6 CSS 5 Perl 0 PHP 48 PHP - User System 2 HTML 12 Java 0 Javascript 14 Ruby on Rails 0 General Web Development 4
CentOS 4 Debian 0 Ubuntu 0 Macintosh 1 Windows 7 Unraid 1
Adobe After Effect 0 Adobe Premiere 0 Adobe Audition 0 Final Cut 0 FruityLoops 0 iMovie 0 Windows Movie Maker 0
Apple Swift 0
Arduino 0 Raspberry Pi 3
ChatGPT 1
Site Statistics
Total Members
525
Total Tutorials
139
Newest User
cucumber2025
Todays Guests
352
0 Users • 8 Guests Online

mySQL question

Posted on Sunday 8th February 2009 at 01:37 AM
Adam981
Adam981's Avatar
is there a way to reset the ID for each user, because of my usersystem i had alot of "testing users" that i deleted so on my member page the user id list is jumped around. rather then 1234567 for my 7 users i have 1, 8, 11, 16, 17, 18, 19.
Posted on Monday 9th February 2009 at 12:00 AM
Nathan
Nathan's Avatar
delete the id and recreate it
Posted on Monday 9th February 2009 at 02:54 AM
Adam981
Adam981's Avatar
i dont want to delete and redo 7 members
Posted on Monday 9th February 2009 at 08:23 PM
setsukemizuhara
setsukemizuhara's Avatar
All you can do to reset the ID column if its auto increment.
Posted on Monday 9th February 2009 at 08:53 PM
Nathan
Nathan's Avatar
yeah thats the only way is to delete the id colum and recreate it
Posted on Tuesday 10th February 2009 at 02:16 AM
Adam981
Adam981's Avatar
Yea shadow helped me out with this, thanks
Login or register to respond to this forum topic.