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
or
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
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
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
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
On Tue, Jan 6, 2009 at 3:13 PM, Jerry Schwartz
jschwa...@the-infoshop.com wrote:
Each account has multiple customers, and each customer has multiple sales. I
want to get the top 20 customers for each account.
-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 at 3:13 PM, Jerry Schwartz
jschwa
: Re: Limit within groups
On Tue, Jan 6, 2009 at 3:13 PM, Jerry Schwartz
jschwa...@the-infoshop.com 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
How about something like
select account,customer,max(total) from (select
account,customer,sum(sale_amount) as total from tablename 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
-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
select account,customer,max(total) from (select
: 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 (select
account,customer,sum(sale_amount) as total from tablename group by
customer) as y group by account
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 like
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 are you
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 of
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
anything to
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
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,
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),
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
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
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
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: mysql@lists.mysql.com
Sent:
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
- 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: Wednesday, June 28, 2006 15:28
To: Dirk Bremer
Cc: mysql@lists.mysql.com
Subject: Re: LIMIT Question
Depends what you mean
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
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 - you could show the 50 with the
latest datestamps
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 scenario.
Dirk, you could try this:
(SELECT * FROM customertable
WHERE some criteria
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
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: Wednesday, June 28, 2006 15:54
To: Chris White
Cc: mysql@lists.mysql.com
Subject: Re: LIMIT Question
Dirk
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
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
-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 list
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 (
i
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.
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 is
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
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 the
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 [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 that
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
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
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 --basedir=/
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 tracks
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
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]
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.
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
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
[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
--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
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:
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.
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
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]
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
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
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
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
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
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
Subject:
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
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
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 General
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
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;
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
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,
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 not
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
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, I have tried it in different places
Matthew Stuart wrote:
This query is working fine apart from the LIMIT part. I cant see what
is wrong with it, I have tried it in different places and still no
luck. Does anybody know why its not working?
WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%'
OR fld_body
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) are
slowly as matt's (ClassID, Auditing
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
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:
Hi,
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.9002,
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 from 30 sec to 0.6 sec.
IOW,now i can not use
- Original Message -
From: avenger
Sent: Monday, October 27, 2003 10:24 PM
Subject: Re: Limit Optimization??
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
-
From: avenger
Sent: Tuesday, 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 int(11) NOT NULL default '0
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
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 long
as
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
* 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 currency I use
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,
it can
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 eat
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 allow
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
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 for all
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 records.
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 what
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
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, December 05, 2002 4:39 PM
Subject: RE: Limit and Order by
you mean mySQL
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 ?
That is
It is starting at record 30 and sending you the next 60 records.
Maybe you want LIMIT 30, 30 ?
David
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 9:56 AM
To: [EMAIL PROTECTED]
Subject: LIMIT in MySQL
I must not be awake yet. Why is
At 12:56 -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
No.
30 = number of records to skip
60 = number of records
LIMIT is LIMIT starting record,number of records...no?
Jim
Jim Esten
Chief Techbot
WebDynamic http://www.wdynamic.com
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 11:56 AM
To: [EMAIL PROTECTED]
Subject: LIMIT in MySQL
I must
Hello.
On Tue 2002-11-26 at 12:56:04 -0500, [EMAIL PROTECTED] 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)?
Because it's LIMIT offset, amount
i.e. you are asking for rows 30-89
Bye,
Read the documentation.
http://www.mysql.com/doc/en/SELECT.html
The link has been sent out on this list about 6 times this morning, all in
posts regarding the limit clause.
The LIMIT clause can be used to constrain the number of rows returned by the
SELECT statement. LIMIT takes one or two
1 - 100 of 137 matches
Mail list logo
