log working if
possible as it sounds pretty useful, so thanks again.
Bill
-Original Message-
From: Jerry Schwartz [mailto:je...@gii.co.jp]
Sent: 09 June 2010 16:43
To: 'Anirudh Sundar'; mysql@lists.mysql.com
Subject: RE: How can I see the query from a remote session against my s
ovide on this as I've got people that expect
miracles in the next 5 minutes here!
Bill
I am in need of some help for the following:
Say I have a table with 1M rows. Users are being added constantly (not
deleted) during the queries that I am about to explain. The pk is uid and
appid. I need to run queries in increments of 100K rows until reaching the
end without duplicating row
.prod_discont < a.prod_discont
WHERE
alias_for_a.prod_num IS NULL
ORDER BY b.prod_pub_prod_id;
US Data Export wrote:
-Original Message-
From: Bill newton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2008 6:49 PM
To: Jerry Schwartz
Cc: 'mysql'
Subject: Re: Findin
that would accomplish that would be:
SELECT IF(a.prod_num IS NOT NULL,IF(a.prod_discont =
0,a.prod_num,"discontinued"),"") as prod_num
FROM b LEFT JOIN a ON b.prod_pub_prod_id = a.prod_pub_prod_id
ORDER BY b.prod_pub_prod_id;
You can nest IF statements in mysql queries.
Hope it he
fake company.
If I had to choose one of those, I"d go with the dual foreign keys. #3
Thanks for the meaty question,
Bill
metastable wrote:
Hello all,
I have a question that's been bugging me for quite some time.
Let's say we have a small business that has both private and co
--
No virus found in this incoming message.
Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database:
270.8.2/1739 - Release Date: 10/22/2008 7:23 AM
--
Bill Newton
Network Merchants Inc.
http://www.nmi.com
(847) 352-4850 ext 141/ T
th this: *BDB support will be removed. * Note
that,
as of MySQL 5.1, BDB isn't supported any longer.
http://dev.mysql.com/doc/refman/5.0/en/bdb-storage-engine.html
But you're right that as a storgage engine, there have been very few
questions related to it, on this mailing list anyw
Try using the sub query as a derived table ala:
SELECT eo_name_table.eo_name, eo_name_table.eo_pub_date
FROM eo_name_table LEFT JOIN (SELECT prod.prod_title FROM prod WHERE prod.prod_discont = 0) fake_prod on eo_name_table.eo_name = fake_prod.prod_title
WHERE prod.prod_title IS NULL
I'm not
Hi Jerry,
I think the problem is that NULL is not less than or greater than your
prod_published date. So you probably have eo_pub_date set to NULL in 56
of your rows.
so for
eo_name_table.eo_pub_date > prod.prod_published
or
eo_name_table.eo_pub_date <= prod.prod_published
mysql will rer
To get a blank line instead of NULL you could simply wrap the reference
in an IFNULL function:
select dummy.row_id,IFNULL(real.reference,'') as Reference from dummy left join
real on
real.row_id=dummy.row_id;
Phil wrote:
you could do something like
select dummy.row_id,real.reference from
From the download page:
Please note that at this point only the Windows Beta version is
available. Linux and OS X releases will be available in 2008.
It looks nice, I was looking for a similar tool 5 -6 years ago. It looks
like what I would have wanted at the time.
legolas wrote:
Is ther
Will mysql-table-checksum from mysql toolkit work with setups that have
different Master/ Slave storage engines? Are there any things to
consider when using it between two different engines ( say Innodb master
and MyIsam slave)?
Thanks in advance,
Bill Newton
--
MySQL General Mailing
Hi Koki,
You have to re- establish the database connection in each child process.
Otherwise the packets get mangled and you get the errors you're seeing.
Koki Takeda wrote:
I hope that my contacting you is not an imposition in any way.
My name is Koki Takeda.
This time, I made the php progr
problème s'est produit dans le
transfert des données à partir d'une base de données à l'autre. Comment
avez-vous copié les données ? Vous pourriez examiner insérer de
nouvelles données dans chaque base de données et voir si elle semble
correcte.
Bill
Gilles MISSONNIER wrote:
He
I would like to perform a query of a personnel database with an ORDER
BY clause that ignores punctuation. For example, O'shea would sort
after Osbourne, not to the beginning of the Os.
Is this doable in the query?
-= Bill =-
--
You can tell a lot about a man by th
could retrieve the above data ?
Thanks.
Yashesh Bhatia.
It looks to me as if your query returned exactly what you asked for.
It found the first two rows (other rows are not distinct), and then
ordered them in descending order by time stamp. Descending is largest
to smallest. TS for
nature makes me think that it still should, and it doesn't now. That is
the issue that I raised. I am guessing, given Reimer's insight, that the
domain name registration has expired and someone needs to renew it. I hope
they plan to do that because I found the site useful.
Bill
--On Thursday, November 09, 2006 08:37:01 PM +0200 Onur
<[EMAIL PROTECTED]> wrote:
Bill MacAllister wrote:
What happened to the Innodb web pages? What comes up for be is a
search page with a bunch of related links on it. I wanted to pull
down a copy of ibbackup documentation and it
What happened to the Innodb web pages? What comes up for be is a search
page with a bunch of related links on it. I wanted to pull down a copy of
ibbackup documentation and it isn't there anymore.
Bill
+---
| Bill MacAllister, S
date, 1, 4),substr(start_date,6,2)). Something
like
ALTER TABLE events
ALTER start_yr_mo start_yr_mo
SET = concat(substr(start_date, 1, 4),substr(start_date,6,2));
-= Bill =-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
In response to Bill Moran <[EMAIL PROTECTED]>:
> In response to "Dan Buettner" <[EMAIL PROTECTED]>:
>
> > Bill, you can up the value of 'max_connect_errors' (default is 10 it
> > appears) to make this problem appear less frequently while you
In response to "Dan Buettner" <[EMAIL PROTECTED]>:
> Bill, you can up the value of 'max_connect_errors' (default is 10 it
> appears) to make this problem appear less frequently while you
> troubleshoot.
Thanks for the thought, Dan. Before I do that, I
.3-RELEASE-p37
php5-pgsql-5.1.6_1
mysql-client-4.1.21
Server:
FreeBSD 5.3-RELEASE-p37
mysql-server-4.1.21
--
Bill Moran
Collaborative Fusion Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You know, this works just fine for me -- when you say it is NOT working,
what do you mean exactly? Are you getting an error? Or results that you
don't expect?
Bill Tantzen
University of Minnesota Libraries
[EMAIL PROTECTED]
612-626-9949 (office) 612-250-6125
Hi obed
I looked many times in the commands list and maybe I didn't wat to see it
!!!
The answer is a '\G' appended at the end of the line.
Thanks for the help
Bill
>> Can you remind me how to tell mysql to list vertically instead of horiz
>> in
>> text mode
Hi
Can you remind me how to tell mysql to list vertically instead of horiz in
text mode?
Ex:
select all * from a_tablesends field1 field2 .
I want
field1
field2
field...
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
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
UPDATE table SET field_a=field_b;
b.
Ravi Malghan wrote:
Hi: is there a way to copy all field values from one
field to another from the mysql prompt?
Thanks
Ravi
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
InnoDB always needs the shared tablespace because it puts its
internal data dictionary and undo logs there. The .ibd files are
not sufficient for InnoDB to operate.
well, thats what I found before. But it doesn't explain why InnoDB
does need a logfile even when all transactions are committ
Marten Lehmann wrote:
I had a lot of trouble today because the InnoDB integration in MySQL
is lousy. I read the manual and worked with innodb_per_file_table. So
when I shutdown mysql I should be able to delete ib_logfile0,
ib_logfile1 and ibdata1, because all table-data should be stored in
th
to avoid using SET SQL_BIG_SELECTS=1. I know in earlier versions
(perhaps 4.0.x?) I could increase the value to what I wanted.
I will happily add the output from "show variables" if that will help.
Thanks in advance for your help.
--Bill
Welcome to the MySQL monitor. Commands end
Hi
I'd say that you have an ideal situation to use a Raid level 1 system.
"Rick Dwyer" <[EMAIL PROTECTED]> a écrit dans le message de news:
[EMAIL PROTECTED]
> Hello all.
> I am looking into the different back up methods available for
> safeguarding my MySQL databases.
> Ideally, I would like to
inary and have the result be returned as a separate field for
each bit? For example, what I'd like to do is,
Select ConvertToBin(245);
And have a result that looked like this
+---+---+---+---+---+---+---+---+
| 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 |
+---+---+---+---+---+---+---+---+
| 1 | 1 | 1 | 1 |
anks in advance.
Xiaobo
--
Bill Dodson
Parkline, Inc. http://www.parkline.com
phone: 304-586-2113 x149
fax: 304-586-3842
email: [EMAIL PROTECTED]
Email Disclaimer
The information in any email is confidential and may be legally privileged. It
is intended solely for the addressee. Access to the e
me fields I also use the
HTML conversion functions to convert " to " etc.
I found this helpful:
http://www.unixwiz.net/techtips/sql-injection.html
--
Bill Dodson
Parkline, Inc. http://www.parkline.com
phone: 304-586-2113 x149
fax: 304-586-3842
email: [EMAIL PROTECTED]
Email Disc
Shawn,
That's a very reasonable answer. Thanks for pointing me to the
examples. This one addresses the second question:
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.
html . There is no example answering both questions in one query.
Regards,
) < timestamp
GROUP BY qtreename,hostname
My questions:
>From which of the several averaged rows do 'allocated' and 'available'
come in the results?
Can I control this? I would like the row with maximu
How do you load data into a table and generate a primary key which
auto increments by 1.
I want to end up with a primary key value of int 1, 2, 3, 4, and so on.
My table has three rows, Id (pri_key), Code, Description. I'm loading
data from a text file into the table like this:
load data l
How do you load data into a table and generate a primary key which
increments by 1.
I want to end up with a primary key value of int 1, 2, 3, 4, and so on.
My table has three rows, Id, Code, Description. I'm loading data from
a text file into the table like this:
load data local infile '/U
e cell where I would expect to get
$ 7,842,554.24
Any idea what I'm doing wrong?
Clearly, I don't understand arrays very well.
Thanks VERY much for any help on this.
bw
---
Bill Whitacre
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
circumstances
though, I think rewriting it is the way to go.
Thanks again,
Bill
Quoting [EMAIL PROTECTED]:
Bill Duffy <[EMAIL PROTECTED]> wrote on 08/31/2005 11:32:02 AM:
When I run a query like this
DELETE FROM test_P_Cookie WHERE ViewID IN (SELECT ViewID FROM
test_x_RM_4508_48875
|
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
I tried this in MySQL 4.1.8, 4.1.12, and 4.1.14. Any help would be appreciated,
Bill
--
MySQL General Mailing List
For list archives: http://
Hi Shawn,
> Are transactions stable and supported (production ready) in MySQL? Yes,
> with one caveat. You must keep your data in InnoDB tables in order to get
> full commit/rollback support. MyISAM does not support automatic rollbacks.
> Is mysqli_xx written to properly use the built-in transacti
Hi Shawn
> The short answer is "Yes". Do you want a list of companies from the
> "Fortune 100" or are you interested in a particular business area? There
> are some huge names (http://www.mysql.com/customers/) that use MySQL for
> critical, public-facing, and infrastructure applications. Many of
> Hi
>
> Did someone use MySQLI in production environment ?
>
> Is the transactions aspect reliable ? (bugs etc)
>
>
> Thanks.
>
>
Sorry I should have specified that it's in the PHP environment.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi
Did someone use MySQLI in production environment ?
Is the transactions aspect reliable ? (bugs etc)
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
enter,
CONCAT(@neededStep, ' <= ', @startOfCenter),
CONCAT(@neededStep, ' > ', @startOfCenter)
);
It would seem that SET is a better way to create variables from constant
values, but I would like to understand why. Does anybody know what is
happening here?
Thanks for y
l public static void main(String[] args) {
long theLong = 4294967298L;
System.out.println("(int) 4294967298L = " + (int) theLong);
}
}
C:\javabox>java TestLong
(int) 4294967298L = 2
HTH
Bill
== original message follows ==
Date: Mon, 11 Jul 2005 13:54:12
the time to develop some SQL to get the data I would like to get.
However, I want to do this with a Korn shell script that emails the
report to a list of internal customers. Any help you can provide would
be greatly appreciated.
Thanks in advance,
Bill
If I use the options --single-transaction and --flush-logs with mysqldump
and InnoDB tables, does the new log file start at the same time as the
transaction?
If not, is it known for sure if the log file is switched before the
transaction starts or if it is switched after the transaction starts?
I
#x27;#' in literals when you specify them. The
good think about using perl is that you can handle all of these problems.
Hope that helps,
Bill
+---
| Bill MacAllister
| 14219 Auburn Road
| Grass Valley, CA 95949
--On Saturday, March 26, 2005 10
DispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
SQLException: SQLState(S1009)
Thanks
bill
--
MySQL General Mailing List
For list archives: http://lists.mysql
Bill Maidment wrote:
Hi
There doesn't appear to be any info. on the archives regarding this,
so does anyone know what character set/collation sequence to use for
EBCDIC rather than ASCII collation?
I discovered the /usr/share/mysql/charsets directory and added a
latin1_cp500_ci collation
Hi
There doesn't appear to be any info. on the archives regarding this, so
does anyone know what character set/collation sequence to use for EBCDIC
rather than ASCII collation?
Cheers
Bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Well, the answer is "no"--there's no magic way to have an auto_increment do
what you want.
You could use a GUID--basically a pseudo-random number such the expected
time to pick a duplicate is on the order of the lifetime of the universe.
But GUID's are big and ugly, and it would be nice to just ha
erent indexes are used. In your query above, with the inner join, MySQL
is going to first consider the join and then consider the use of indexes for
the where clause--so it ends up with the full table scan.
HTH,
Bill
= original message follows =
From: Fredrik Carlsson <[EMAIL PROTECT
Mike,
Try select * from foo order by x+0, x;
x+0 converts x to an integer by taking the digits from the beginning of the
string.
== original message follows ==
Date: Sat, 11 Dec 2004 15:36:34 -0600
From: Mike Blezien <[EMAIL PROTECTED]>
To: MySQL List <[EMAIL PROTECTED]>
Subject
) solution looks at more rows; on the other
hand, subqueries may not get as much optimization. I'd claim that the
subquery describes better what you want, while the count(distinct) is a
kludge to avoid the subquery.
- Original Message -
From: "Ron Gilbert" <[EMAIL PROTECTED]
t the clicks,
then left join that with the views.
HTH
Bill
From: Ron Gilbert <[EMAIL PROTECTED]>
Subject: Yet another LEFT JOIN question
Date: Sat, 4 Dec 2004 12:08:43 -0800
I have three tables, 'Ads' is a list of ads, 'Clicks' is a simple list
of every time a Ad was
number relay log files so
that someone doesn't have to check a replication server to see if the
filesystem for the MySQL data directory hasn't been filled by old relay
log files that haven't been accessed for some specified time?
Thanks in advance,
-bill
--
MySQL General Mailin
Martin,
The following will do the resequencing you requested. Hope it helps.
create table temporary_table select * from the_table;
set @T=0;
update temporary_table set id=(@T:=(@T+1)), the_time=the_time order by
the_time;
delete from the_table;
insert into the_table select * from temporary_table
person to be willing to come to my home in Des Moines,
WA. I will pay travel time also.
If interested contact Bill Cory at 253-946-0114
be fast, as it only has to look for one of each possible IP in
the larger table.)
HTH, Bill
Matthias Urlichs wrote:
>We have a slight opimization problem here.
>
>Given this table:
>
>CREATE TABLE `test` (
> `IP` varchar(15) collate latin1_german1_ci NOT NULL default '&
ing the master/slave
relationships and uncovered the bug in doing so.
Thanks in advance,
-Bill Thomason
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.total)>=15
and sum(a.dusers)>=6'
holds the key to my problem because reporting.linkdata and
reporting.users do not exist on the slave since it has no concept of the
database named reporting.
Is there a way to rework this query so that either there are no
references to the reporting datab
1.beds2
>> >and
>> > t2.beds2 to t1.beds
>> > do I need to store one of the fields temporarily?
>>
>>Hey chums you normally get me an answer in minutes, is my question too
easy?
>>zzapper (vim, cygwin, wiki & zsh)
>>--
>
>zzapper,
>
9, so you won't ever see the values for 2004-02-29. Maybe you only care
about an approximate result, and none of this matters.
- Original Message -
From: Dirk Schippers
To: Bill Easton
Cc: [EMAIL PROTECTED]
Sent: Monday, September 20, 2004 6:06 PM
Subject: Re: Query takes
y
WHERE putdatetime >= '2003-09-19' and putdatetime < '2003-09-20'
AND put=1 AND front=1
AND (MONTH(putdatetime) <> 2 OR DAY(putdatetime) <> 29)
ORDER BY putdatetime DESC
LIMIT 0,30
HTH, Bill
== Dirk Schippers wrote: ==
Date: Sun,
InnoDB doesn't use any *.MYI, only *.FRM. The indexes are in the data
files.
You might check the 4th byte of the .FRM file. x'0C'=InnnoDB, x'09'=MyISAM.
If the InnoDB data files are good, there was a post earlier this year from
Heikki Tuuri about how to get the structure from there.
If the .FR
Well, actually, there are 2.878 Meg rows, or 2878k.
What's happening is that it's using the index to find all of the rows where
changed > 0, then scanning for the maximum. If you just look for the
maximum, then discard it if it's not greater than 0, it will be much faster.
The following with Inn
Hmm, well... It really shouldn't take 2 min to select from an empty table,
no matter what you have in my.cnf.
So, something else is happening.
One way that InnoDB can take forever to read from an empty table is if
there's a transaction still in progress that was started some time ago.
Perhaps th
A few brief comments on this one...
(1) "Multi-threaded would probably cause thousands of problems"
Well, not necessarily.
Currently, the slave reads transaction A from
the relay log, executes its actions, commits it, then reads transaction
B, executes and commits. It wouldn't be unreasonable
SELECT dbo.lists_.Name_, COUNT(dbo.members_.EmailAddr_) AS nojgid
FROM dbo.lists_
INNER JOIN dbo.topics_ ON dbo.lists_.Topic_ = dbo.topics_.Title_
LEFT JOIN dbo.members_ ON dbo.members_.List_ = dbo.lists_.Name_
GROUP BY dbo.lists_.Name_,
The first inner join gives you a
select ListName, count(*), sum(Info is not null)
from ListTable
group by ListName
= Original Message Follows =
From: "John Berman" <[EMAIL PROTECTED]>
Subject: Count of two fields
Wonder if you can help
I have a table with a number of fields but the
List Name
Member
Info
Ever membe
SQL statement is rolled back--so you can get gaps. The reason
for this is so that two threads can independently insert records with an
auto_increment key without either one having to wait for the other. This
can make a substantial difference to the concurrency of transactions.
HTH
Bill
-
Peter,
My apologies on calling you Paul in my previous response instead of
Peter.
On Jul 9, 2004, at 10:30 PM, Peter Paul Sint wrote:
Bill, thank you for the prompt help.
This works.
I have just to find out how to get the Startup Item (or some
replacement) to open MySQL with --old_passwords
ly used
before when doing updates or installing some applications on OS X.
Lastly, restart MySQL and you should be all set.
On Jul 9, 2004, at 10:30 PM, Peter Paul Sint wrote:
Bill, thank you for the prompt help.
This works.
I have just to find out how to get the Startup Item (or some
replac
Your problem may have to do with the difference in how 4.1.x+ does
password hashing and that method is incompatible with older clients.
You might find some help with this document:
http://dev.mysql.com/doc/mysql/en/Old_client.html
Specifically check out the information regarding resetting the pa
Paul,
Has this class worked properly in the past? Have you tried executing
the queries your class executes manually via the mysql client or a
similar application removing your Java code from the equation? Have
you run 'check table' if the table is either MyISAM or InnoDB?
On Jul 7, 2004, at 1
3
column 3
--
-
Bill Doerrfeld[EMAIL PROTECTED]
Blue World Communications, Inc. http://www.blueworld.com/
-
B
--On Wednesday, June 30, 2004 07:36:23 PM -0500 Paul DuBois
<[EMAIL PROTECTED]> wrote:
At 13:58 -0700 6/30/04, Bill MacAllister wrote:
Hello,
I am a bit confused by processing of user= specifications in the
mysqld_safe script. Here is what I see:
* If user= is specificed in the [mysq
a bug?
Bill
+----
| Bill MacAllister, Senior Programmer
| PRIDE Industries
| 10030 Foothills Blvd, Dept 1150
| Roseville, CA 95747
| 916-788-2402
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
ad past this point in
the log. However, the master server is running along just fine, writing new info into
this log file just fine.
Is there any way to get the slaves past this bad record, short of manually resyncing
everything again?
Thanks for your help!
Bill Earl
Network Admin
www.bestbill.com
n 4.1? in earlier versions? and finally, is mysql 4.1 stable
enough to use in a production environment, or is that ill-advised?
thank you very much in advance,
--bill french
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
4
mysql_real_query 3
--
-----
Bill Doerrfeld[EMAIL PROTECTED]
Blue World Communications, Inc. http://www.blueworld.com/
---
On May 16, 2004, at 1:15 AM, Ron Gilbert wrote:
I have a table that is:
CREATE TABLE GPSData (
ID int(10) unsigned NOT NULL auto_increment,
Lat decimal(9,5) default '0.0',
Lon decimal(9,5) default '0.0',
TDate datetime default NULL,
PRIMARY KEY (ID),
UNIQUE KEY ID (ID),
KEY ID
rting Varchar
> From: [EMAIL PROTECTED]
> Date: Wed, 12 May 2004 18:13:17 -0400
>
> That didn't do it. I got 0,0,1050,1168,1195, 1975, 150,155,16500,170,178.
> . . The non-numerics came out last (which I want). There are two zeros
> but no negative numbers. Any alternatives?
>
> Ken
>
> You could also use "order by cost+0,cost". This puts the non-numerics
> first, then the numerics in numerical order. (You'd need to get fancier
> if there are non-numerics starting with a digit or numerics <= 0.)
>
> > From: Sasha Pachev <[EMAIL PROTECTED]>
> >
> > [EMAIL PROTECTED] wrote:
>
4
denied 4
--
-
Bill Doerrfeld[EMAIL PROTECTED]
Blue World Communications, Inc. http://www.blueworld.com/
---
curious.
> From: "Keith C. Ivey" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Date: Fri, 23 Apr 2004 11:27:38 -0400
> Subject: Re: first LIMIT then ORDER
> On 23 Apr 2004 at 7:23, Bill Easton wrote:
> > The last suggestion is useful when you do care wh
The last suggestion is useful when you do care which entries you get,
as you can use one order for limit and another for presentation.
For example, if you'd like the LAST 10 rows, but sorted in FORWARD
order, you can use something like
(select * from HISTORY order by version desc limit 10) ord
If you want to guarantee that the selections are different, rand()
doesn't quite do it, as you will get a repeated value with the
appropriate probability. You will need to keep a record of
what values have already been seen. Then, use something
like
select ...
from my_table left join my_recor
will have
- a row for each appointment in the given range
- a row for each patient who doesn't have an appointment
Then the where clause throws away the ones with appointments.
regards,
Bill
> From: "lorenzo.kh" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED
rd_len 5
--
-
Bill Doerrfeld[EMAIL PROTECTED]
Blue World Communications, Inc. http://www.blueworld.com/
-
Build and
e one just created.
(3) If the table you lost was InnoDB, change the 4th byte of the file
from hex 0C to hex 09. (This makes it look like a MyISAM .frm)
(4) You should be able to run "show create table foo" from the MySQL client.
HTH
Bill Easton
Lexpar
> Date: Tue, 23 Mar 2004 11:04:49
You can suppress writing the delete query to the binary log.
mysql>set sql_log_bin = 0;
mysql>delete ... ;
mysql>set sql_log_bin=1;
Bonnet R?my <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a database which is flushed every four hours,
> and
> I want to replicate it without replicating the del
6
script 6
--
-----
Bill Doerrfeld[EMAIL PROTECTED]
Blue World Communications, Inc. http://www.blueworld.com/
-
At 12:07 PM 2/24/2004, Keith C. Ivey wrote:
Sounds like it's your operating system's caching of the disk reads.
Yikes... that would explain it.
um... anyone know how to disable disk caching on Linux 2.6 kernel?
-bill
--
MySQL General Mailing List
For list archives: http://lists.mysql
ccumulated effect is slow, but each query generally isn't
that slow.
Yes, I'm using explain... that's usually how I work on slow querys, run
explain, try adding and index, etc. These queries already have indexes,
but in some cases they aren't fast.
-bill
--
MySQL Gene
1 - 100 of 533 matches
Mail list logo
