Raised This Month: $ Target: $400
 0% 

Mysql update AUTO_INCREMENT id.


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
w2zzaaa
Junior Member
Join Date: Feb 2010
Old 11-04-2013 , 17:40   Mysql update AUTO_INCREMENT id.
Reply With Quote #1

...

Last edited by w2zzaaa; 11-09-2013 at 17:16.
w2zzaaa is offline
YamiKaitou
Has a lovely bunch of coconuts
Join Date: Apr 2006
Location: Texas
Old 11-04-2013 , 17:43   Re: Mysql update AUTO_INCREMENT id.
Reply With Quote #2

Why do you need to add another column? It is already tracking the SteamID.
__________________
ProjectYami Laboratories

I do not browse the forums regularly anymore. If you need me for anything (asking questions or anything else), then PM me (be descriptive in your PM, message containing only a link to a thread will be ignored).
YamiKaitou is offline
Old 11-04-2013, 18:24
w2zzaaa
This message has been deleted by w2zzaaa.
mottzi
Veteran Member
Join Date: May 2010
Location: Switzerland
Old 11-05-2013 , 13:16   Re: Mysql update AUTO_INCREMENT id.
Reply With Quote #4

explain bether what you want to do.
mottzi is offline
Send a message via MSN to mottzi
Backstabnoob
BANNED
Join Date: Feb 2009
Location: Iwotadai Dorm
Old 11-05-2013 , 13:37   Re: Mysql update AUTO_INCREMENT id.
Reply With Quote #5

I have no idea what you're saying, but if you need the id of the latest record added to the database, use SQL_GetInsertId. This will only give you the latest id of a row added by the handle of the plugin, so it will return something you don't want after you restart the server. To make it consistent, you will have to run a SELECT query, such as
Quote:
SELECT id FROM table ORDER BY id DESC LIMIT 0,1
Backstabnoob is offline
Old 11-05-2013, 13:37
w2zzaaa
This message has been deleted by w2zzaaa.
Backstabnoob
BANNED
Join Date: Feb 2009
Location: Iwotadai Dorm
Old 11-05-2013 , 13:39   Re: Mysql update AUTO_INCREMENT id.
Reply With Quote #7

If you think these are stupid questions then you should probably figure out that your English and ability to explain the problem are severely lacking.
Backstabnoob is offline
Old 11-05-2013, 14:00
w2zzaaa
This message has been deleted by w2zzaaa.
mottzi
Veteran Member
Join Date: May 2010
Location: Switzerland
Old 11-05-2013 , 14:23   Re: Mysql update AUTO_INCREMENT id.
Reply With Quote #9

no, just explain bether (other words, other example) what your approach is. I dont understand what you want...
mottzi is offline
Send a message via MSN to mottzi
Old 11-05-2013, 14:47
w2zzaaa
This message has been deleted by w2zzaaa.
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 23:21.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode