File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Node.js in Action
this week in the
To extract column elements from a particular position onwards "MYSQL"
Joined: Oct 08, 2006
Dec 16, 2006 13:25:00
Hi to everyone,
I want to extract column elements from a particular position .
here i want to have values from 13 onwards.then what shall i do
Joined: Oct 14, 2005
Dec 16, 2006 14:28:00
You don't say whether the "sn" column is ordered in any way, although it is ordered in your example. And it's impossible to guess whether it might be just from its name.
Assuming that it is ordered:
Select * from whateverthetableiscalled where sn >= 13
Joined: Dec 08, 2006
Dec 23, 2006 11:57:00
$sql = "select * from table where sn >= 13";
Will get your answer...
<a href="http://www.java-tips.org/java-tutorials/tutorials/" target="_blank" rel="nofollow">Java Tutorials</a> | <a href="http://www.planet-java.org" target="_blank" rel="nofollow">Java Weblog</a> | <a href="http://computer-engineering.science-tips.org" target="_blank" rel="nofollow">Computing Articles</a>
It is sorta covered in the
JavaRanch Style Guide
subject: To extract column elements from a particular position onwards "MYSQL"
StreamTokenizer problem again...
extract particular elements from arraylist
Retrieve MySQL table column names
Retrieve binary file from database and send to user via web browser
writing to a file at a particular place
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014