Hi all,
I'm facing a strange behaviour with an UPDATE statement.
I have a table like:
+-+--+
| item_id | rank |
+-+--+
|2812 |2 |
| 13050 |4 |
| 13051 |3 |
| 13052 |1 |
+-+--+
And I want to switch items 2812 and 13052 rank (i.e.
Thank you for your answers.
gcc (GCC) 4.1.1 20060724 (prerelease) (4.1.1-3mdk)
mysql Ver 14.12 Distrib 5.0.24a, for mandriva-linux-gnu (i586) using
readline 5.1
GNU C Library development release version 2.4,
I think MySql 5.0 requires glibc 2.3. I do not know if v2.4 is a problem.
This
For what you described... you will not get a fixed size...
If you have set file_per_table flag in my.cnf you might want to know
that the .ibd files in the database directory are by default
auto-extending... so those files WILL grow... along with your data...
The shared tablespaces that you
Linux :
$ rpm -qa |grep -i mysql
Regards,
Juan
On 2/14/07, Zsolt Csillag [EMAIL PROTECTED] wrote:
Hello,
I would like to create a setup program for my demo version that uses MySql
database.
I need to detect if the target computer has already got the MySql
installed
because I don't want to
Hi Zsolt
if there is no firewall in between, you may check to see if port 3306 is
responding.
suomi
Zsolt Csillag wrote:
Hello,
I would like to create a setup program for my demo version that uses
MySql
database.
I need to detect if the target computer has already got the MySql
On Thursday 15 February 2007 11:12:11 Juan Eduardo Moreno wrote:
Linux :
$ rpm -qa |grep -i mysql
Regards,
Juan
On 2/14/07, Zsolt Csillag [EMAIL PROTECTED] wrote:
Hello,
I would like to create a setup program for my demo version that uses
MySql database.
I need to detect if the
Hi,
Nuno Oliveira wrote:
When I set the RS.Source to the first SELECT statement and open it, it
run OK but I need to close the RS and open it again using the second
SELECT statement.
After any of this operations I get a Recordset-RecordsCount = 1
That is actually a correct figure, SELECT
For what you described... you will not get a fixed size...
If you have set file_per_table flag in my.cnf you might want to know
that the .ibd files in the database directory are by default
auto-extending... so those files WILL grow... along with your data...
The shared tablespaces that
Nils Meyer wrote:
SELECT
SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by
the way.
LIMIT, not where.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, Feb 15, 2007 at 01:04:26AM +, Nuno Oliveira wrote:
Hi,
I've used PHP with MySQL and I was able to count the rows of a table by
using the following code:
SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName;
SELECT FOUND_ROWS();
However, I would like to do the same thing using
On 2/15/07, Duncan Hill [EMAIL PROTECTED] wrote:
On Thursday 15 February 2007 11:12:11 Juan Eduardo Moreno wrote:
Linux :
$ rpm -qa |grep -i mysql
Regards,
Juan
On 2/14/07, Zsolt Csillag [EMAIL PROTECTED] wrote:
Hello,
I would like to create a setup program for my demo version that
If you have root access, do 'mysqladmin -u... -h... ping'
- Original Message -
From: Daniel da Veiga [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, February 15, 2007 1:08:49 PM (GMT-0500) Auto-Detected
Subject: Re: How can I detect if MySql is already installed?
On 2/15/07,
--- Rolando Edwards [EMAIL PROTECTED] wrote:
If you have root access, do 'mysqladmin -u... -h...
ping'
- Original Message -
From: Daniel da Veiga [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, February 15, 2007 1:08:49 PM
(GMT-0500) Auto-Detected
Subject: Re: How
I haven't been into phpMyAdmin for a while, but when I tried today I got
the error:
|#2002 - The server is not responding (or the local MySQL server's
socket is not correctly configured)
This error message didn't seem to tie in with anything on the MySQL
site, which gives:
|
Error: |2002|
Is there a way to export results of a query to a file? In other words, if I
do a select * from somefile, is there a phrase like send output to
somefile.txt, or something? I've searched the help file, and I guess I
don't know what I'm looking for, if it even exists. I'm using MySQL version
5
I am currently working on a project to support using a MySQL database
along with SQL Server 2000. The following query has me stumped:
Select *
from group_mstr gm,group_payers gp
where gm.practice_id = '1'
and gp.location_id = '2'
and gp.practice_id =* gm.practice_id
and
Jesse wrote:
Is there a way to export results of a query to a file? In other
words, if I do a select * from somefile, is there a phrase like
send output to somefile.txt, or something? I've searched the help
file, and I guess I don't know what I'm looking for, if it even
exists. I'm using
In the last episode (Feb 15), Trimeloni, Adam said:
I am currently working on a project to support using a MySQL database
along with SQL Server 2000. The following query has me stumped:
Select *
from group_mstr gm,group_payers gp
where gm.practice_id = '1'
and gp.location_id = '2'
and
When my server was running MySQL 4.1 I used mysqldump for backup with no
errors - Redhat Linux 9. In fact when the server crashed and I had to
restore the whole box I used the backups from mysqldump to restore all
the databases and tables including the users. However, the server is now
running
Thanks,
Exactly what I was looking for. It helps to know what you are looking for
when browsing the help file.
Jesse
- Original Message -
From: Chris White [EMAIL PROTECTED]
To: Jesse [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Thursday, February 15, 2007 4:34 PM
Subject: Re:
Select *
from group_mstr gm,group_payers gp
where gm.practice_id = '1'
and gp.location_id = '2'
and gp.practice_id =* gm.practice_id
and gp.group_id =* gm.group_id
order by gp.payer_id
I bet =* is shorthand for an outer join (not sure if it's left or
right). You should be able
I should have mentioned it is a short hand for a join.
*= is a left outer join.
=* is a right outer join.
Adam Trimeloni
Project Leader
Quality Systems
[EMAIL PROTECTED]
(949) 255-2600
-Original Message-
From: Gary W. Smith [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 15,
I haven't been into phpMyAdmin for a while, but when I tried today I got
the error:
|#2002 - The server is not responding (or the local MySQL server's
socket is not correctly configured)
This error message didn't seem to tie in with anything on the MySQL
site, which gives:
Error: |2002|
I'm writing a perl script in which I need to save some session data. My
first attempt is to use a temporary table to store some data.
However, I'm a little unclear as to the lifespan of the temporary table.
My understanding is they last until the session ends, or a DELETE TABLE
is issued. My
Amer Neely wrote:
I'm writing a perl script in which I need to save some session data.
My first attempt is to use a temporary table to store some data.
However, I'm a little unclear as to the lifespan of the temporary
table. My understanding is they last until the session ends, or a
DELETE
Amer Neely wrote:
Daniel Kasak wrote:
Amer Neely wrote:
I'm writing a perl script in which I need to save some session data.
My first attempt is to use a temporary table to store some data.
However, I'm a little unclear as to the lifespan of the temporary
table. My understanding is they
Amer Neely wrote:
OK, that makes sense. As far as I know, my connection is still live -
I don't do a disconnect anywhere. So I'm still not sure why I can't
pull the data back out. I do get an error telling me about a problem
with my statement near which is where it tries to execute the
Daniel Kasak wrote:
Amer Neely wrote:
OK, that makes sense. As far as I know, my connection is still live -
I don't do a disconnect anywhere. So I'm still not sure why I can't
pull the data back out. I do get an error telling me about a problem
with my statement near which is where it
I'm wondering if there is a way to do a numeric sort when the number
exists in a string. More clearly, take for example:
Radius 1200
Radius 1500
Radius 1800
Radius 300
Radius 600
Radius 900
Being that character wise 1 is before 3, I'm wondering if there's a way
through the database to
Hi,
Most of the documents talk about the normal replication and dual
master. None of them talk about the conflict handling. Does it mean
that we need to handle the conflict ourselves? As I know, MSSQL has a
way to implement 2 ways replication. Any drawback if using MSSQL for
this kind of
This is totally possible...
Chris say your table is test, and the column is test_col.. use the
following, and if the number is always at the end.. and always has a
space in front of it this will work:
SELECT test_col, SUBSTRING_INDEX(test_col, '', 1) as test_col_str,
SUBSTRING_INDEX(test_col, '
Amer Neely wrote:
Daniel Kasak wrote:
Amer Neely wrote:
OK, that makes sense. As far as I know, my connection is still live
- I don't do a disconnect anywhere. So I'm still not sure why I
can't pull the data back out. I do get an error telling me about a
problem with my statement near
32 matches
Mail list logo