,
`trnsfr` char(1) default 'n',
PRIMARY KEY (`id`)
) TYPE=MyISAM
Jeff
pgp8Z1dDKHSNN.pgp
Description: PGP signature
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
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
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
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
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
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
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:
.. This is assuming your not coping the entire db directory tree..
Maybe someone else knows of another.
Jeff
pgp9Z7ari8lOX.pgp
Description: PGP signature
.. ;)
Jeff
pgpv5iABnmP3v.pgp
Description: PGP signature
to.
Jeff
pgpQkZExiFA1H.pgp
Description: PGP signature
to test these new features in 4.1..
Might want to look for that in 3.23..
Jeff
pgpomOHXppHgb.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.
#
plan.
Jeff
pgpNKQ0K5Llcr.pgp
Description: PGP signature
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
before the machine stop responding ?
HP Pentium4 - 2.2mhz - 512 mb, 99% used and no swap, HD of 40GB.
What table type you using?
Jeff
pgpaVttIiLwf1.pgp
Description: PGP signature
On Thursday 09 December 2004 01:06 pm, Patrick Marquetecken wrote:
and for ansewring Jeff Smelser i have installed mysql 4.x on linux and then
dit from the commandline create database and then run the create table
commands from snort.
No idea.. you can do a show create table db.table to find
rename the files in step 3, just in case,
right?
Jeff;
On Fri, 8 Oct 2004 16:34:31 +0300, Dobromir Velev [EMAIL PROTECTED]
said:
Hi,
According to the manual -
http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html
http://dev.mysql.com/doc/mysql/en/InnoDB_File_Defragmenting.html
running a null
choose to add the /bin/ directory of MySQL to the path, during the
installation.
Do the developers read these messages as well? If not, where should I
report the problem?
bugs.mysql.com..
Jeff
pgpWdoIKbXEGb.pgp
Description: PGP signature
in my search for an equivalent method in MySQL or even an
alternative. Any help, hints or suggestions are welcome,
Cast will work, its in every DB..
Jeff
pgpbdMaJFEcXW.pgp
Description: PGP signature
count anything.
So the select count(*) theory isnt correct.
Jeff
pgpywUqJPtAY0.pgp
Description: PGP signature
is this insert/select not working?
insert into the_db (place,address,number) values(stuff,stuff2,select
this from that where one=two);
i tried ()s around the 'select' too but it didn't work.
thanks.
--
Jeff Mathis, Ph.D. 505-955-1434
Prediction Company
that is inserted by B
while A is running is not visible to A. If A is re-started all the data
that was inserted by B is now available.
A is a plotting program and B is a data importer process.
Any clue on what may be going wrong?
Thank you in advance.
Jose.
--
Jeff Mathis, Ph.D. 505
) is actually used? I would like to
have an idea of the data space progression? Per database (I have 3).
Thank you in advance
Johanne Duhaime
IRCM
courrier: [EMAIL PROTECTED]
--
Jeff Mathis, Ph.D. 505-955-1434
Prediction Company [EMAIL PROTECTED
to selecting the data from the table I would like to be able to select
all the data and decrypt any fields as required. Is this possible with one
query, or do I have to select every data item then decrypt it then present
the data?
Wouldn't select decode(col1) from table work?
Jeff
whatever is in that column, was encoded.
Jeff
pgpDfYZf8nbn6.pgp
Description: PGP signature
for the right
syntax to use near '))' at line 1
your right, i was mistaken.. I use:
select des_decrypt(des_encrypt(foo)); which works fine..
I am not sure what version he is using, but that should have worked.
Jeff
pgp7spCyw8ane.pgp
Description: PGP signature
On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote:
is it possible to force a field to be NOT NULL but not
have any default value (I.E the insert statement must
explicitly provide data for the field in question)?
of course: col1 int not null
Jeff
pgpKRoQG6Ktfo.pgp
Description: PGP
something?
Thanks
Jeff
--
Jeff Mao
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
,...
Thanks for any other ideas!
Jeff
At 2:09 PM -0600 2/10/05, Jay Blanchard wrote:
[snip]
In the past, I've always simply installed these two pieces as I
mentioned above and everything was so easy,but it's been awhile
since I last did this,did I miss something?
[/snip]
Permissions?
--
MySQL General
steps every time!
Jeff
At 8:55 PM + 2/10/05, mel list_php wrote:
I'm not sure if it can be a password problem as you can connect
through command line,but when upgrading to 4.1 I had the classical
access deny error with phpmyadmin whereas everything else was ok.
You can still have a look
I'm running Mac OS X,...so if the the disable and rebuild isn't too
hard, can you outline that process?
Jeff
Probably because they don't have the time to get the latest and greatest
client library every time. I'm not sure how to rebuild it on Windows but
you can disable the built in on unix
Argh,...this is what happens when you leave your sysadmin job to
become a bureaucrat! Lost my edge I guess,...I just looked again at
what I downloaded earlier today to install,...and I had the version
for Mac OS X v 10.2 and not 10.3,...
Thanks all for your help!
Jeff
At 8:29 AM +1100 2/11/05
earlier,...
Is this a Mac OS X thing? Or is this normal? Do all the rest of you
have newer version of MySQL recognized by php/apache?
Thoughts?
Thanks in advance
Jeff
--
Jeff Mao
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Thanks,...that's the info I needed to help me know where to look for
a solution,..I'll direct my work on the php side of things!
Jeff
At 9:07 AM -0800 2/11/05, Hassan Schroeder wrote:
Jeff Mao wrote:
I'm back,...I've removed MySQL completely and reinstalled it using
the binaries for Mac OS X
for Macs,...I'm checking back on his site to
see if this was an oops on his part or by design, etc,...
Jeff
At 1:19 PM -0500 2/11/05, Dean, Michael L USAATC wrote:
Jeff,
When you upgraded to the 4.1 version of MySQL did you run the
mysql_fix_privilege_tables script? I just upgraded a 3.23
to start all over.
Jeff
pgpd6v4TIoxmG.pgp
Description: PGP signature
will work.
Then you can solve why its not resolving.
Jeff
pgpmTQHtRMU79.pgp
Description: PGP signature
are ridiculously messy as you can guess.
You have a server thats on DHCP? Well, your problem is dhcp I am sure.. But
good luck with that horror flick.
What is this world coming to.
Jeff
pgpZsHHBXfcXQ.pgp
Description: PGP signature
.. Since its a
binary.
Jeff
pgpG4TIEO5elB.pgp
Description: PGP signature
copy for innodb too,
but you have to pay for it.. (something like that anyway)
Jeff
pgp6nYOwRR6P1.pgp
Description: PGP signature
and.or pointers would be greatly appreciated.
No, LOG is a all or nothing type thing.. LOG-ERROR gets you
warnings/notes/errors though.. (an not all the other stuff). I do wish i
could get a log with connections, without every query that goes through the
system..
Jeff
pgpH7HCKlY9wF.pgp
.
Is there a way to un-install this and start COMPLETELY from scratch?
It did work once.
Jeff J.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
installed it.
Something is still goofy.
Jeff J.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Okay, so MySQL is now installed and running. It looks like a database
named test was created with no tables. Is this just used for
installation purposes? Can it now be deleted or is there a reason to
keep it? Or does it have some magical purpose like the mysql
database?
Jeff
--
MySQL
Using the OSX MySQL Administrator, when Stop Server is clicked under
the Service tab, the server doesn't stop. In fact, the only way I
have been able to quit the MySQL process is through the Activity
Monitor, and a force quit at that. What's up with that?
Jeff
--
MySQL General Mailing List
with both the MySQL preference pane and the Administrator utility.
Jeff
On Mar 16, 2005, at 10:56 PM, Michael Stassen wrote:
It should be in mysql's bin directory, typically /usr/local/mysql/bin.
You either need to add that to your PATH,
export PATH=$PATH:/usr/local/mysql/bin
or use the full path
for me, it is time well spent to try and get the GUI
working.
Jeff
On Mar 17, 2005, at 10:31 AM, Michael Stassen wrote:
You can't call TextEdit from the command line like that, you have to
launch it in the GUI. That doesn't really matter, though, as you do
not want to use TextEdit, because
of MySQL for OSX?
Jeff
On Mar 17, 2005, at 10:46 AM, Jeff Justice wrote:
Okay...now we're getting somewhere. Thank you. Adding the file
wasn't the problem, I just wasn't sure WHERE it should be added. Yes,
I am using 10.3. Just trying to pin down why the GUI tools can't seem
to start
file in /var/lib/mysql for
messages. Look at the last entries in the file.
That is what got mysql version 4 running on my FC3 box.
Jeff Steinkamp - N7YG
Tucson, AZ
SCUD Missile Coordinates
N32-13-52 W110-52-15
http://home.earthlink.net/~jksteinkamp
http://n7yg.webhop.org
/mysql/en/reset-slave.html
Jeff
pgpqS6H2r2My8.pgp
Description: PGP signature
Yes, there is a MySQL beta version of the administrator, but be warned,
it has many bugs that I personally believe makes it unusable.
Jeff J.
On Apr 7, 2005, at 8:35 AM, Brent Baisley wrote:
If you are looking for a GUI admin, MySQL has released a beta of MySQL
Administrator for OSX. MySQL
, the mysqld_safe script says it's:
- using /export for data
- using a .pid file in /export
- exits without starting mysql.
There are no other error messages.
Can datadir be set to /export successfully? If yes, is there some other
configuration that needs to be changed?
Thanks
Jeff
there..
If your missing bin log files, then you need to set up the master to not
delete logs the slave has not processed yet. This would assure your up to
date, once the slave comes back alive..
Or am I missing something?
Jeff
pgpsJU5d3COjX.pgp
Description: PGP signature
missing out
somehow.
Thanks
Jeff
, anyone have insights into doing with Canadian
Zip Codes or otherwise optimizing a database of Canadian Zip Codes?
Jeff Kolber
http://www.ForSaleByOwner.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 4/16/05, Scott Gifford [EMAIL PROTECTED] wrote:
Jeff Kolber [EMAIL PROTECTED] writes:
How are sites doing the search by zip and coming up with results within x
miles? Is there some OSS zip code download that has been created for this?
The ones I'm familiar with use this:
http
://www.mtsu.edu/~itd Information Technology Division
Jeff Hinds, ocp
Database Specialist
Middle Tennessee State University
001 Cope Administration Building
Murfreesboro, TN 37132
mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
tel:
fax:
(615) 898-5719
(615) 898-5720
links to 5 corresponding records in table2,
I want to pull the latest record from table2 where table2.parentid = 100
and table2.user not like 'john'
There is a datestamp field in table2.
I just can't figure out how to do this.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http
Thanks all but I don't have a mysql version high enough for subqueries.
Thanks,
Jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:01 PM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: Re: Query question
Jeff,
Something
Peter,
I'm unfamiliar with the @d := section you describe. Is this psudo
code or real syntax?
thanks,
Jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:17 PM
To: Jeff McKeon
Cc: mysql
3.23.
no control over this right now or i'd upgrade, believe me!
jeff
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 4:43 PM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: Re: Query
25, 2005 4:36 PM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: RE: Query question
Jeff McKeon [EMAIL PROTECTED] wrote on 04/25/2005
04:08:29 PM:
Thanks all but I don't have a mysql version high enough for
subqueries
I'm running MySQL 4.0.14 and it's locking tables for everything including
counting records and select statements. I don't use any lock statements.
Has anyone else encountered this? Any suggestions?
Thanks,
Jeff
__
Do You Yahoo!?
Tired
I have a number of very large text files I need to import. The first line of each
file contains the field names. Is there a way to automatically create the
associated tables based on the filed names in the first line of the text file,
then import the data using LOAD DATA INFILE?
Thanks
Jeff
?
Thanks,
http://www.mtsu.edu/~itd Information Technology Division
Jeff Hinds, ocp
Database Specialist
Middle Tennessee State University
001 Cope Administration Building
Murfreesboro, TN 37132
mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
tel:
fax:
(615) 898-5719
(615) 898
|
+---+
./mysqlshow
+---+
| Databases |
+---+
| test |
+---+
Please give me some pointers on where to go to fix this. I have googled and
searched the archives and I haven't come up with anything that works.
--Jeff
--
MySQL General Mailing List
For list
pointers on where to go to fix this. I have googled
and searched the archives and I haven't come up with anything that works.
--Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing
into the dark) I have binlogs starting from Nov 12, a
snapshot from sept 10th. Is there some way anyone can suggest that I
can reconstruct the database table with what I have?
Best Reguards,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Interesting idea.
So if I take the table from Sept 10th and then do that with the binlog
I'll be missing about 2 months worth of data because my earliest binlog
file is Nov 12th.
The queries are always one to a line in the binlog?
Best Reguards,
Jeff
-Original Message-
From
://dev.mysql.com/doc/mysql/en/CREATE_VIEW.html
Jeff
pgpLkLDLqUMyZ.pgp
Description: PGP signature
together in another cell,...
=C1 - D1 - right(A1,2)
Look at the functions left, right, mid to see how to pull out parts,...
Jeff
*
Jeff Mao
Coodinator of Educational Technology
Maine Department of Education
23 State House Station Augusta, ME 04333
On Wednesday 01 June 2005 10:40 am, Josh Trutwin wrote:
Just curious - was there a 5.0.5-beta release? The last beta I had
was 5.0.4 unless I missed a release announcement...
You need to read that email.. it says it was never released.
Jeff
pgpk9pJzWINTK.pgp
Description: PGP signature
files, then starting the db when done. Does mysqlhotcopy
allow you to take a full snapshot of the db without needing to shut it
down? What happens to read writes and updates while mysqlhotcopy is
running?
Any info or experiences anyone has would be greatly appreciated.
Thanks,
Jeff
--
MySQL
Am I right in assuming that while mysqlhotcopy is running, nobody else
can write to or update the DB?
Jeff
-Original Message-
From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED]
Sent: Friday, June 03, 2005 2:24 PM
To: Jeff McKeon; mysql@lists.mysql.com
Subject: Re: mysqlhotcopy
I
On Friday 03 June 2005 03:36 pm, Joey wrote:
SET PASSWORD FOR mailto:'user'@'localhost' 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Why not recompile php to work with 4.1?
--old-password
Jeff
pgpEctk2PnMK1.pgp
Description: PGP signature
is the best way
to get this fixed...
Jeff
pgpWnixubL90D.pgp
Description: PGP signature
On Wednesday 08 June 2005 10:56 am, you wrote:
In the last episode (Jun 08), Jeff Smelser said:
On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
Subqueries in 4.1 are totally broken. They don't use indexes.
They're evil. We're told we have subqueries but there's no way
anyone
..Or direct them to the right person..
Jeff
pgpSieE9hrblQ.pgp
Description: PGP signature
On Wednesday 08 June 2005 11:49 am, you wrote:
Easy there boss, I was just responding to the thread and meant no
offense. I saw the whole thing as funny.
Oh.. email sucks that way..
My apologies as well..
Jeff
pgpvHgJLsGjaw.pgp
Description: PGP signature
On Wednesday 08 June 2005 10:57 pm, George Sexton wrote:
1)Why can't I declare a datetime field with DEFAULT NOW()
4.1 has options to default timestamps on update/inserts or both..
Jeff
pgp2pHd6mM2jF.pgp
Description: PGP signature
with the timestamp of when the query would have actually been
inserted?
Jeff
pgpGXWuwLb4Lp.pgp
Description: PGP signature
?
Jeff
pgpqFlRnr8VLc.pgp
Description: PGP signature
..
Why do you keep bringing this up?
Jeff
pgp6PCudsBfQQ.pgp
Description: PGP signature
keep mine to 1.5 and all the others are really low or turned off.
Jeff
pgpTAtr1JpbRo.pgp
Description: PGP signature
Anyone using any third party products like Arkeia that enable you to do
a live backup of MySQL database?
I'm searching for a backup solution for our new data center and would
like to here what other people are using for MySQL.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http
Yes, that's the way we currently do it but we were looking for more
options.
Jeff
-Original Message-
From: Kieran Kelleher [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 16, 2005 11:26 AM
To: Jeff McKeon
Cc: mysql@lists.mysql.com
Subject: Re: Backing up live MySQL Databases
I
kernels have things to let you go over, but you get weird
results when doing so.
Jeff
pgpzqaIko4NhJ.pgp
Description: PGP signature
701 - 800 of 828 matches
Mail list logo