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 w
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, '
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 rep
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 achieve
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 tr
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
F
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 las
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 T
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 q
> 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:
>
> Err
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, 2007
> > 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). Yo
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:
Sent: Thursday, February 15, 2007 4:34 PM
Subject: Re: Export Result
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 MySQ
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
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 usin
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 gp.group_id
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
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| (
--- 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
> Subj
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/0
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
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 u
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]
> 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 t
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 F
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
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
installed
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
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 talke
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 compu
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. assi
32 matches
Mail list logo
