The first question that occurs to me is, Why on earth would you want an app
to display 2500 rows? You must have one incredible monitor with a resolution
beyond my wildest dreams! I would look into the LIMIT predicate and use it
to grab say 50 rows at a time, or fewer, and post a marker so you know
Velen wrote:
Hi,
May be it's not the right forum i'm posting to.
I have a Mysql Query : Select a.code,b.description,
b.other_details,a.qty,a.price from xyz a, bcd b where a.code=b.code and
a.id='5' order by a.id
This is running fine but when using VB6 to display it in a Msflexgrid, it's a
On Mon, Jan 30, 2006 at 03:04:20PM +0200, Gleb Paharenko wrote:
> Hello.
>
> This is not an exact answer on your question, however it could be
> interesting for you:
> http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
This is a good article. One thing it leaves out of the dis
Hello.
This is not an exact answer on your question, however it could be
interesting for you:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Jochen Kaechelin wrote:
> I have the following table:
>
> mysql> select * from link_categories;
> ++---+-+--
Hi Jochen.
An alternative approach could be to pull all the values out
of the database using select * from ..., and then build the
tree-structure in your application logic. Insert the
relevant values returned from mysql in the appropriate
places of the tree-structure in the app code.
Keith
Jochen,
...I want to display a tree like:
Software
Virenscanner
Linux
Debian Woody
Windows
Windowsd XP
Packprogramm
Sniffer
Hardware
Vermischtes
It looks more like a parts
Dan,
Thanks to Rhino & Dan for the corrections,
HAVING in that query makes it
return only id values for which there is one row, and the header is
wrong since "first row of every group" doesn't mean anything without
explicit ordering.
>What do you mean?
In SELECT foo ... GROUP BY foo ...,
On Mon, 11 Apr 2005, Peter Brawley wrote:
>Thanks to Rhino & Dan for the corrections, HAVING in that query makes it
>return only id values for which there is one row, and the header is
>wrong since "first row of every group" doesn't mean anything without
>explicit ordering.
What do you mean?
Thanks to Rhino & Dan for the corrections, HAVING in that query
makes it return only id values for which there is one row, and the
header is wrong since "first row of every group" doesn't mean anything
without explicit ordering.
PB
-
Dan Bolser wrote:
On Mon, 11 Apr 2005, Rhino wrote:
On Mon, 11 Apr 2005, Peter Brawley wrote:
>/>I guess that entry is either wrong or misleading./
>
>Ordering by another column which isn't mutually dependent with the
>grouping column will have unpredictable results. Is that what you mean
>by the example being "wrong or misleading"?
No, I mean t
>I guess that entry is either wrong or misleading.
Ordering by another column which isn't mutually dependent with the
grouping column will have unpredictable results. Is that what you mean
by the example being "wrong or misleading"?
PB
-
Dan Bolser wrote:
I guess that entry is eithe
On Mon, 11 Apr 2005, Rhino wrote:
>
>- Original Message -
>From: "Dan Bolser" <[EMAIL PROTECTED]>
>To:
>Sent: Monday, April 11, 2005 5:58 AM
>Subject: Display 1st row of every group?
>
>
>>
>> I read with great interest this
>>
>> http://www.artfulsoftware.com/queries.php#4
>>
>> Display
- Original Message -
From: "Dan Bolser" <[EMAIL PROTECTED]>
To:
Sent: Monday, April 11, 2005 5:58 AM
Subject: Display 1st row of every group?
>
> I read with great interest this
>
> http://www.artfulsoftware.com/queries.php#4
>
> Display 1st row of every group
>
> SELECT id
> FROM tbl
I guess that entry is either wrong or misleading.
I can get what I want like this
SELECT *
FROM tbl
INNER JOIN ( SELECT id, min(bleah) as bleah
FROM tbl
GROUP BY id
)
USING (id,bleah);
Which will work so long as bleah has
- Original Message -
From: "Tracy Gems" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 28, 2004 5:59 PM
Subject: display only populated fields
>
> How do I go about only displaying fields that have data and are not empty
or have NULL?
>
> It's a 112 column table so
If you are using something to run this query, what is it? What tool(s) are
you using to retrieve/view the data?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Tracy Gems <[EMAIL PROTECTED]> wrote on 09/28/2004 05:59:08 PM:
>
> How do I go about only displaying fields that
You probably want to pick up a good SQL book. MySQL by Paul DuBois is
a really good one.
http://www.amazon.com/exec/obidos/tg/detail/-/0735712123/qid=1090786499/sr=8-2/ref=pd_ka_2/102-0741496-3072118?v=glance&s=books&n=507846
You want to use the WHERE clause of the select statement.
SELECT tabl
On Fri, Jul 02, 2004 at 01:52:06PM -0500, Boyd E. Hemphill wrote:
> We discovered a rather odd situation where some space characters where
> being displayed as "?".
>
> In tracking this down, it was determined that the server had stored the
> hex value "A0" rather than "20" by using this query:
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2004-04-24 19:40 +0200]:
> I want to know if there is a way to change the display of the mysql
> query results.
If you're under GNU/Linux, type "\P less -S" at the mysql prompt.
This sets the pager to "less", which allows you to use the four cursor
keys f
toby,
Saturday, July 27, 2002, 10:21:50 AM, you wrote:
t> i ve a lil problem
t> i run this query n get a result set
[skip]
t> what should i do ?
I think your question is more suitable for php mailing list.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
You can use LIMIT clause:
SELECT fields FROM table LIMIT X,25
where X is number of row to start with.
You can substitute this number for example
in HREF:
Page2
Page3
Page4
then your script should take X value and
use it to compose the query.
Aqua wrote:
> I have 100 records in mySQL database
Hello,
I think Mr. Carlson requires to output all the dates between two given dates.
This can be done with defined variables and an auxiliary table, the
requirement
being that it should have at least as many rows as there are days between the
dates and to directly give the number of days betwee
Hello,
Tim Carlson wrote:
>Hello,
>
>Newbie SQL person here. I am hoping to be able to do the
>following. Given two dates, I would like to display all of the days
>between them.
>
>So if I had the dates 2002-02-08 and 2002-02-12, I would like to have
>MySQL spit back
>
>2002-02-08
>2002-02-09
>20
At 01:36 PM 5/3/2002, you wrote:
>Hello,
>
>Newbie SQL person here. I am hoping to be able to do the
>following. Given two dates, I would like to display all of the days
>between them.
>
>So if I had the dates 2002-02-08 and 2002-02-12, I would like to have
>MySQL spit back
>
>2002-02-08
>2002-02-
Hi.
On Mon, Nov 26, 2001 at 02:45:26PM -0500, [EMAIL PROTECTED] wrote:
> I have a rhetorical question.
>
> I'm learning as much as I can about MySQL. There is one little detail
> that I don't *have* to know the answer to, but I'm curious about. Don't
> waste your time replying if you're busy
On Sat, 16 Jun 2001 14:33:44 -0500 (CDT), Don Read <[EMAIL PROTECTED]> wrote:
A heck of alot easier with Perl!(Just my opinion) :) Just disable RaiseError and
enable PrintError when using DBI
>>
>>On 16-Jun-01 Dawn H wrote:
>>> How do I make an error display, but still continue the script? Th
Ah. The subroutine bail_out() that I'm using is using die. Aha! :-)
Thanks,
=Dawn
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 16, 2001 2:39 PM
To: Dawn H
Cc: MySQL Email List
Subject: RE: Display error but continue script
On 16-Jun-01 D
On 16-Jun-01 Dawn H wrote:
> I'm using Perl
>
are you displaying your message with warn() or with die() ?
> Filter fixer: database,sql,query
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neigh
On 16-Jun-01 Dawn H wrote:
> How do I make an error display, but still continue the script? The error
> subroutine does not exit, but the original subroutine that calls it doesn't
> continue
> after the error message, it just quits.
>
A look at the code that does that would help ...
but:
$deb
I'm using Perl
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
MikeBlezien
Sent: Saturday, June 16, 2001 2:06 PM
To: Dawn H
Cc: [EMAIL PROTECTED]
Subject: Re: Display error but continue script
On Sat, 16 Jun 2001 13:47:29 -0500, "Dawn
Hello all again.
I think I need to be a little more specific in describing my problem.
So, let me try again. I have a database of scrap records. There are
currently over 2000 records in this database. I have a web page that
queries this database and displays the records in reverse order, newest
isn't it as simple as...
select id,lot_id,lot_type from scrap_table
where id >= 1932 and id <= 1942
order by id limit 10;
?
cheers,
P
>
> which should give me records 1932 - 1942 like this...
>
> +--+--+--+
> | id | lot_id | lot_type |
> +--+
> select id,lot_id,lot_type from scrap_table
> (part I need help with)
>order by id limit 10;
>
> which should give me records 1932 - 1942 like this...
>
> +--+--+--+
> | id | lot_id | lot_type |
> +--+--+--+
> | 1942 | 0034906 | F|
>
select id,lot_id,lot_type from scrap_table where id >= 1932 order by id
limit 10;
select id,lot_id,lot_type from scrap_table order by id limit 1932,10;
either should work, i think the first would be faster but I'm not positive
how MySQL would handle the second in terms of optimization.
-jm
Rick Pasotto writes:
>
> Which applies to *all* columns, not individual ones.
>
> > But all column widths are resizeable, of course.
>
> What is this "of course" bit? There is no "of course."
>
> If you mean resizing with the mouse - of course I tried that.
>
> It didn't work.
>
On Tue, Jan 16, 2001 at 03:04:23PM +0200, Sinisa Milivojevic wrote:
> Gerald L. Clark writes:
> > Rick Pasotto wrote:
> > >
> > > SELECT concat(last_name,", ",first_name) as name from members
> > >
> > > results in a column that is much wider than necessary. Adding trim() to
> > > the conc
Gerald L. Clark writes:
> Rick Pasotto wrote:
> >
> > SELECT concat(last_name,", ",first_name) as name from members
> >
> > results in a column that is much wider than necessary. Adding trim() to
> > the concat() nor to the components makes any difference.
> >
> > Can the column width b
Rick Pasotto wrote:
>
> On Mon, Jan 15, 2001 at 10:39:15AM -0600, Gerald L. Clark wrote:
> > Rick Pasotto wrote:
> > >
> > > SELECT concat(last_name,", ",first_name) as name from members
> > >
> > > results in a column that is much wider than necessary. Adding trim() to
> > > the concat() nor to
On Mon, Jan 15, 2001 at 10:39:15AM -0600, Gerald L. Clark wrote:
> Rick Pasotto wrote:
> >
> > SELECT concat(last_name,", ",first_name) as name from members
> >
> > results in a column that is much wider than necessary. Adding trim() to
> > the concat() nor to the components makes any difference
39 matches
Mail list logo
