do you even know that
affects you?
Jeff
pgpeYgKL0ynpT.pgp
Description: PGP signature
On Tuesday 07 December 2004 12:58 pm, Ronan Lucio wrote:
The following thread appeared in the FreeBSD list:
snip
Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can
affect me.
I may have missed it, but myisam, or innodb?
Jeff
pgpSqggIBC6My.pgp
Description: PGP signature
'. These
are all on myisam tables.
Jeff
pgpruzBlF9R3z.pgp
Description: PGP signature
with MySQL + FreeBSD-4.x, I´m
afraid that the table could crashs when MySQL hangs... :-/
Sounds like a local issue, not mysql.. I would go after that over bandaging
mysql.
Jeff
pgpRjYfpgJ4bj.pgp
Description: PGP signature
On Tuesday 07 December 2004 02:03 pm, Victor Pendleton wrote:
A function on the left hand side will nullify the use of an index.
Sides dont matter, a function on an index, no matter what side, will kill an
index.
Jeff
pgpsVFJcgS9kp.pgp
Description: PGP signature
where date1.date = date2.date;
The above query, no matter which side you use a function on, will cause the
index to be thrown..
Jeff
pgpCPAUJk2r7Y.pgp
Description: PGP signature
plan.
Jeff
pgpNKQ0K5Llcr.pgp
Description: PGP signature
route. These major
upgrades are no small tasks anyway.
Jeff
pgpV2KwnnCgL1.pgp
Description: PGP signature
On Tuesday 30 November 2004 01:36 pm, Steve Grosz wrote:
I had installed MySql on Win2003, and when I check the 'server
information' page, it shows a IP of 127.0.0.1. The IP of the server has
a 192.x.x.x address.
Change the line below in my.cnf to what you need.. Its binding to 127 ip.
#
to test these new features in 4.1..
Might want to look for that in 3.23..
Jeff
pgpomOHXppHgb.pgp
Description: PGP signature
.. ;)
Jeff
pgpv5iABnmP3v.pgp
Description: PGP signature
to.
Jeff
pgpQkZExiFA1H.pgp
Description: PGP signature
.. This is assuming your not coping the entire db directory tree..
Maybe someone else knows of another.
Jeff
pgp9Z7ari8lOX.pgp
Description: PGP signature
On Monday 22 November 2004 04:15 pm, Santino wrote:
I can confirm it anyway: I think we have a bug.. Unless someone else see
something, might want to take this to bugs.mysql.com
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 578 to server version:
On Sunday 21 November 2004 08:38 am, Dayakar wrote:
Can any one help me in creating view using mysql4.1. If we cannot then any
other alternative. It would be great if anyone give me an example for that.
Thats a 5.0 feature.. Your not gonna get to far with 4.1..
Jeff
I have table with 83,065 rows. Each time I go to MySQL Administrator and
look at the catalogs, the number of Rows reported by the administrator
changes. I can keep clicking refresh and the number of rows fluctuates
between roughly 81,000 and 86,000. I also see similar behavior when I
access the
Thanks. Makes sense ... but strange.
Jeff
Brent Baisley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
It's because the table type is InnoDB. InnoDB tables can only give and
estimate of how many rows are in the table. That's just the way InnoDB
works.
From the manual:
SHOW
as work arounds. When they update DBD::mysql this should
go away.
There is a new version for this..
DBD-mysql-2.9004
I think thats the version that started supporting it.
Jeff
pgp06SFsJVeZj.pgp
Description: PGP signature
those indexes on there. that just slows down
inserts.
Jeff
pgpaA9bNx47Mt.pgp
Description: PGP signature
On Monday 15 November 2004 03:25 pm, Jeff Smelser wrote:
insert delayed is a myth.. Least in the 4.1 version. 4.1.18 it was taken
out.
Course thats 4.0.18.
pgpBoy3BGuPlh.pgp
Description: PGP signature
On Sunday 14 November 2004 11:34 am, Robb Kerr wrote:
I'm posting to test a new newsgroup client. Please post several replies.
Does it work with mysql?
Just curious.
Jeff
--
===
Jabber: tradergt@(smelser.org|jabber.org
.. select * needs to be a field.. like zip.
Jeff
--
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: I don't miss deadlines, I ignore them
daily
notifempty
compress
rotate 2
}
Jeff
pgp7Axkk8RKjY.pgp
Description: PGP signature
as well..
There is a default login in mysql, I think your getting in as that, but not
able to do anything.. Make your your host variables are right.. Check your
logs to make sure your getting is as who your expecting to be.. (show
processlist even).
Jeff
pgpa5Z4LVImkC.pgp
Description: PGP
customer from the Transaction table.
I tried this...
UPDATE Customer,Transactions set Customer.First_Transaction =
MIN(Transactions.Datestamp)
Where Customer.ID = Transactions.CustID
But this doesn't work because of MIN() grouping. I'm stumped, anyone
know how to accomplish this?
Thanks,
Jeff
Yeah I thought of that but was hoping not to have to use a temp table.
Thanks!
Jeff
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 05, 2004 9:25 AM
To: Jeff McKeon
Cc: [EMAIL PROTECTED]
Subject: Re: Update query help
Break it down into two
,
`trnsfr` char(1) default 'n',
PRIMARY KEY (`id`)
) TYPE=MyISAM
Jeff
pgp8Z1dDKHSNN.pgp
Description: PGP signature
Administrator is geared towards dba's of mysql..
MySQL Query Browser, is to run sql's, and so forth. Stored procedure
creation..
They are very different if you had read the product descriptions.
Jeff
pgpRJjCrqe5K9.pgp
Description: PGP signature
situation.. Thats a
5.x feature that suppose to be added.
Jeff
pgp6dWXXCLanp.pgp
Description: PGP signature
Anybody?
Jeff Burgoon [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Sorry, I forgot to mention I am using version 4.0.20a (no subqueries
supported)
Jeff Burgoon [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have a simple problem and I'm just wondering the BEST
Good one. I don't know how I missed this either!
Thanks!
gerald_clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What about
select distinct a.region, a.city
from mytable a , mytable b
where a.region=b.region and a.city b.city
Jay Blanchard wrote:
[snip]
Anybody?
I
FROM MyTable
GROUP BY Region
HAVING cnt = 2;
SELECT MyTable.*
FROM MyTable, Duplicates
WHERE MyTable.Region = Duplicates.Region;
Can anybody tell me if there is a more efficient way of doing this query?
Thanks!
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Sorry, I forgot to mention I am using version 4.0.20a (no subqueries
supported)
Jeff Burgoon [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have a simple problem and I'm just wondering the BEST query to solve it.
I want to return all the rows of a table whose foreign key value
This will solve your problem and remove the need for the PHP correction.
SELECT lname, teamno, game_pts, sport_pts, ref_pts, adjust_ref_pts,
CASE
WHEN ref_pts + adjust_ref_pts 15 THEN game_pts + 15
ELSE game_pts + ref_pts + adjust_ref_pts
END AS total_pts,
CASE
WHEN ref_pts + adjust_ref_pts 15
I see from the release notes that tables with timestamp column will need
to be rebuilt. will the server automatically do this upon startup?
thanks,
jeff
--
Jeff Mathis, Ph.D. 505-955-1434
Prediction Company [EMAIL PROTECTED]
525 Camino de los Marquez
and less error prone. this was one example where
conceptually we thought it should be able to be done -- and it can, if
you use a nested select.
thanks again to all for helped. we're on to bigger and better things...
jeff
Michael Stassen wrote:
Jeff Mathis wrote:
well, obviously some, if not all
.
something like this:
select max(close_date), symbol, name from TD where symbol in (list of
characters) group by symbol;
this returns the max close_date value, but the name that is returned is
garbage and seems to point to the earliest row in the table.
any suggestions?
jeff
ps we're using
(close_date), symbol, name from TD where symbol in
(list of
characters) group by symbol;
this returns the max close_date value, but the name that is
returned is
garbage and seems to point to the earliest row in the table.
any suggestions?
jeff
--
Jeff Mathis, Ph.D. 505-955
|
+-++-+
| 2004-10-05 | aa | cmptrhw |
| 2004-10-05 | bb | biotech |
| 2004-10-05 | cc | biotech |
+-++-+
but we can't seem to fomrulate the query.
Jeff Mathis wrote:
Ed Lazor wrote:
-Original
to know if right there..
Jeff
pgpS5L2p8iK4l.pgp
Description: PGP signature
On Thursday 14 October 2004 03:12 pm, Stuart Felenstein wrote:
Thanks , I know the page and have the links
bookmarked!
So you got the answer from it right?
Jeff
pgpSsmcBOJscM.pgp
Description: PGP signature
we really don't want to issue two queries. this should be able to be
done in one, and without using temp tables, but maybe not.
thanks for the help though
jeff
[EMAIL PROTECTED] wrote:
It takes two steps: first determine the max(closedate) for each symbol,
then use those results to get the name
On Thursday 14 October 2004 03:35 pm, Stuart Felenstein wrote:
No :),. cause it seems that those formats are for
outbound, db -.
I was looking for the other direction.
Huh? It really doesnt matter does it? They work either way..
I use those functions all the time for inbound..
Jeff
correct. You just need to convert the date into -MM-DD
hh:nn:ss format and MySQL will be as happy as a clam.
That, or str_to_date will work nicely for what he is looking for.. Which was
my point..
Jeff
pgpXlFpQANUPu.pgp
Description: PGP signature
that he
didn't see anything think for inbound.. I was saying there was.. If he doesnt
have the version, its left to the client.. which he didn't specify.
My answers can only be as good as the questions.. He left a lot open..
Jeff
pgpowCDfiCISX.pgp
Description: PGP signature
.
I tried to run this query:
delete from account, survey;
//But the query crashes.
Any ideas how to delete data for more than one query.
TH
--
Jeff Mathis, Ph.D. 505-955-1434
Prediction Company [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6
4.1.3 and the innodb engine on solaris 5.8
Brad Eacker wrote:
Jeff Mathis writes:
now, leaving off name from the group by clause
(select max(close_date), symbol, name from TD
where symbol in ('aa','bb','cc') group by symbol;)
gives
+-++-+
| max(close_date
.
what we want to get is conceptually simple, but perhaps not so in terms
of SQL.
jeff
Michael Stassen wrote:
No, Shawn's answer is correct. You are starting from a false
assumption. You are expecting that MAX(closedate) corresponds to a row.
It does not. Consider the table
Table=stuff:
sym val
a foreign key is.. It has nothing to do with
speeding anything up..
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
Jeff
pgpeUrEIaz9k1.pgp
Description: PGP signature
one, other then to recreate the db.. That I know of.
Jeff
pgpeOFdWpcR3a.pgp
Description: PGP signature
the end)?
My limited testing seems to say that this is the case. However,
the documentation is silent on this issue. I would prefer not
to count on this if is not guaranteed.
Jeff;
--
* RSS Feeds: http://www.syndic8.com
* Blog:http://www.syndic8.com/~jeff/blog/
* Developer Books: http
it is.
i'm eagerly waiting fixes for this myself.
jeff
Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Hello:
I have recently posted the message attached at the bottom of
this one to the mailing list. Since then, I have continued to
work the sporadic
On Wednesday 06 October 2004 02:10 pm, Scott Hamm wrote:
Like I said before it seems to group by threads. Therefore, it is
close enough.
Right! thats why Microsoft thrives. Because as long as it appears to work, its
all good.. :)
Jeff
pgpAXe4d5h6QD.pgp
Description: PGP signature
:submitter ID
Originator: Jeff
Organization:
organization of PR author (multiple lines)
MySQL support: [none | licence | email support | extended email support
]
Synopsis:synopsis of the problem (one line)
Severity: [ non-critical | serious | critical ] (one line)
Priority
with it..
Jeff
pgpZ3q0X0WvJ5.pgp
Description: PGP signature
On Tuesday 05 October 2004 01:55 pm, you wrote:
We're not perfectionist like you. :)
Actually its proper email etticate.. look it up if you don't believe me..
Jeff
pgpjB48FEXyL0.pgp
Description: PGP signature
On Tuesday 05 October 2004 01:56 pm, David Brodbeck wrote:
Saves having to retype the list address, or look it up. I don't see what
difference it makes...
Click on the email, on mine, it brings up a nice to empty message with the
email address..
Jeff
pgp50O9uZVT4t.pgp
Description: PGP
On Tuesday 05 October 2004 02:23 pm, David Brodbeck wrote:
Well, that's nice...
Hmm
I just don't see what difference it makes. As far as I can see, the
outcome is identical either way...
Cause your doesnt support threads.. Outlook was the only one I knew off that
did not.
Jeff
]
In-Reply-To:
[EMAIL PROTECTED]
Jeff.
pgpgRjZu4Ewfs.pgp
Description: PGP signature
that when the cron is running, the changes made to this table
don't replicate properly to slave DB. Anyone has same experience? I
checked 'show slave status' but no Last_error or Last_errno was found.
Define properly?
Jeff
pgpLp7xvfln8d.pgp
Description: PGP signature
Why does selecting backslash give me an error?
select \
gives me...
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'\' at line 1
select /
returns /
select \\
returns \
What's the deal w/
I'm populating a new table from excel sheets and for some silly reason
several column values are populated with \ (not my doing!).
I can easily fix the problem but I was just wondering.
Thanks Everyone.
Jay Blanchard [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
[snip]
What's the
.. Are you serious? thats all you do, create indexes?
Jeff
pgpqSbV4EnhVQ.pgp
Description: PGP signature
for the
users
thanks
-bruce
ps. if need to, i could provide sample sql statements/table defs...
--
Jeff Mathis, Ph.D. 505-955-1434
Prediction Company [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6http://www.predict.com
Santa Fe, NM 87505
this:
- The following addresses had transient non-fatal errors -
Well, I am replying to this, with that email in the CC.. Will see if they get
it.. If you dont see a reply, it worked fine for me.
Jeff
pgpGtYooYiukR.pgp
Description: PGP signature
that influences this locking?
- what strategies do people use to alter live busy tables ?
Thanks for any and all input!
Jeff Kolber
ps: we are using:
mysql Ver 12.18 Distrib 4.0.12, for pc-linux (i686)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
and part names have been created
as columns. Then part quantities are aggregated.
Can anyone offer any guidance?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. For this
reason, I am unable to make use of SQL variables and temporary tables. I
must instead use persistant tables.
Can anyone tell me if this is in fact the case and if so, any suggestions on
how to get over this hurdle?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http
4.0.20a-max, just because I thought this was the most stable build.
Victor Pendleton [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What version of MySQL are you using? I believe multiple delimited
statements are available in 4.1.x and later.
Jeff Burgoon wrote:
I'm writing my
, can you tell me how you turn it on/off?
Thanks again!
Victor Pendleton [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What version of MySQL are you using? I believe multiple delimited
statements are available in 4.1.x and later.
Jeff Burgoon wrote:
I'm writing my first MySQL app
the connection. I am nearly 100%
certain that the combined statements in the oRS.Open... line will work
for you. Let us know if it does or doesn't, OK?.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Jeff Burgoon [EMAIL PROTECTED] wrote on 09/21/2004 08:54:27 AM:
I'm
. I would think that if there was no ID
with a value of 5, then it would return 0. But if there is a row with
an ID of 5, then it should refresh the row and return 1. Right?
-Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
-around.
Unless, as has been suggested, there's a way to change the functionality
of the DataProvider.
-Jeff
Brent Baisley wrote:
I'm not following why you need to force an update? You mentioned a row
refresh, but I'm not sure in what context. If you are looking to find
out if a row has changed since
with the appropriate keyword(s). I just need a
little direction and some detailed information on how connections and
pooling works.
I'm using ASP.NET/VB.NET with CoreLab's MySQLDirect on a Windows 2003
IIS server with the latest windows version of MySQL, if that matters.
TIA
-Jeff
--
MySQL General Mailing List
On Sunday 05 September 2004 11:44 am, Leandro Melo wrote:
Hi,
how can i make a back of the data in my database?
check out mysqldump
--
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: Nothing fails like prayer. -- Annie
Hello all,
We had a power outage this morning and before we could shut down our
main MySQL server, power to it was lost. Bad UPS battery. Long
story.
We replicate this server to two others. On one I get the following
error...
Jeff McKeon
IT Manager*** 1. row
performance is not impacted at all.
jeff
sean c peters wrote:
I have some data that is stored by the year it is related to. So I have one
table that stores the Year the data is related to, among other things. At any
given time, 1 year is considered the 'active year', and the rest are
considered
`smalltables.php`
The script runs show tables and filters out those that I don't
want to back up. By using an exclusion list, I don't have to
add new tables to the list very often.
Jeff;
On Tue, 31 Aug 2004 15:23:35 -0500, Paul DuBois [EMAIL PROTECTED] said:
At 16:13 -0400 8/31/04, Emi Lu wrote
On Saturday 14 August 2004 01:06 am, [EMAIL PROTECTED] wrote:
mysql mysqldump b
- c:/hdump/dump.sql
Do it from the command line, not mysql command prompt.
--
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: We don't
I have the following table:
+-+-+
| ID_AGE | ID_ENTRY |
+-+-+
| 1 | 1 |
| 1 | 4 |
| 1 | 5 |
| 2 | 1 |
| 2 | 2 |
|
of
the . characters into something else on the way in, and then back on
the way out, but that smells funny.
Any ideas?
Jeff;
--
* RSS Feeds: http://www.syndic8.com
* Resume: http://www.syndic8.com/~jeff/resume.html
* MSN IM: [EMAIL PROTECTED]
* Developer Books: http://www.developer
:(
oh well. its not that mission critical, and I executed a database wide
update to set all timestamp columns to current_timestamp(). at least
i'll know when we did the upgrade.
jeff
Victor Pendleton wrote:
There is are five new time_% tables. You could install 4.1.3 in a clean
area, export
problem. we're using Connector/J to load the data.
is this a know issue?
jeff
--
Jeff Mathis, Ph.D. 505-955-1434
Prediction Company [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6http://www.predict.com
Santa Fe, NM 87505
--
MySQL General Mailing List
after lokking at this, it appears that our float(11,9) columns cannot
store an number larger than 100 or smaller than -100. the database is
rounding the number! If we insert numbers -100 x 100, then its fine.
is there a configuration setting somewhere, or is this a known bug?
thanks
jeff
Jeff
the decimal,
so only 2 digits are allowed before the decimal.
sean peters
[EMAIL PROTECTED]
On Thursday 05 August 2004 15:47, Jeff Mathis wrote:
after lokking at this, it appears that our float(11,9) columns cannot
store an number larger than 100 or smaller than -100. the database is
rounding
that this was a bug that was then fixed, and I just
happened to get nipped by it.
jeff
Dan Nelson wrote:
In the last episode (Aug 05), Jeff Mathis said:
after lokking at this, it appears that our float(11,9) columns cannot
store an number larger than 100 or smaller than -100. the database is
rounding
jeff
--
Jeff Mathis, Ph.D. 505-955-1434
Prediction Company [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6http://www.predict.com
Santa Fe, NM 87505
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
On Wednesday 04 August 2004 06:44 am, Odhiambo Washington wrote:
Is there hope for me in this situation??? I have googled and googled but
all that I see doesn't seem to help me to recover the data in the table.
This makes me very desparate.
I'd be very thankful for any pointers that would
the server starts, it allocates all the space you
requested. if the server cannot find the space at startup, you get an
error. if during an import the file size is exceeded, you get an error
and the import stops. you cannot overrun your disk.
jeff
[EMAIL PROTECTED] wrote:
I agree with David
write screnerio is bad news for replication..
You have to realize the slave has to process everything the master does..
Replication is good for more of more read/ some write scenerio.
You need a cluster..
Jeff
--
===
Jabber
This is the 2nd
Hope this helps. God bless!
-Jeff Gannaway
___
http://RadioU.com
This Is Where Music Is Going - Listen Online!
___
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Is there a way to get the output of a select into outfile statement to
have the column headers in it and not just the data?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, SystemID) SELECT CustomerName,
ModelNumber, SerialNumber, CertificateNumber, AverageFluidViscosity,
JobNumber, SystemID FROM 50041_job
Jeff Blasius
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
for either ProductsNEW or ProductsOLD. The data
comes from our distributor, and they don't have any field which would be
unique from record to record. If a primary key is essential, I can
pre-process the tables to create one.
Thanks in advance for your help!!!
-Jeff Gannaway
are different.
Thanks!!
-Jeff Gannaway
___
http://RadioU.com
This Is Where Music Is Going - Listen Online!
___
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
compare 1 table to 1 table.
How do I do this?
-Jeff Gannaway
___
http://RadioU.com
This Is Where Music Is Going - Listen Online!
___
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
|
+---+---++
Here's my Query
SELECT a.ProductID FROM ImportLiebermansStep3Add a
LEFT JOIN ProductsOLD b ON a.PUBLISHER=b.Vendor AND a.NUMBER=b.VIN
WHERE b.ProductID IS NULL;
But this query runs, and runs, and runs, and runs, and runs without ever
giving results.
What am I missing???
Thanks!
-Jeff Gannaway
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 05 July 2004 06:07 pm, Gary Mack wrote:
Hi there,
I am having trouble converting a timestamp from mySQL to the US Format
mm/dd/. Can someone please help. I am also having trouble converting
-mm-dd into a normal mm/dd/
not have replication as that is
the files used for replication.
Jeff
- --
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: Stale tagline. Go get some new ones.
While you're at it, would you get me
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 12:46 pm, J S wrote:
Thanks for your reply.
By replication do you mean do I have tables with duplicate rows? If that's
the case then I do have one table with duplicate rows.
No.. Replication, meaning, you have the same
201 - 300 of 828 matches
Mail list logo