: Gabriel Linder [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Friday, January 19, 2007 9:43 PM
Subject: Request problem (with \\)
Hello list,
I am currently trying to fix a bug in a search function with a request
like this one :
select * from forum where topic like
Unable to manage user accounts through MySQL Administrator 1.2.8. I've found
that I'm not the only one with this problem but no one seems to have an answer
for it.
The problem is that when you select a user in the user list of the prog the
user's detail don't appear on the right side so
Ed Reed wrote:
Unable to manage user accounts through MySQL Administrator 1.2.8. I've found
that I'm not the only one with this problem but no one seems to have an answer
for it.
Have you reported a bug to bugs.mysql.com ?
kind regards
--
Colin Charles, Community Engineer
MySQL AB
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ed Reed wrote:
Unable to manage user accounts through MySQL Administrator 1.2.8. I've found
that I'm not the only one with this problem but no one seems to have an
answer for it.
The problem is that when you select a user in the user list
There was already a bug report submitted. That's where I found other users that
have the same problem.
Colin Charles [EMAIL PROTECTED] 1/17/07 6:05 PM
Ed Reed wrote:
Unable to manage user accounts through MySQL Administrator 1.2.8. I've found
that I'm not the only one with this problem
to manage user accounts through MySQL Administrator 1.2.8. I've found
that I'm not the only one with this problem but no one seems to have an
answer for it.
The problem is that when you select a user in the user list of the prog the
user's detail don't appear on the right side so that they can
Hello
I've got a problem,, I've tried to search the archive for this list with no
luck.
Maybe it's because Unicode problems isn't that rare...
Anyway ..
Here is my problem.
Sorting on a VARCHAR collate utf8_swedish_ci (table with default charset
utf8)..
As many probably know
Hello there
I was wondering if someone having great knowledge of FreeBSD chroot system
could give me some help. I trying to run MySQL and Apache under a chroot
envoirnment. But I am getting these errors. Could you please help me to
solve these problems. I have googled a lot but did't find any
On Sun, Jan 07, 2007 at 12:50:34PM +0100, VeeJay wrote:
I trying to run MySQL and Apache under a chroot envoirnment. But I am
getting these errors.
[ ... ]
# /usr/local/mysql/libexec/mysqld: Can't create/write to file
'/var/tmp/ibPM3e0d' (Errcode: 13)
[ ... ]
fopen: Operation not
Hi,
today I've experienced a problem that I don't understand and I can't solve!
I've created a table as follows:
---
CREATE TABLE `ft_test` (
`id` int(11) NOT NULL auto_increment,
`field1` varchar(255) NOT NULL ,
`field2` varchar(255) NOT NULL ,
`field3` text NOT NULL,
PRIMARY KEY
devy wrote:
---cut---
-
insert into ft_test (field1,field2,field3)
VALUES('mysql full text', 'this is a test', 'mysql fulltext');
-
the problem is that when I execute this query I always get 0 as
relevance:
---cut---
A FULLTEXT search will not match return
it in the VARIABLES.
HTH!
J.R.
From: devy [EMAIL PROTECTED]
Sent: Thursday, January 04, 2007 8:54 AM
To: mysql@lists.mysql.com, [EMAIL PROTECTED]
Subject: Fulltext problem
Hi,
today I've experienced a problem that I don't understand and I can't solve
With so few rows, are you hitting the 50% rule? Try again with a decent
number of rows.
-Original Message-
From: devy [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 04, 2007 5:46 AM
To: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: Fulltext problem
Hi,
today I've
Many thanks for your kind response. I was using a form that was submitted twice
for any given new ssn. I have also benefited from your comments on how to write
a better java code. Turns out my html and javascript skills need improvement.
Many thanks again.
Regards
David Griffiths [EMAIL
Here is the code:
ps = con.prepareStatement(select first, last from cust where ssn=?);
int ssnint = Integer.parseInt(ssn.trim());
ps.setInt(1, ssnint);
ResultSet rs=ps.executeQuery();
if ( rs.next()) {
rs.close();
I tried everything you suggested. 'Think it is the way I have set up
the table in MYSQL. This is the table
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
This is a little dangerous as well; if an exception gets thrown, the
statement doesn't get closed. My sample code is below.
That said, your query looks fine. Add logging to your code to figure out
what's going on. Run your query by hand against your database; I suspect
you have an issue
I am getting the same result in Java code, i.e. the resultset returned is
non-null even though the primary key value is not found in the table.
Hassan Schroeder [EMAIL PROTECTED] wrote: On 12/29/06, murthy gandikota
wrote:
I am posting the relevant JSTL code.
Just to clarify: you're *not*
Hello,
I have hab problem with mysqlbinlog. I'm testing point in time recovery. The
Server Version of MySQL is 5.0.22.
Statement:
./mysqlbinlog --stop-date=2006-12-29 08:40:00 logfile | mysql -u user -p
The error:
ERROR at line 12: Unknown command '\C'.
By piping the output in a file line 12
Hi
I have created a table with the following specs:
create table `cust` (
`ssn` int(9) NOT NULL PRIMARY KEY,
`submitdate` date,
`submitto` int(3),
`first` varchar(30),
`last` varchar(30),
`loanAmt` decimal(10,2),
`company` int(3),
I dont think product_beta.test is a table...It seems to be a view..
what is the create statement for it..
show create table product_beta.test; ???
-Lakshmi
Ruan wrote:
Hi everybody,
I have a very strange table problem - a table was created in one of our
databases, but I can't seem to drop
PROTECTED]
Sent: Friday, December 15, 2006 10:43 AM
To: Ruan
Cc: mysql@lists.mysql.com
Subject: Re: Strange table problem
I dont think product_beta.test is a table...It seems to be a view..
what is the create statement for it..
show create table product_beta.test; ???
-Lakshmi
Ruan wrote:
Hi everybody
At 03:44 AM 12/15/2006, Ruan wrote:
Hi,
The dump revealed this:
+
| View | Create View
| test | CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY
DEFINER VIEW `test` AS select `beta_users`.`user_id` AS
LOL - Now I feel silly.
Thanks that worked.
R
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Friday, December 15, 2006 5:37 PM
To: mysql@lists.mysql.com
Cc: mysql@lists.mysql.com
Subject: RE: Strange table problem
At 03:44 AM 12/15/2006, Ruan wrote:
Hi,
The dump
5.0.27: character problem
Hello, I'm using MySQL version 5.0.27 under Windows XP
professional. I
have a text file with some SQL commands (I create a few tables and
insert some rows into them). I noticed that all columns where
I tried to
insert a swedish character, that character got corrupted
: news [mailto:[EMAIL PROTECTED] On Behalf Of Eric Lilja
Sent: Wednesday, December 13, 2006 2:03 PM
To: mysql@lists.mysql.com
Subject: MySQL 5.0.27: character problem
Hello, I'm using MySQL version 5.0.27 under Windows XP
professional. I
have a text file with some SQL commands (I create a few tables
:[EMAIL PROTECTED] On Behalf Of Eric Lilja
Sent: Thursday, December 14, 2006 2:13 PM
To: mysql@lists.mysql.com
Subject: Re: MySQL 5.0.27: character problem
Thanks for the reply, Mr Schwartz. I will see if I can find
some clue on
how to write such a program myself.
- Eric
Jerry Schwartz
Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Eric Lilja
Sent: Thursday, December 14, 2006 2:13 PM
To: mysql@lists.mysql.com
Subject: Re: MySQL 5.0.27: character problem
Thanks
Of Eric Lilja
Sent: Thursday, December 14, 2006 4:36 PM
To: mysql@lists.mysql.com
Subject: Re: MySQL 5.0.27: character problem
Here's what I get when I perform mysql show variables like char%;
+--+-+
| Variable_name| Value
Thanks for the help, Jerry, I think I solved it. I opened the script (a
standard windows text file) in UltraEdit. It can convert between some
different text formats. After some experimenting it seems that selecting
the conversion ansi-to-oem does the trick! It's now inserted properly
into
Hi everybody,
I have a very strange table problem - a table was created in one of our
databases, but I can't seem to drop it.
I tried with phpmyadmin and with mysql from command-line.
If I try to view it I receive this error:
View 'product_beta.test' references invalid table(s
To: mysql@lists.mysql.com
Subject: MySQL 5.0.27: character problem
Hello, I'm using MySQL version 5.0.27 under Windows XP
professional. I
have a text file with some SQL commands (I create a few tables and
insert some rows into them). I noticed that all columns where
I tried to
insert a swedish character
Hello, I'm using MySQL version 5.0.27 under Windows XP professional. I
have a text file with some SQL commands (I create a few tables and
insert some rows into them). I noticed that all columns where I tried to
insert a swedish character, that character got corrupted. But it works
if I type
---
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 December 2006 10:55 AM
To: Ed Pauley II
Cc: mysql@lists.mysql.com
Subject: Re: Replication Problem?
Ed, this is unfortunately
I am a novice with Unix and user of MySQL on windows…..
I have a problem, i.e.
I want to install MySQL5.0 at my FreeBSD 6.1 box with following
configurations:
--prefix=/usr/local/mysql
--with-mysqld-user=mysql
--with-unix-socket-path=/tmp/mysql.sock
--with-mysqld-ldflags=-all-static
---
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 December 2006 10:55 AM
To: Ed Pauley II
Cc: mysql@lists.mysql.com
Subject: Re: Replication Problem?
Ed, this is unfortunately
VeeJay wrote:
I am a novice with Unix and user of MySQL on windows…..
I have a problem, i.e.
I want to install MySQL5.0 at my FreeBSD 6.1 box with following
configurations:
--prefix=/usr/local/mysql
--with-mysqld-user=mysql
--with-unix-socket-path=/tmp/mysql.sock
--with-mysqld
We recently upgraded to MySQL 5.0. Since upgrading I have noticed that
queries of the form INSERT INTO test.test_table VALUES('test','1') no
longer replicate. If you connect to or change to the test database and
then execute INSERT INTO test_table VALUES('test','1') the query
replicates. Is
Ed, this is unfortunately by design. Personally I don't get why this
choice was made...
Reference:
http://lists.mysql.com/mysql/190869
Regards,
Atle
FCI, Inc. - Unix Systems Administrator
On Tue, 12 Dec 2006, Ed Pauley II wrote:
We recently upgraded to MySQL 5.0. Since upgrading I
Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 December 2006 10:55 AM
To: Ed Pauley II
Cc: mysql@lists.mysql.com
Subject: Re: Replication Problem?
Ed, this is unfortunately by design. Personally I don't get why this
choice was made...
Reference:
http
problem
On Thursday 07 December 2006 04:57, nikos wrote:
WHEN x50 THEN ceiling(x+x*0.25)
when x=50 AND x100 then ceiling(x+x*0.20)
when x=100 AND x150 then ceiling(x+x*0.15)
when (x=150 AND x200) then (ceiling(x+x*0.10))
when (x=200) then (ceiling(x+x*0.09))
You've declared a return value
this message in context:
http://www.nabble.com/Syntax-Problem-tf2779708.html#a7755229
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a query running within a project from a Windows machine retrieving
data from a Linux Source the query works perfectly. If i upload the exact
same project to the Linux machine and run it the query doesnt work ??!!??
the query string is ...
SELECT DISTINCT ID, BatchID FROM Contacts
Field was wrongly named - Cheers!
--
View this message in context:
http://www.nabble.com/Syntax-Problem-tf2779708.html#a7756233
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Hello list.
Can somebody tells what's wrong with this fuction?
DELIMITER $$
DROP FUNCTION IF EXISTS `qbit`.`myprice_xondr`$$
CREATE FUNCTION `qbit`.`myprice_xondr`(x float(7,2)) RETURNS float(7,2)
BEGIN
CASE x
WHEN x50 THEN ceiling(x+x*0.25)
when x=50 AND x100 then
Can somebody tells what's wrong with this fuction?
I guess that depends on what it should do, wouldn't it?
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development
On Thursday 07 December 2006 04:57, nikos wrote:
WHEN x50 THEN ceiling(x+x*0.25)
when x=50 AND x100 then ceiling(x+x*0.20)
when x=100 AND x150 then ceiling(x+x*0.15)
when (x=150 AND x200) then (ceiling(x+x*0.10))
when (x=200) then (ceiling(x+x*0.09))
You've declared a return value for
Hi Paul,
I've spent the past two days trying to reproduce my problem and I think
I may have brought this on myself. I've had been trying to create a
procedure with the Query Browser GUI and was unable to do so. So I tried
to create them with MySQL-Front and MySQL Control Center and somehow I
At 11:34 AM -0800 12/1/06, Chris White wrote:
On Friday 01 December 2006 11:22, Ed Reed wrote:
I have a problem/question I'd like to find someone else to verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one parameter,
Create
I have a problem/question I'd like to find someone else to verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one parameter,
Create Procedure MyTest(strVal VarChar)
Begin
Select Field1, Field2, Field3 From MyTable
Where Field3=strVal
On Friday 01 December 2006 11:22, Ed Reed wrote:
I have a problem/question I'd like to find someone else to verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one parameter,
Create Procedure MyTest(strVal VarChar)
Begin
Select Field1
Got it.
Thanks
Chris White [EMAIL PROTECTED] 12/1/06 11:34 AM
On Friday 01 December 2006 11:22, Ed Reed wrote:
I have a problem/question I'd like to find someone else to
verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one
I wanted to confirm something as I am having a problem logging into mysql
from the network.
I have a server configured with a user showing host as % and the user with
it's appropriate privalages. It allows me to login from phpmyadmin as well
as via port 3306 to connect to the DB with MySQL gui
Joey wrote:
I wanted to confirm something as I am having a problem logging into mysql
from the network.
I have a server configured with a user showing host as % and the user with
it's appropriate privalages. It allows me to login from phpmyadmin as well
as via port 3306 to connect to the DB
: Friday, November 24, 2006 9:42 PM
Subject: Having Problem With Load Files and AutoNumber id fields
Argh... I am autogenerating a load file after parsing and massaging a
text file I get from an AS/400 system. My first field is an id that
is on auto_number so I put a tab at the begging of the line
sequence numbers when it encounters the 0 values,
resulting in a table with contents different from the one that was
dumped. Enabling NO_AUTO_VALUE_ON_ZERO before reloading the dump file
solves this problem. mysqldump now automatically includes in its output
a statement that enables
, 2006 11:13 AM
To: mysql@lists.mysql.com
Subject: Having Problem With Load Files and AutoNumber id fields
Argh... I am autogenerating a load file after parsing and massaging a
text file I get from an AS/400 system. My first field is an id that
is on auto_number so I put a tab at the begging
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: John Kopanas [mailto:[EMAIL PROTECTED]
Sent: Friday, November 24, 2006 11:13 AM
To: mysql@lists.mysql.com
Subject: Having Problem With Load Files and AutoNumber id fields
Argh... I am autogenerating a load file after parsing
Hello all! Im am programming on С++ for mysql. I've got a problem with
mysql_fetch_row() function. When I want to make a query foe MySQL
server I do this:
mysql_real_query()
then
mysql_store_result()
and then
mysql_fetch_row()
All was well, but today my program has fallen
Argh... I am autogenerating a load file after parsing and massaging a
text file I get from an AS/400 system. My first field is an id that
is on auto_number so I put a tab at the begging of the line for each
one of my records... it throws a warning for each line... if instead
of putting an
I have the following query:
UPDATE companies c
SET
total_annual_service_charge =
(
SELECT SUM(annual_service_charge)
FROM purchased_services ps WHERE ps.company_id = c.id
);
It takes 1s to run when I have two tables of 500 rows, 4s with
At 05:50 PM 11/23/2006, you wrote:
I have the following query:
UPDATE companies c
SET
total_annual_service_charge =
(
SELECT SUM(annual_service_charge)
FROM purchased_services ps WHERE ps.company_id = c.id
);
It takes 1s to run when I
In the last episode (Nov 23), John Kopanas said:
I have the following query:
UPDATE companies c
SET
total_annual_service_charge =
(
SELECT SUM(annual_service_charge)
FROM purchased_services ps WHERE ps.company_id = c.id
);
It
That is awesome... thanks. I still am not sure exactly though why
this take 2 seconds while my methond took over a minute for the same
amount of rows. In essence don't the two methods do the same things?
On 11/23/06, mos [EMAIL PROTECTED] wrote:
At 05:50 PM 11/23/2006, you wrote:
I have the
At 09:47 PM 11/23/2006, John Kopanas wrote:
That is awesome... thanks. I still am not sure exactly though why
this take 2 seconds while my methond took over a minute for the same
amount of rows. In essence don't the two methods do the same things?
The Group By executes in one operation. I
At 10:47 PM 11/23/2006, John Kopanas wrote:
That is awesome... thanks. I still am not sure exactly though why
this take 2 seconds while my methond took over a minute for the same
amount of rows. In essence don't the two methods do the same things?
No. Your approach was executing the
I upgraded a server from 4.0 to 4.1 and then to 5.0 but I've been
running into a problem. When I was running 4.0 the passwords with the
password('password') command where being created like this:
2a287c002f9773dc now after I upgraded to 4.1 when I add a new user the
passwords end up being like
On 11/22/06, Tom Ray [Lists] [EMAIL PROTECTED] wrote:
I upgraded a server from 4.0 to 4.1 and then to 5.0 but I've been
running into a problem. When I was running 4.0 the passwords with the
password('password') command where being created like this:
2a287c002f9773dc now after I upgraded to 4.1
hi all,
I have got a problem with mysql and i want to uninstall it and then
re-install it but the problem is how to recover my data.My mysqldump command
is not working.Can i have any other procedure to recover my data like
copying the folder of my database from the data folder and then making
On 2006-11-09 VenuGopal Papasani wrote:
hi all,
I have got a problem with mysql and i want to uninstall it and then
re-install it but the problem is how to recover my data.
This seldom solves problems. What problem do you have, maybe we can help
without having you uninstall your server
VenuGopal Papasani wrote:
hi all,
I have got a problem with mysql and i want to uninstall it and then
re-install it but the problem is how to recover my data.My mysqldump
command
is not working.Can i have any other procedure to recover my data like
copying the folder of my database from
Hi, I constantly keep receiving this kind of error:
mariuszlenks-ibook-g4:~ mariuszlenk$ cd /usr/local/mysql
mariuszlenks-ibook-g4:/usr/local/mysql mariuszlenk$ sudo ./bin/mysqld_safe
Password:
./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file
./bin/mysqld_safe: line
Dan,
Actually you were on the right track. I changed your suggested query
to the following and it seems to work and is a lot quicker.
SELECT id, subject, updated FROM mrldisc WHERE updated SUBDATE(NOW
(), INTERVAL 48 HOUR) AND mainthread = 'T' ORDER BY updated DESC
LIMIT 50
Thanks.
, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 28, 2006 2:22 AM
To: mysql@lists.mysql.com
Subject: utf8 importing problem
I use MySQL database with utf8 character set and utf8_czech_ci
what I originally had. I'm not sure how reliable this
technique is, but it will at least recognize files which have characters
that are not utf8-encoded. This is counting on the fact that PHP doesn't
recognize this as a null conversion.
My particular problem was that I had files that were created
I use MySQL database with utf8 character set and utf8_czech_ci
collation.
It works well on Linux server but when I try to
export the data and import into the same database but running on XP machine the
utf8 is
gone.Instead of a proper coding there are some strange characters.
I used
Why does this query return no results:
SELECT * FROM FileList WHERE MATCH Filename AGAINST (9640)
When there are entries in the Filename list that have 9640 in them?
I'm using MySQL 5.1.11.
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Don O'Neil wrote:
Why does this query return no results:
SELECT * FROM FileList WHERE MATCH Filename AGAINST (9640)
When there are entries in the Filename list that have 9640 in them?
How many rows are in the table? Full text won't work with only a couple
of rows.
And you do have a full
PROTECTED]
Sent: Friday, October 20, 2006 2:44 AM
To: mysql@lists.mysql.com
Subject: Problem with query on 5.11
Why does this query return no results:
SELECT * FROM FileList WHERE MATCH Filename AGAINST (9640)
When there are entries in the Filename list that have 9640 in them?
I'm using
Jerry,
Is 9640 a word by itself? A full-text search wouldn't find abc9640,
No a full text search would find numbers pretending to be a word, the
full text search has a fairly high level definition of a word. Try
searching for 1960 over at http://ftvdb.bfi.org.uk/search.php.
Regards,
Jerry,
Is 9640 a word by itself? A full-text search wouldn't find abc9640,
No a full text search would find numbers pretending to be a word, the
full text search has a fairly high level definition of a word. Try
searching for 1960 over at http://ftvdb.bfi.org.uk/search.php.
Regards,
Yes, there is a full text index, there are about 12,000 rows or so.
Don
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 11:47 PM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: Problem with query on 5.11
Don O'Neil wrote:
Why does
, October 19, 2006 11:47 PM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: Problem with query on 5.11
Don O'Neil wrote:
Why does this query return no results:
SELECT * FROM FileList WHERE MATCH Filename AGAINST (9640)
When there are entries in the Filename list that have 9640 in them?
How
Hello,
I am trying to install php nuke and I get this error:
File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file
I have researched it and nothing ive tried works.
Any
hi all...
i have an issue with group by and ordering. apparently group by ignores
'order by id DESC'?!
an example is a table that has an id and a category fields. there are a
few categories under which records can be filed. so what i want is the
latest record from each category by doing
kalin mintchev wrote:
hi all...
i have an issue with group by and ordering. apparently group by ignores
'order by id DESC'?!
an example is a table that has an id and a category fields. there are a
few categories under which records can be filed. so what i want is the
latest record from each
Basically you can't do what you want either without temporary tables or
using a subselect. Subselects are only available in mysql 4.1+ (I think
- check the docs) so that may or may not be an option.
thanks... pardon my ignorance - how would i do that using subselects?
--
MySQL General
kalin mintchev wrote:
Basically you can't do what you want either without temporary tables or
using a subselect. Subselects are only available in mysql 4.1+ (I think
- check the docs) so that may or may not be an option.
thanks... pardon my ignorance - how would i do that using subselects?
but that will get you all records for that category not just the most
recently updated.
that's the main problem, isn't it?
what i'm looking for is the last record for EACH of the categories in the
table. i'm aware of the aformentioned options.
my problem with group by is that ignores
On 10/16/06, kalin mintchev [EMAIL PROTECTED] wrote:
but that will get you all records for that category not just the most
recently updated.
that's the main problem, isn't it?
what i'm looking for is the last record for EACH of the categories in the
table. i'm aware of the aformentioned
A little confused as to why MySql is swapping when there is more than
enough real memory still available on the server. I'm having a
serious problem with a production server running out of swap space
and in turn causing mysql to crash with the following error message.
According to the TOP
Can someone tell me what's wrong with this test:
create table t1 ( course_id int(10) signed not null, primary key
(course_id) );
create table t2 ( course_id int(10) unsigned not null, primary key
(course_id) );
insert into t1 values
Derek, I was able to replicate all the behaviors you describe in 5.0.21.
I noticed you have a signed INT in one table and an UNsigned INT in
the other. I changed t1 to UNsigned and then the query returns the
results you would expect:
+---+
| course_id |
+---+
|-2 |
|
Hi list,
I'm trying to install MySQL 5.0.24a RHEL RPM on a Centos Linux VPS box.
uname -a output on this box:
Linux my.host.com 2.6.9-022stab078.14-enterprise #1 SMP Wed Jul 19 14:35:02
MSD 2006 i686 athlon i386 GNU/Linux
It already has MySQL 4.1 RHEL installed on it - I checked this with rpm
I have the following query that has worked fine for displaying
standings for a soccer league.
SELECT * FROM standings WHERE division = 'BU10' AND pool = '1' ORDER
BY tpts DESC, spts DESC, w DESC, ga ASC, team_number ASC
As I said, works fine. Now, however, the league wants a slightly
Albert Padley wrote:
I have the following query that has worked fine for displaying
standings for a soccer league.
SELECT * FROM standings WHERE division = 'BU10' AND pool = '1' ORDER
BY tpts DESC, spts DESC, w DESC, ga ASC, team_number ASC
As I said, works fine. Now, however, the league
On Sep 15, 2006, at 12:56 PM, Chris W wrote:
Albert Padley wrote:
I have the following query that has worked fine for displaying
standings for a soccer league.
SELECT * FROM standings WHERE division = 'BU10' AND pool = '1'
ORDER BY tpts DESC, spts DESC, w DESC, ga ASC, team_number ASC
=/seqweb/mysqldata --pid-file=/seqweb/mysqldata/mysql4.pid --port=3306
--socket=/tmp/mysql4
The problem is that I always have to give the --socket to all the clients, the
port number is not enough. Ex:
mercure{mysql}139: /seqweb/mysql4/bin/mysql --port 3306
ERROR 2002 (HY000): Can't connect
/mysql-4.1.7
--datadir=/seqweb/mysqldata --pid-file=/seqweb/mysqldata/mysql4.pid --port=3306
--socket=/tmp/mysql4
The problem is that I always have to give the --socket to all the clients, the port number is not enough. Ex:
put a .my.cnf file in the client's home directory that specifies
entries for some specific programs
# The MySQL server
[mysqld]
[mysqldump]
[mysql]
[isamchk]
[myisamchk]
[mysqlhotcopy]
I still have the problem.
DBI connect('database=mysql;host=localhost;port=3306','mysql',...) failed:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2
1001 - 1100 of 8646 matches
Mail list logo