Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 23:42

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Question] Query For Tables

Discussion on [Question] Query For Tables within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2010
Posts: 177
Received Thanks: 11
[Question] Query For Tables

i want a query to get the last lines or ID added in the table
Little Messi is offline  
Old 01/24/2015, 07:07   #2
 
Snow*'s Avatar
 
elite*gold: 1
Join Date: Nov 2011
Posts: 2,532
Received Thanks: 1,440

order by ColumnName
Snow* is offline  
Old 01/24/2015, 07:12   #3
 
elite*gold: 0
Join Date: Mar 2010
Posts: 177
Received Thanks: 11
why don't u just give a straight answer, i wouldn't be posting here if i can't find it any where else -_-
Little Messi is offline  
Old 01/24/2015, 09:46   #4


 
​Exo's Avatar
 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
What kind of ID?

If it's an ID that increases on each insert then obviously the last ones are the bigger ones
​Exo is offline  
Old 01/24/2015, 11:33   #5
 
Zodiao's Avatar
 
elite*gold: 0
Join Date: Aug 2012
Posts: 748
Received Thanks: 227
Code:
SELECT TOP 1 * FROM TABLE_NAME order by [ID] desc
Zodiao is offline  
Reply


Similar Threads Similar Threads
A question about sql tables (Unique kill per player)
11/24/2012 - SRO Private Server - 2 Replies
Hello. what is the name of table where appears the amount of unique kill per player?:confused: thanks
Question About Tables
07/26/2012 - SRO Private Server - 0 Replies
I Want Know What Tables For All Teleports ?
Question about query
06/11/2012 - SRO Private Server - 11 Replies
Well I got this query from epicsoul but cant get it work I must change AssocFile256 = 'xxx' to AssocFile256 = 'c:\regioninfo.txt' But when I change nothing happened.Refregion table is still clean.How can I get it work USE GO <-- for epvpers from epicsoul :)--->
Query Question!!!
12/22/2010 - EO PServer Hosting - 1 Replies
we can use 1077 as MYSQL command and data as 5 so we can SELECT name FROM cq_user WHERE id=1000000 and we can use 101 and %iter_var_data5 so we can see the result but the problem is the %iter_var_data << can handle only numbers so it's always giving me a ruslt of 0 is there a way to get a value of text from aonther table i hope you got it!!?
SQL query question
05/09/2010 - Shaiya Private Server - 1 Replies
Lock this or delete lol i found my answer :)



All times are GMT +1. The time now is 23:43.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.