Mostly correct - save for pointer sizes and such, but it's pretty hard to
reach those.
SQL vs NoSQL is not a matter of data size - plenty of fud is being spread
about NoSQL, for some reason - but a matter of access patterns.
Without knowing what you need and how you design, that question can't be
there are no hard limits as long your hardware ist fast enough
* memory, memory and agin: memory
* disk-speed
* cpu
Am 16.02.2011 06:04, schrieb Adarsh Sharma:
> Dear all,
>
> I want to know the upper limit of mysql after which Mysql-5.* fails to
> handle large amount of data ( 100's of GB
> o
Well, it wouldn't exactly limit the size of your tables, but you may want to
look into creating a partitioned table to store your data. You could define
your partition ranges to store a single day's worth of data or whatever
granularity works best for you. Then, when you need to remove older data
The order the records are returned is not guaranteed unless you
specify an ORDER BY. You could run the same query multiple times and
the order the records are returned could be different each time.
Although this is rarely the case, especially with caching enabled.
Always do an ORDER BY with p
Hello list :)
I am developing an application that will show records in paginated
documents, i.e. 10 records per page
Lets supose this row structure
MyTable
ID(autoincrement) SectionID Name Description
The ID is automatic autoincrement for unique records, the SectionID is to
separate i
On Wed, Jan 7, 2009 at 1:48 PM, Jerry Schwartz
wrote:
>
>
>>-Original Message-
>>From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
>>Behalf Of Baron Schwartz
>>Sent: Wednesday, January 07, 2009 9:54 AM
>>To: Jerry Schwartz
>>Cc:
>-Original Message-
>From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
>Behalf Of Baron Schwartz
>Sent: Wednesday, January 07, 2009 9:54 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Limit within groups
>
>On Tue, Jan 6, 2009
On Tue, Jan 6, 2009 at 3:13 PM, Jerry Schwartz
wrote:
> Each account has multiple customers, and each customer has multiple sales. I
> want to get the top 20 customers for each account.
http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/
Keep reading, it ta
] On Behalf Of
> >Phil
> >Sent: Tuesday, January 06, 2009 3:41 PM
> >To: Jerry Schwartz
> >Cc: mysql@lists.mysql.com
> >Subject: Re: Limit within groups
> >
> >How about something like
> >
> >select account,customer,max(total) from (
>-Original Message-
>From: freedc@gmail.com [mailto:freedc@gmail.com] On Behalf Of
>Phil
>Sent: Tuesday, January 06, 2009 3:41 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Limit within groups
>
>How about something like
>
>
How about something like
select account,customer,max(total) from (select
account,customer,sum(sale_amount) as total from group by
customer) as y group by account;
Seems to work in my test case..
Regards
Phil
On Tue, Jan 6, 2009 at 3:13 PM, Jerry Schwartz
wrote:
> Here's a bit of business t
Hi,
On Jan 29, 2008 1:10 PM, Ramsey, Robert L <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm having trouble wrapping my head around this problem. I have a list
> of events for multiple computers. What I want to get is a summary of
> the top 3 most common errors for each computer. So I get a result li
On Dec 31, 2007 3:05 PM, donr2020 <[EMAIL PROTECTED]> wrote:
> Sorry, I didn't type the subqueries quite correctly. They all have the same
> WHERE part (in this case, "WHERE Col1 = X" that essentially "joins" all the
> queries.
It still doesn't make sense to me. Count queries don't return
anythin
Sorry, I didn't type the subqueries quite correctly. They all have the same
WHERE part (in this case, "WHERE Col1 = X" that essentially "joins" all the
queries.
There are six counts that we need and we first tested it as seven separate
queries; but that took about 20% longer than one nested set o
On Dec 30, 2007 1:50 PM, donr2020 <[EMAIL PROTECTED]> wrote:
> Our search engine does a master query INNER JOINed to a series of COUNT (*)
> subqueries that return what the number of results would have been had the
> user chosen different "filters" (or no filter at all). As an example:
Hmm. Why a
Hi,
On Dec 14, 2007 1:02 PM, J Trahair <[EMAIL PROTECTED]> wrote:
> Hi Everyone
>
> I have a database with an OrderItems table, containing (at least) 3 fields,
> namely ExtendedPurchasePrice, CurrencyConversion and
> ExtendedPurchasePriceSterling, all fields as doubles.
>
> I want to update Exte
I tried.
Then I get:
###
person_idpoints
1 34
2 49
2 46
2 37
3 42
3 35
3 24
instead of desired:
person_idpoints
1
Change the > to >= and the < to <= to deal with this.
Baron
Miroslav Monkevic wrote:
Thanks Baron, great advice (as always).
My real query is a bit more complicated but speaking in terms of example
I provided, I took this path:
create table results
(
person_id int(11),
Thanks Baron, great advice (as always).
My real query is a bit more complicated but speaking in terms of example
I provided, I took this path:
create table results
(
person_id int(11),
points int(11)
);
insert into results values(1, 34);
insert into results values(1, 33
Miroslav
>My goal is to sum 7 greatest results for each person.
Have a look at 'Within-group quotas (Top N per group)' at
http://www.artfulsoftware.com/infotree/queries.php.
PB
-
Miroslav Monkevic wrote:
Hello,
MySQL 4.1
I have query:
SELECT SUM(points) as ranking FROM results GROUP
Hi,
Miroslav Monkevic wrote:
Hello,
MySQL 4.1
I have query:
SELECT SUM(points) as ranking FROM results GROUP BY person_id ORDER BY
ranking DESC
My goal is to sum 7 greatest results for each person.
In more general, my question is: is there a way to limit number of
records within groups i
Yup that works for me too. Thanks.
On Aug 31, 2006, at 9:12 AM, Brent Baisley wrote:
How about something like this:
select * from states, cities,
(select id from state limit 2) as stlimit
where states.id = cities.state and
state.id=stlimit.id
I tried it in 4.1 and it works.
- Original M
How about something like this:
select * from states, cities,
(select id from state limit 2) as stlimit
where states.id = cities.state and
state.id=stlimit.id
I tried it in 4.1 and it works.
- Original Message -
From: "Rob Nikander" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, August 30,
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
> - USA Central Time Zone
> 636-755-2652 fax 636-755-2503
>
> [EMAIL PROTECTED]
> www.nisc.coop
>
>> -Original Message-
>> From: Dan Buettner [mailto:[EMAIL PROTECTED]
>> Sent: Wedne
.x at this point in time
and this is a non-critical issue for me. Thanks for you help and advice.
If someone has another solution, please chime in.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.
Dirk, you could try this:
(SELECT * FROM customertable
WHERE
ORDER BY customertableid DESC
LIMIT 50)
ORDER BY customertableid ASC;
Like one sometimes does with UNIONs, but without any UNIONs. Didn't
know whether it would work, but it does (on 5.0.21 anyway).
That will give you the 50 entries
On Wednesday 28 June 2006 01:39 pm, Dirk Bremer wrote:
> Dan,
>
> That might be close. The rows are inserted with an auto-increment
> primary key, but I have no ready way of knowing what the latest 50-IDs
> are. There are also various date columns, but I won't readily know the
> dates in this scena
EMAIL PROTECTED]
www.nisc.coop
> -Original Message-
> From: Dan Buettner [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 28, 2006 15:28
> To: Dirk Bremer
> Cc: mysql@lists.mysql.com
> Subject: Re: LIMIT Question
>
> Depends what you mean by "last" -
Depends what you mean by "last" - you could show the 50 with the
latest datestamps by ending your query with something like:
ORDER BY datestampcolumn DESC
LIMIT 50;
or the 50 with the highest ID numbers, same thing:
ORDER BY id DESC
LIMIT 50;
only real problem there is then they're sorted high
Hi Eko!
It shouldn't be an issue with table size. More likely, it is due to
duplicate records in the import file. Can you post the SHOW CREATE
TABLE for your table in full (including primary key information)? Also,
any output from your import run would be useful.
Thanks!
--
Jay Pipes
Co
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bill Adams wrote:
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
> I recommend "LEFT( )".
>
> If you are looking to do it in PHP then this is the wrong email list.
>
> Good luck.
Sorry about that I realized I picked the wrong mailing
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
I recommend "LEFT( )".
If you are looking to do it in PHP then this is the wrong email list.
Good luck.
b.
CodeHeads wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello all,
Have a question:
I would like to limit the amou
On 28/12/2005, [EMAIL PROTECTED] wrote:
> I don't think there is any way with plain-old SQL (extended or
> otherwise) to do it in a single statement (unless you are doing it
> iteratively - that is: in a stored procedure and row-by-row).
USE test;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
"Jay Paulson \(CE CEN\)" <[EMAIL PROTECTED]> wrote on 12/28/2005
02:37:36 PM:
> My query below returns however many rows fit the WHERE condition, in
> this case when they year, period, week is <= 2009131. In my case it
> is returning 11 rows because I have 11 rows where the year,period,
> week
Jay,
>I only need 4 rows returned to me and not all 11 no
>matter what the <= XXX part of the where is.
... LIMIT BY 0, 4?
PB
-
Jay Paulson (CE CEN) wrote:
My query below returns however many rows fit the WHERE condition, in this case when they year, period, week is <= 2009131.
On 17/11/2005, Peter Brodersen wrote:
> I would like to select top three from different parts in the same
> table, e.g. for the following data set:
USE test;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
fid INT NOT NULL,
d INT NOT NULL
);
INSERT INTO foo VALUES
(1, 10), (1, 20),
Hello.
I've written a stored procedure that can help you. However, I'd like to
see a solution which will work for 4.1 as well.
Here is the results. First group is select from the original table,
second group is select from the temporary table with the results.
id value
1 10
Hello!
Bastian Balthazar Bux, Pooly, Shawn Green, Peter Brawley, I thank you all!
In fact, I don't understand why this command is not standardized (ANSI
SQL, etc.).
--
Удачи!
Владимир
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments
Vladimir,
>Is there any portable alternative to LIMIT? I'd like
>to create a portable PHP pager for a web site ...
No, there's not a 'super SQL' which all SQL engines understand. To hide
the details of LIMIT | TOP from your apps, you can write a PHP funcion
which applies or updates the appro
"Vladimir B. Tsarkov" <[EMAIL PROTECTED]> wrote on 09/01/2005 06:16:12 AM:
> Hello!
>
> I've heard that LIMIT is a MySQL specific, and cannot be used in any
other
> DBMS. Is there any portable alternative to LIMIT? I'd like to create a
> portable PHP pager for a web site, but all the tutorials
2005/9/1, Vladimir B. Tsarkov <[EMAIL PROTECTED]>:
> Hello!
>
> I've heard that LIMIT is a MySQL specific, and cannot be used in any other
> DBMS. Is there any portable alternative to LIMIT? I'd like to create a
> portable PHP pager for a web site, but all the tutorials that I've found,
> contain
Vladimir B. Tsarkov wrote:
> Hello!
>
> I've heard that LIMIT is a MySQL specific, and cannot be used in any other
> DBMS. Is there any portable alternative to LIMIT? I'd like to create a
> portable PHP pager for a web site, but all the tutorials that I've found,
> contain solutions based on th
Hello.
Nothing mentioned at:
http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html
So, in my opinion, the length of your AGAINST clause is limited by the
max_packet_length. But you should strongly think about the performance
of FULLTEXT searches with long search condition. From m
i was asking for things like these..
look for the thread with this subject:
"mysql and limitations and hardware features support"
for aswer to particular question read this:
http://dev.mysql.com/doc/mysql/en/table-size.html
regards
d2clon
Arcangelo Casavola wrote:
Hi,
i've MySQL 4.0.18 and 1
Hello.
I don't know such an option. However, in my opinion, max_connections
variable could be helpful. See:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
[EMAIL PROTECTED] wrote:
> Hi
>
> i like to imit te number of process at startup:
> "/usr/sbin/mysqld --based
Hello.
UPDATE in MySQL supports only row_count. See:
http://dev.mysql.com/doc/mysql/en/update.html
The same you could get from source file "sql/sql_yacc.yy".
David Legault wrote:
> Hello,
>
> I'm using the MySQL C API and I got the following error for this query:
>
> UPDATE
I think you might be confusing UPDATE and SELECT syntax. As far as I
ever knew, you couldn't specify a limit offset in an update statement.
I don't see in mysql update docs where it indicates offset is allowed.
kgt
David Legault wrote:
Hello,
I'm using the MySQL C API and I got the
"A. Clausen" <[EMAIL PROTECTED]> wrote on 04/14/2005 12:19:05 PM:
> I'm running MySQL 3.23.58 on a Win2k server with multiple IP addresses
and
> I'm wondering whether there is a way to limit the MySQL server to
answering
> on just one IP address.
>
> --
> A. Clausen
>
>
Yes. http://dev.mysql
In your my.cnf, put a "bind-address" directive:
bind-address=xxx.xxx.xxx.xxx
Christian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
The only limit I'm aware of is the size of a query itself, which can not
be bigger than the max_allowed_packet size.
Regards,
Jocelyn
Mauricio Pellegrini a écrit :
Hi ,
I'm using mysql 4.1.4 gamma with InnoDB suse 8.2 reiser fs.
I'am doing backups using mysqldump which creates a sql scrip
At 11:15 -0800 2/18/05, Scott Klarenbach wrote:
I can't seem to pass in the LIMIT clause variables into a stored procedure
http://dev.mysql.com/doc/mysql/en/select.html says:
The LIMIT clause can be used to constrain the number of rows returned
by the SELECT statement. LIMIT takes one or two numer
[snip]
Is there a way I can select from a text field and limit the amount of
text I
get back in my query? For example, if I have an articleText field of
type
TEXT, and the article contains 4000 words, is there a way to select that
text with a limit of 200 words, or should this kind of logic go in
Steve Grosz wrote:
I had tried to load a group of records from a Excel spreadsheet, and
for the most part it seems to have worked.
The problem is that I know there were more than 1000 rows of data to
be input, and it stopped at 1000 exactly.
I'm not 100% sure but this is what I think happened.
It sound like you are exporting from Mysql Command Center which limit
records to 1000 by default
You can export the data from command line or increase the limit.
On Fri, 2005-01-14 at 16:49, Michael Loftis wrote:
> --On Friday, January 14, 2005 14:39 -0700 Steve Grosz
> <[EMAIL PROTECTED]> wrote
--On Friday, January 14, 2005 14:39 -0700 Steve Grosz
<[EMAIL PROTECTED]> wrote:
I had tried to load a group of records from a Excel spreadsheet, and for
the most part it seems to have worked.
The problem is that I know there were more than 1000 rows of data to be
input, and it stopped at 1000 e
mos wrote:
At 12:05 PM 12/13/2004, you wrote:
Is there any way to limit drive usage per thread?
I have a problem where an update thread will use 100 % of the drive,
and simple index searches that should be instant will wait and wait
and wait before responding.
I dont want one user to kill everyb
At 12:05 PM 12/13/2004, you wrote:
Is there any way to limit drive usage per thread?
I have a problem where an update thread will use 100 % of the drive, and
simple index searches that should be instant will wait and wait and wait
before responding.
I dont want one user to kill everybody else
I'
Anybody know? Or am I dreaming about oracle features that are not in mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
matt_lists wrote:
Dathan Pattishall wrote:
From the brief sound of it your using myISAM, and the query taking the
most time is not indexed or using an index properly.
Alters will lock the table, and once it starts it should finish or your
going to have to recover the table. I suggest taking an outa
Dathan Pattishall wrote:
From the brief sound of it your using myISAM, and the query taking the
most time is not indexed or using an index properly.
Alters will lock the table, and once it starts it should finish or your
going to have to recover the table. I suggest taking an outage. If you
can't
>From the brief sound of it your using myISAM, and the query taking the
most time is not indexed or using an index properly.
Alters will lock the table, and once it starts it should finish or your
going to have to recover the table. I suggest taking an outage. If you
can't
Make a replica of the
Hi Sasha,
I've tried writing a python wrapper but It's an hard work because I've
to wrap every type of queries, join, where, order, group and any other
MySQL 4.0 clause.
Have you ever written or used a wrapper like the one I need?
Anyone knows a simple way for developing it?
This is not just a SE
Marco Lazzeri wrote:
Yes, I know. Perhaps, I'm searching for workarounds.
Il gio, 2004-05-20 alle 17:58, Victor Pendleton ha scritto:
You can grant those permissions on columns but not on individual rows.
Marco:
Your choices are limited to creating a wrapper for your users. If they have
direct ac
Yes, I know. Perhaps, I'm searching for workarounds.
Il gio, 2004-05-20 alle 17:58, Victor Pendleton ha scritto:
> You can grant those permissions on columns but not on individual rows.
>
> -Original Message-
> From: Marco Lazzeri
> To: [EMAIL PROTECTED]
> Sent: 5/20/04 10:04 AM
> Subjec
You can grant those permissions on columns but not on individual rows.
-Original Message-
From: Marco Lazzeri
To: [EMAIL PROTECTED]
Sent: 5/20/04 10:04 AM
Subject: Limit operations by condition
I would like to grant SELECT/UPDATE/INSERT/DELETE privileges _only_ on
particular set of rows.
Also interested in answer to this one.
Terry Riley
--Original Message-
> Hi List,
>
> When can we expect limits in sub-queries? I am currently on 4.1.0.
>
> 1235 - This version of MySQL doesn't yet support 'LIMIT &
> IN/ALL/ANY/SOME
> subquery'
> Query:
>
--
MySQL Gener
At 1:52 +0200 3/18/04, Lorderon wrote:
Nope.. that doesn't work.. the LIMIT statement limits the rows returned, but
only 1 row is returned from that query always.. I want MySQL to stop the
count when it reaches to 200, rather to have it go over all the table and
return me 3500..
You can't tell COUN
Nope.. that doesn't work.. the LIMIT statement limits the rows returned, but
only 1 row is returned from that query always.. I want MySQL to stop the
count when it reaches to 200, rather to have it go over all the table and
return me 3500..
> SELECT COUNT(*) FROM tbl WHERE where_clause limit 200;
SELECT COUNT(*) FROM tbl WHERE where_clause limit 200;
-Original Message-
From: Lorderon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 6:45 PM
To: [EMAIL PROTECTED]
Subject: limit stop count
How can I limit a count to stop when he reaches 200 rows?
SELECT COUNT(*) FROM tbl W
At 20:32 -0800 2/28/04, Scott Haneda wrote:
on 02/28/2004 07:08 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
At 17:22 -0800 2/28/04, Scott Haneda wrote:
How can I limit the connections from the same host in mysql.
You can put a limit on the number of connections per hour from a given
account (W
on 02/28/2004 07:08 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
> At 17:22 -0800 2/28/04, Scott Haneda wrote:
>> How can I limit the connections from the same host in mysql.
>
> You can put a limit on the number of connections per hour from a given
> account (WITH MAX_CONNECTIONS_PER_HOUR), but n
At 17:22 -0800 2/28/04, Scott Haneda wrote:
How can I limit the connections from the same host in mysql.
You can put a limit on the number of connections per hour from a given
account (WITH MAX_CONNECTIONS_PER_HOUR), but not from a given host.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisco
Matthew Stuart wrote:
This query is working fine apart from the LIMIT part. I can’t see what
is wrong with it, I have tried it in different places and still no
luck. Does anybody know why it’s not working?
WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%'
OR fld_body LIK
Limit needs to be the last line in your query
>> Original Message <<
On 2/2/04, 1:55:13 PM, Matthew Stuart <[EMAIL PROTECTED]> wrote regarding
LIMIT not working problem:
> This query is working fine apart from the LIMIT part. I can't see what
> is wrong with it,
You have to use bind_param() to identify the parameter as an integer.
Rudy Lippan, the author of DBD::mysql, had a message about it on the
dbi-users list:
Thanks Keith, that explains it... I do not like this new behaviour of
DBD, though. I think it should be the other way around: let those w
hat explains it. :-)
Matt
- Original Message -
From: "Avenger"
Sent: Wednesday, October 29, 2003 1:41 AM
Subject: Re: Limit Optimization??
> That sooo cool... It was the very perfection of beauty.
>
> but i didnt' know.why my index (ClassID, Auditing, CreatedTime) ar
On 29 Oct 2003 at 18:00, Fagyal, Csongor wrote:
> Any ideas what causes this behaviour? Maybe I have not upgraded my DBI
> & DBD packages properly? Or are LIMIT placeholders no longer supported
> in DBI with MySQL 4?
I don't think the MySQL version is relevant. The change is in
DBD::mysql 2.900
That sooo cool... It was the very perfection of beauty.
but i didnt' know.why my index (ClassID, Auditing, CreatedTime) are
slowly as matt's (ClassID, Auditing, CreatedTime, ArticleID)
could matt explain why?
Thx matt..
On Tue, 28 Oct 2003 02:06:16 -0600
"Matt W" <[EMAIL PROTECTED]> wrote:
> H
, October 28, 2003 1:37 AM
Subject: Re: Limit Optimization??
> It's my info publsih system
>
> My table structure :
> #
> # Table structure for table 'article'
> #
> CREATE TABLE article (
> ArticleID int(11) NOT NULL auto_increment,
> ClassID
ee which columns can or should be added to
> an index.
>
> Also, can you show which indexes are already on the table? The last
> lines of "SHOW CREATE TABLE table;" with the KEY definitions is fine.
>
>
> Matt
>
>
> - Original Message -
> From: "ave
s are already on the table? The last
lines of "SHOW CREATE TABLE table;" with the KEY definitions is fine.
Matt
- Original Message -
From: "avenger"
Sent: Monday, October 27, 2003 10:24 PM
Subject: Re: Limit Optimization??
> good job!!
> it short my query time f
good job!!
it short my query time from 30 sec to 0.6 sec.
IOW,now i can not use the 'where' & 'order by' clause in the SELECT . can i
need more indexs ?
thx Matt.
""Matt W"" <[EMAIL PROTECTED]> wrote
[EMAIL PROTECTED]
> Hi,
>
> Yes, MySQL stops searching for rows once the LIMIT is satisfied, as
Hi,
Yes, MySQL stops searching for rows once the LIMIT is satisfied, as long
as filesort isn't used for an ORDER BY. But your LIMIT 150, 20 will
take much longer (assuming filesort isn't used) than, say, LIMIT 1000,
20. This is because it has to scan over 1.5M rows first. It's not really
possi
* Ciprian Trofin
> I have 2 tables: currencies and quotes
>
> currencies
> ==
> id currency
> -
>
> quotes
> ==
> id date id_currency value
> ---
> Index (date, id_currency - UNIQUE)
>
>
> In order to find the most recent value for a
Add LIMIT x,y (x is first row and y the number of rows 1.e. 1,1 for
first row) at the end of the SQL and order the SQL. Not sure if this
helps, just initial thoughts.
On Wed, 2003-10-08 at 13:04, Ciprian Trofin wrote:
> I have 2 tables: currencies and quotes
>
> currencies
> ==
> id cu
Hello Andrey,
Friday, July 11, 2003, 7:28:27 PM, you wrote:
http://www.mysql.com/doc/en/SELECT.html
.
The LIMIT clause can be used to constrain the number of rows returned by the SELECT
statement.
LIMIT takes one or two numeric arguments. The arguments must be integer consta
Andrey <[EMAIL PROTECTED]> wrote:
>
> I have a following question:
>
> I have a table with thousands of rows which i need to show in a String Grid ( I use
> Borland Delphi with MyDac component which implements MySQL interface).
>
> If i make a query
> SELECT * FROM tbl WHERE col1="something"
Thank you very much for your information. I have encountered another problem
if I use this approach. The problem is I can change the database directory to
another group which has quota. However, whatever mysql create new table, it
will use its configrated group (namely 'mysql' in Redhat default
Thank you very much for your information. Can you tell me more how to limit
size of directory in Linux? I can only set quota for users or groups but not
for directory.
Thank you very much.
> On Tuesday 18 February 2003 04:26, KH Chiu wrote:
>
> > I am planning to offer a free service that allo
On Tuesday 18 February 2003 04:26, KH Chiu wrote:
> I am planning to offer a free service that allow users to use my server to
> learn php and MySQL. I am a bit worry about if one of users (either
> intentionally or unintentionally) get into infinite loop with insert
> statement. It will quickly e
On Thu, 2002-12-05 at 19:39, Michelle de Beer wrote:
> > you mean mySQL does the search on 100 first entries
> > and then order the
> > results, instead of getting the results and
> > returning only the first 100 ?
> > If yes I too would like to know what's the right way
> > to do it in SQL then ?
older
versions of MySQL had a bug with order by and limit clauses, though...
--jeff
- Original Message -
From: "Michelle de Beer" <[EMAIL PROTECTED]>
To: "Alliax" <[EMAIL PROTECTED]>; "mysql list" <[EMAIL PROTECTED]>
Sent: Thursday, Dece
On Thu, Dec 05, 2002 at 02:00:43PM -0800, Michelle de Beer wrote:
> Select * from mytable ORDER by total desc limit 0, 100
See my other most recent reply; you can do it in two queries:
CREATE TEMPORARY TABLE Top100 SELECT * ... limit 0,100;
SELECT * FROM Top100 ORDER BY ...;
The temporary table
At 2:00 PM -0800 12/5/02, Michelle de Beer wrote:
How can I limit the result after the "order by" has
been executed? This stops efter 100 rows and the
result is not as I intended...
Select * from mytable ORDER by total desc limit 0, 100
Must this be done in PHP?
Perhaps you could tell us wha
> you mean mySQL does the search on 100 first entries
> and then order the
> results, instead of getting the results and
> returning only the first 100 ?
> If yes I too would like to know what's the right way
> to do it in SQL then ?
That is correct. This is what I have:
One table with 1000 recor
MYSQL
On Thu, 2002-12-05 at 17:00, Michelle de Beer wrote:
> How can I limit the result after the "order by" has
> been executed? This stops efter 100 rows and the
> result is not as I intended...
>
> Select * from mytable ORDER by total desc limit 0, 100
>
> Must this be done in PHP?
>
> Thanks
From: Jim Esten <[EMAIL PROTECTED]>
> LIMIT is "LIMIT ,"...no?
>From the 4.0.0-alpha docs, section 6.4.1:
The LIMIT clause can be used to constrain the number of rows returned
by the SELECT statement. LIMIT takes one or two numeric arguments. If
two arguments are given, the first spec
At 12:56 PM -0500 11/26/02, Mike At Spy wrote:
I must not be awake yet. Why is this query sending me back 60 records?
Shouldn't it only send back records 30 through 60 (i.e. 30 records)?
SELECT * FROM table ORDER BY somefield LIMIT 30,60
Thanks,
-Mike
As computers are wont to do, it's sendi
its not LIMIT from, to, its LIMIT start, count
SELECT * FROM table ORDER BY somefield LIMIT 30,30
On Tuesday 26 November 2002 11:56, you wrote:
> I must not be awake yet. Why is this query sending me back 60 records?
> Shouldn't it only send back records 30 through 60 (i.e. 30 records)?
>
> SELE
Your command says select 60 rows starting at row 30. You want "LIMIT 30, 30"
to get 30 rows.
Matt
- Original Message -
From: Mike At Spy <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 9:56 AM
Subject: LIMIT in MySQL
>
> I must not be awake yet. Why is this
1 - 100 of 147 matches
Mail list logo
