I had the same problem. I found the distribution contains some prototypes,
with slightly more elaborate names.
Regards,
Mike
kalin m [EMAIL PROTECTED]
03/18/08 01:06 PM
To
mysql@lists.mysql.com
cc
Subject
default my.cnf?
hi all...
i have a 5.0.33 build from source on a freebsd 4.10
Description:
When running the statements below, MySQL errors out with:
ERROR 1062 (23000) at line 5: Duplicate entry '1' for key 1 during SELECT
How-To-Repeat:
drop table if exists t;
create table t (f int not null);
insert into t values (1),(1);
select 1 from
t straight_join
t as t2
I just got an email from the list robot asking me to confirm my request to
unsubscribe. The only problem is, I did not ask to unsubscribe! Is
anybody else getting this?
Thanks,
Mike
$
Thanks,
Mike
PROTECTED] /]#
Thanks,
Mike
Jed Reynolds [EMAIL PROTECTED]
02/22/08 07:04 PM
Please respond to
[EMAIL PROTECTED]
To
Mike Spreitzer/Watson/[EMAIL PROTECTED]
cc
mysql list mysql@lists.mysql.com
Subject
Re: mysqldump: Got error: 1: Can't create/write to file
'dumpdir/tablename.txt' (Errcode: 13
-- 1 mysql mysql 29 Feb 22 20:46 foo.bar
-rw-r--r-- 1 root root 742 Feb 22 20:46 red1_p2.sql
-bash-3.00$
Thanks,
Mike
Jed Reynolds [EMAIL PROTECTED]
02/22/08 07:24 PM
Please respond to
[EMAIL PROTECTED]
To
Mike Spreitzer/Watson/[EMAIL PROTECTED]
cc
mysql list mysql@lists.mysql.com
.
Thanks,
Mike
Thanks to both Dans, that's it. This even discussed in the refman, at (
http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html).
In my case, COUNT(*) found 25,682,600 rows and it took about 7 minutes.
Thanks,
Mike
and
use another instance of the GUI administration tool.
If I succeed in interrupting this operation, presumably the rollback will
take quite a while. How can I tell whether I have successfully
interrupted the operation and the rollback is what's nailing my machine?
Thanks,
Mike Spreitzer
SMTP
choice of batch operations.
My second question is: if I have indeed done something grossly stupid,
what is the best (if there is any at all!) way to interrupt it and
proceed.
I am running MySQL 5.0.51a-community on RHEL 4, storage on one local disk.
Thanks!
Mike
the final data in the new column. So I infer there is no big motivation
to interrupt the operation I have going.
Thanks,
Mike
Baron Schwartz [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/19/08 08:13 PM
To
Mike Spreitzer/Watson/[EMAIL PROTECTED]
cc
mysql@lists.mysql.com
Subject
Re: How bad
is the correct syntax to order by the
alpha characters, first??
TIA,
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder-rain.com
===
--
MySQL General Mailing List
For list
Seconds_Behind_Master
--
Mike Johnson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: Dan Rogart [mailto:[EMAIL PROTECTED]
On 11/14/07 4:01 PM, Mike Johnson
[EMAIL PROTECTED] wrote:
Correction to a couple of replies I've seen -- a slave
server can have more than one master, but not to the same
database. That is, Slave reads Database1 and Database3
from
to
check on that. Not likely, though.
As for how to set it all up, don't ask me. I just enjoy the results.
:)
(apologies if you get a dupe, Baron -- I accidentally hit reply, not
reply-to-all)
--
Mike Johnson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: Mike Morton [mailto:[EMAIL PROTECTED]
Sent: Monday, October 29, 2007 5:39 PM
To: mysql@lists.mysql.com
Subject: Fulltext Relevancy
.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: Mike Morton [mailto:[EMAIL PROTECTED
for the starting point for finding that mistake Baron! :)
*knocks head against wall repeatedly*
On 10/30/07 5:09 PM, Baron Schwartz [EMAIL PROTECTED] wrote:
Mike,
Mike Morton wrote:
OK - I am at a total loss here :)
We have added an addition fulltext field with the highest rating:
match
on this? The term vic used in this case is the search string
submitted by the user.
You can see the search in action at
http://www.tienda.com/support/search.html
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED
the solution is either remarkably simple or
frustratingly difficult. Thanks in advance if you can help!
--
Mike Johnson Smarter Travel Media LLC
Applications Developer http://www.smartertravel.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
[EMAIL PROTECTED] ~]# perror 13
OS error code 13: Permission denied
check permissions that it is read/write for the mysql user
On 9/14/07, Haig Dedeyan [EMAIL PROTECTED] wrote:
Hi everyone,
all of a sudden today, I keep getting the error mentioned in the subject
when I open the dbase in
am I doing wrong? Any ideas?
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A common issue a lot of people have is this
rm logfile
if the mysql server is still accessing that file it will not continue to
write to that file again till mysql is restarted
if that was the case the proper way to clear a log and keep the server
running is
cp /dev/null logfile
On 8/20/07,
2007 16:19, Mogens Melander wrote:
MD5() is not an encryption function. The MySQL manual states:
--
Mike Aubury
Aubit Computing Ltd is registered in England and Wales, Number: 3112827
Registered Address : Murlain Business Centre, Union Street, Chester, CH1 1QP
--
MySQL General Mailing List
turn on slow query logging.. maybe one or more of the db's got too big and
your queries are running slow
Mike
On 8/10/07, Steve Grosz [EMAIL PROTECTED] wrote:
I am running a MySql server, ver. 4.1.7-max on a P3 with 512meg of RAM.
It has been running fine for the past year, nice and quick
buffer size or eliminating more rows from the
query.
-Original Message-
From: Mike Zupan [mailto:[EMAIL PROTECTED]
Sent: Friday, 10 August 2007 4:52 AM
To: mysql@lists.mysql.com
Subject: remove temporary table from SELECT query
I have been pulling my hair out over a temporary table
neither of those have fixed the issue.. I can create a sample database if
anyone wants it to be of some help.
Mike
On 8/10/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Also, its not good to set sort_buffer_size=256M, as this much of memory
will get allocated to each session, and if u have more
Yes it will take a long time depending on the size of the index also
On 8/10/07, x x [EMAIL PROTECTED] wrote:
I'm attempting to add an index to a table with 70
million rows.
DB server running on a reasonably fast Intel Mac on a
relatively slow drive.
Should this take hours to complete ?
I have been pulling my hair out over a temporary table being created in the
following query
SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS entryid,title FROM
friends_test INNER JOIN entries ON friendLink=userid AND userLink=2 order by
entryid
if I change userLink=2 to friendLink=2 it is fine and its
, but was
wondering if this can be accomplished within the actual query itself.
TIA,
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder-rain.com
===
--
MySQL General Mailing List
Chris,
- Original Message -
From: Chris Boget [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]; MySQL List
mysql@lists.mysql.com
Sent: Monday, June 25, 2007 2:15 PM
Subject: Re: Birthday format
we have a simple query to calculate someones birthday:
SELECT (TO_DAYS(CURDATE
thanks, worked prefectly,
Mike
- Original Message -
From: Jerry Schwartz [EMAIL PROTECTED]
To: 'Mike Blezien' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Monday, June 25, 2007 3:01 PM
Subject: RE: Birthday format
mysql SELECT FLOOR(54.75);
+--+
| FLOOR
2007 21:07, Mike Blezien wrote:
thanks, worked prefectly,
Mike
- Original Message -
From: Jerry Schwartz [EMAIL PROTECTED]
To: 'Mike Blezien' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Monday, June 25, 2007 3:01 PM
Subject: RE: Birthday format
mysql SELECT FLOOR
- Original Message -
From: Mike Aubury [EMAIL PROTECTED]
To: mysql@lists.mysql.com; Mike Blezien [EMAIL PROTECTED]
Cc: Jerry Schwartz [EMAIL PROTECTED]
Sent: Monday, June 25, 2007 3:44 PM
Subject: Re: Birthday format
I might be wrong - but isn't that going to mess up on or around
, but that is (in my opinion) an unnecessary step that could be handled
at the database query
Thanks!
Sample query:
Select * from development order by status
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED
!
- --
Mike Lockhart Information Engineer
ChoiceMed, Inc
Email: [EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (Darwin)
iD8DBQFGVxxcgCgDHkdt5m8RAqTOAKCAdoL4JSjUzsKG1Y9/wdcTCeSdswCffwOy
YO0ALUVivjv7ZDFfXUAbn1M=
=J52W
Well,
you can save all data encoded in the database:
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_encode
- Mike
Chris schreef:
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information
quite nicely, on a LINUX system.
MySQL Backup Script VER. 2.5 - http://sourceforge.net/projects/automysqlbackup/
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder-rain.com
anyone done this before?? on Paths
and Storeing into a database
anyone have code examples
- --
Mike Lockhart Information Engineer
ChoiceMed, Inc
Email: [EMAIL PROTECTED]
-BEGIN PGP SIGNATURE
Hi
I read the Google blog post regarding these patches. They admit using
MySQL for some internal data storage needs but not in the general search
system. Here is the link to the blog post
http://google-code-updates.blogspot.com/2007/04/google-releases-patches-that
-enhance.html
Mike
Hello everybody,
I got a small problem with ordering on en ENUM field. The values in this
field are:
- to be started
- started
- finished
- canceled
And i want to order on this field, but in the direction the are above
here (and not alpabetically).
Is that possible?
- Mike
--
Medusa
WHEN 'now hiring' then 3
WHEN 'waiting' then 2
WHEN 'closed' then 6
END AS sorted_grade
FROM v_issue_project_task
ORDER BY sorted_grade
- Mike
Medusa, Media Usage Advice B.V.
Science Park Eindhoven 5216
5692 EG SON
tel
Out of curiousity, what should be done if they results are different. We checked
on one of boxes and got two different results:
SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'),
- UNIX_TIMESTAMP('2007-03-11 03:00:00');
people have mentioned in this thread.
But they all appear to be related to overseas timezones so I'm not too
concerned about them.
-Ryan
Mike Blezien wrote:
Out of curiousity, what should be done if they results are different. We
checked on one of boxes and got two different results:
SELECT
have you try using the datatype YEAR for you table field/column ?
Mickalo
- Original Message -
From: John Berman [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, February 19, 2007 11:45 AM
Subject: Year - Field type
Hi
Using mysql4
Sure this is an easy one a field in my
,
`english` text,
`spanish` text,
`active` char(1) default 'n',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7096 ;
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED
PHP)
TIA - hope someone can help!
--
Cheers
Mike Morton
*
* Tel: 905-465-1263
* Email: [EMAIL PROTECTED]
*
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Mike:
:) I wish! Free ham for everyone!
I had already changed the min length to 2 actually - so that is not the
affecting factor...
It is more of an issue to prioritizing fields for relevance, and whether it
is possible to do this within a fulltext query, or whether it needs to be
done
2 john
3 mary
4 lisa
5 me
I need a select that always retrieves id 1 and an interval
of my choice:
--
Mike Aubury
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
The area by the Santa Clara convention center is pretty dead, but you
can take the light rail to downtown San Jose and there is a pretty
lively nightlife there, lots of interesting restaurants, The Tech Museum
and other things depending on you interests.
Also there are lots more interesting
bether preformance from this query?
- Mike
Hello, I pinned down the problem to the order by line. If i leave this
away the query is done in 0.05 seconds.
- Mike
Mike van Hoof schreef:
Hello,
i have the following query:
SELECT DISTINCT (
Waarde
) AS bestemming
FROM xml_kenmerk
WHERE Omschrijving = 'Bestemming
end) or a v followed by a space.
so it should match:
'b test'
'test b'
'test b bv'
'bv b test'
and NOT
'test bv'
'bv test'
Any idea's?!
Thanks, mike
--
Medusa, Media Usage Advice B.V.
Science Park Eindhoven 5216
5692 EG SON
tel: 040-24 57 024
fax: 040-29 63 567
url: www.medusa.nl
mail
end) or a v followed by a space.
so it should match:
'b test'
'test b'
'test b bv'
'bv b test'
and NOT
'test bv'
'bv test'
Any idea's?!
Thanks, mike
)
He shouldn't select this one, because it says 'bv' and no other b
Mike
ViSolve DB Team schreef:
Hi,
[ERROR 1139 (42000): Got error 'repetition-operator operand invalid'
from regexp]
because,
In your query,
'!' is an Operator and ? is a wild character. Only wildcharacters
should be follow
than than
buying. If you think I am wrong on either of these points, please share your
thoughts and send a
link to a recommended system.
Sincerely,
Mike
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http
Can anyone point me in the direction of some examples of using the
libmysqclient API for reading/writing blobs ?
I'm currently reading the data from some dynamic SQL using
mysql_stmt_bind_result mysql_stmt_fetch - and want to add the BLOB
datatypes
TIA
--
Mike Aubury
--
MySQL
Andre Matos wrote:
The idea is to have a audit trail to record the changes made. So, I want to
insert a new record in the staff table and right after this, insert a
record in the changes table.
SET AUTOCOMMIT=0;
START TRANSACTION;
INSERT INTO staff (`Name`) VALUES ('ABC');
INSERT INTO changes
Andre Matos wrote:
SET AUTOCOMMIT=0;
START TRANSACTION;
INSERT INTO staff (`Name`) VALUES ('ABC');
INSERT INTO changes (`Key`, `Table`, `Value`) VALUES (LAST_INSERT_ID(),
'staff', 'ABC');
COMMIT;
SET AUTOCOMMIT=1;
This works fine in my test environment, however what about many users doing
at
Andre Matos wrote:
Thanks Mike.
I understand the possible gaps that I might have if I use the ROLLBACK.
This is acceptable in my case.
What I really want to avoid is what I am doing now: open one transaction to
insert, or update, or delete certain information and close with the commit
//
mysql CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
- DETERMINISTIC
- LANGUAGE SQL
- BEGIN
- RETURN CONCAT('Hello, ',s,'!');
- END;
-
- //
Query OK, 0 rows affected (0.01 sec)
mysql delimiter ;
mysql select hello(Mike);
+---+
| hello(Mike
Filipe Freitas wrote:
Hi,
This is not a mysql thing but maybe you can help me.
I want to call a stored procedure from PHP, so I tried it like normal
querys: mysql_query(CALL mySP();); with no success.
What is happening when you make the call? That might help get some more
precise advice.
My
For any specific table if you do:
show create table tablename;
It will tell you what the able was created using. To create tables using
a specific engine add ENGINE=name to the end of your create statement.
To see the default that is used (I think this is what the table_type
variable does):
This is in 4.0, it has changed in more recent versions.
Mike Kruckenberg wrote:
For any specific table if you do:
show create table tablename;
It will tell you what the able was created using. To create tables
using a specific engine add ENGINE=name to the end of your create
statement
that mysqlhotcopy is built to use.
Mike
James Tu wrote:
The first time I tried to run the mysqlhotcopy script, I got an error
that indicated that Perl couldn't find the DBI module.
So, I found a site (http://www.quicomm.com/apm_dbddbi.htm) that
stepped me through making and installing
MySQL DBD
Peter Van Dijck wrote:
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I have 1,000,000s of url rows), what's
the best approach? varchar has a 255 maximum, right? Should I just use
TEXT? I'm not searching *in* the urls, I am selecting like
zipcode Perl modules
on
Cpan, but nothing for helping calculation distances. Can someone point me in the
right direction to accomplish this ... thx's :)
TIA,
Mike(mickalo)Blezien
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Chris,
this is something very similar to what we are attempting to accomplish:
http://www.papajohnsonline.com/restlocator/RestaurantLocator
Mike
- Original Message -
From: Chris W [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]; MYSQL General List
mysql@lists.mysql.com
Sent
someFieldInMyTable='%[1]%'
Mike
--
Medusa, Media Usage Advice B.V.
Science Park Eindhoven 5216
5692 EG SON
tel: 040-24 57 024
fax: 040-29 63 567
url: www.medusa.nl
mail: [EMAIL PROTECTED]
Uw bedrijf voor Multimedia op Maat
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
someFieldInMyTable is CONCATed to ,1,2,3,4,5,6,9,21, and over that
value the where clause is done...
Maybe it helps
Mike
Charlie Schaubmair schreef:
Hello Mike,
thx, but isn't there another way?
br
Charlie
-Ursprüngliche Nachricht-
Von: Mike van Hoof [mailto:[EMAIL PROTECTED
Sorry, query was wrong... has to be:
SELECT *, CONCAT(',',someFieldInMyTable,',') as wherefield FROM MyTable
WHERE wherefield LIKE '%,1,%'
Mike van Hoof schreef:
Hey Charlie,
maybe there is, but i don't know why... because when you do a like
query it also finds the 21 when you do a like
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder-rain.com
===
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
It's PHP I believe, oscommerce web site, MySQL 4.0.27. this is for an associate
of ours and I am not much of a PHP programmer, strickly Perl :)
Mike
- Original Message -
From: Dan Buettner [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent
://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html
cheers,
--renato
Or if your tables are not identical you can use a LEFT JOIN:
http://www.tizag.com/mysqlTutorial/mysqlleftjoin.php
Mike
--
Medusa, Media Usage Advice B.V.
Science Park Eindhoven 5216
5692 EG SON
tel: 040-24 57 024
fax: 040-29
Is this list still working ?
Mickalo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1. Get as much memory as possible.
2. Get the fastest disks you can. Ones with fast access time and 10 or
15K RPMs are best.
3. I think SCSI has a slight advantage over SATA but they are more
expensive also. So only get them if it doesn't have a negative effect on
1 or 2.
4. Use whatever $$$
] : NULL); } } mysql_close(conn); return 0; }
*
Please help me in this regard.
-
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2¢/min or less.
--
Mike Aubury
a very simple mysql connector already, as well as
postgres, ODBC).
--
Mike Aubury
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a workaround for this (and not converting to a BLOB
is not an option... sorry)
Mike
--
Medusa, Media Usage Advice B.V.
Science Park Eindhoven 5216
5692 EG SON
tel: 040-24 57 024
fax: 040-29 63 567
url: www.medusa.nl
mail: [EMAIL PROTECTED]
Uw bedrijf voor Multimedia op Maat
--
MySQL
Addison, Mark schreef:
From: Mike van Hoof Sent: 18 July 2006 12:18
To: Addison, Mark
Subject: Re: Converting TEXT to BLOB with special chars
Addison, Mark schreef:
From: Mike van Hoof Sent: 18 July 2006 10:49
Hello,
I am having
Chris Sansom schreef:
At 13:40 +0200 18/7/06, Mike van Hoof wrote:
Well.. gonna try some text-converting in php then...
And yeah, it really needs to be a blob field... not my choice, but we
got a CMS which operates on field types from MySQL... and a blob
field wil generate an WYSIWYG field
can i get back
4 | ABC | new company 1 name
8 | DEF| new company 2 name
--
Mike Aubury
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a SELECT statement for MS SQL that is
SELECT TOP 1 id FROM menu_links ORDER BY id desc
and need to convert it to MySQL. I cannot find what will do that.
Help is greatly appreciated.
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Mike wrote:
I have a SELECT statement for MS SQL that is
SELECT TOP 1 id FROM menu_links ORDER BY id desc
and need to convert it to MySQL. I cannot find what will do that.
Help is greatly appreciated.
TIA
Mike
SELECT id FROM menu_links ORDER BY id desc LIMIT 1
--
MySQL
I guess I had the LIMIT in the wrong location.
Thanks for the help!
Mike
Mike Wexler [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Mike wrote:
I have a SELECT statement for MS SQL that is
SELECT TOP 1 id FROM menu_links ORDER BY id desc
and need to convert it to MySQL. I
J.R. Bullington wrote:
The best way to do this is with code, however, here is A way to do it (I am
sure that there are more than one...)
UPDATE tbl_Name SET ZipCodes = concat('0',ZipCodes) WHERE length(ZipCodes) =
4
How about
UPDATE tbl_Name SET ZipCodes = right(concat('0',ZipCodes),
Hello,
we need to query one of database tables that sore usernames, and many of them
have spaces in them that need to be removed. what would be the correct function
to identify each username column value that has a space(s) in them?
TIA,
Mike(mickalo)Blezien
--
MySQL General Mailing List
Gerald,
- Original Message -
From: Gerald L. Clark [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Thursday, June 08, 2006 8:40 AM
Subject: Re: correct syntax
Mike Blezien wrote:
Hello,
we need to query one of database tables
would be much appreciated.
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder-rain.com
===
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi Sheeri,
Is your 'u.modified' column a TIME datatype '00:00:00'
Mike
- Original Message -
From: sheeri kritzer [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Wednesday, May 17, 2006 9:10 AM
Subject: Re: Baffled by query error syntax
= 9
AND SUM(c.agent_product_time) = '500' GROUP BY a.account_id
ORDER BY mins
ERROR: # - Invalid use of group function
Any help appreciated...
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Solution that Work
http://www.thunder
Tried that, still same error. If I remove the 'AND
SUM(c.agent_product_time) = '500'
then it works, but I need this in the query.
Mike
- Original Message -
From: Ing. Edwin Cruz [EMAIL PROTECTED]
To: 'Mike Blezien' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Tuesday
corrected it and still the same error.
Mike
- Original Message -
From: Chris Sansom [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]; MySQL List
mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 12:56 PM
Subject: Re: Baffled by error
At 12:29 -0500 16/5/06, Mike Blezien wrote
Peter,
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 1:07 PM
Subject: Re: Baffled by error
Mike Blezien wrote:
Hello,
MySQL 4.1.12
trying to figure out why I keep
Peter,
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 1:25 PM
Subject: Re: Baffled by error
Mike,
How would this query be constructed with the HAVING clause,
not real
Gordon,
thank you, works prefectly now.
Mike
- Original Message -
From: Gordon [EMAIL PROTECTED]
To: 'Mike Blezien' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 3:17 PM
Subject: RE: Baffled by error
Try this
SELECT c.account_id,
a.name
of server without have to upgrade alot of other stuff ?? Or can we
build it from source, and if so, what is the recommend configure options used to
build from source ?
TIA,
Mike(mickalo)Blezien
===
Thunder Rain Internet Publishing
Providing Internet Solution that Work
we where hoping to avoid all that, if possible :) it's not much of a product
server anymore, just for some small developement.
I guess we'll stick with what's installed.
Mike
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, April 21, 2006 5:38 PM
under the mysql.server group add:
[mysql.server]
# datadir location
datadir = /var/lib/mysql
then restart MySQL and assuming you've create the necessary folder and related
database(s) that will be stored there.
Mike(mickalo)Blezien
===
Thunder Rain Internet
Hello,
I'm trying to locate the RPM downloads for MySQL version
4.0.26(4.0.26-pc-linux-gnu-i686), for a RH/7.3 system, but can't seem to find
them. Doesn't MySQL site have older version archives where these older RPM's can
be downloaded ... if so, where would they be located ??
TIA,
Mike
101 - 200 of 1406 matches
Mail list logo