At 11:15 PM 11/19/2005, Rhino wrote:
- Original Message - From: "mos" <[EMAIL PROTECTED]>
To:
Sent: Saturday, November 19, 2005 8:16 PM
Subject: Is Load Data Infile or Update is faster?
I am doing a balance line comparison between the rows of an existing
table and a text file that ha
Note: forwarded message attached.
Yahoo! FareChase - Search multiple travel sites in one click.
--- Begin Message ---
i have fedora core3 installed on my system. which release of Mysql is compatible with fedora core3 ?
Yahoo! FareChase - Search multiple travel sites in one click.
i have fedora core3 installed on my system.
which release of Mysql is compatible with fedora core3 ?
-
Yahoo! FareChase - Search multiple travel sites in one click.
- Original Message -
From: "mos" <[EMAIL PROTECTED]>
To:
Sent: Saturday, November 19, 2005 8:16 PM
Subject: Is Load Data Infile or Update is faster?
I am doing a balance line comparison between the rows of an existing table
and a text file that has newer data in it. So I'm comparing
Jasper Bryant-Greene wrote:
For God's sake, guys, trim your posts!
Sorry.
Michael's solution will not produce reliable results as it will return
at least two results for many different phone numbers, with no way to
tell which is the correct result.
Really? As I said, I don't claim to be a
Michael Stassen wrote:
Anyway, I just wanted to share these observations with the original
poster - and anyone else on the list who is following this issue - to
help put some perspective on the matter. Again, feel free to ignore me
if you like. :-)
All good points. As you say, if the numbers
Rhino wrote:
- Original Message - From: "Michael Stassen"
<[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 3:55 PM
Subject: Re: Mysql Finding the country name from country prefix
Rhino wrote:
- Ori
dtra-fyf wrote:
Gleb Paharenko wrote:
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
hi, thanks for your response
but my problem is not with starting mysql
it is with starting the mysql service
prolly some problem with /etc/rc.d/init.d/mysql script
d
At 07:57 PM 11/19/2005, you wrote:
Gleb Paharenko wrote:
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
hi, thanks for your response
but my problem is not with starting mysql
it is with starting the mysql service
prolly some problem with /etc/rc.d/init.d
Gleb Paharenko wrote:
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
hi, thanks for your response
but my problem is not with starting mysql
it is with starting the mysql service
prolly some problem with /etc/rc.d/init.d/mysql script
dave
dtra-fyf wr
Today I downloaded and installed MySQL 5.0 (the "Complete Package").
Everything seemed to go with the install until it got to the "Processing
configuration..." stage.
It successfully completed "Prepare configuration", and "Write configuration
file", and "Start service".
But it failed when it
I am doing a balance line comparison between the rows of an existing table
and a text file that has newer data in it. So I'm comparing the values
field by field to the existing rows in the table. If any of the field
values are different, I need to update the table with these new values. The
tab
Hi Rhino,
I believe I have seen full outer join on a 5.1 to-do list, but at the
moment I can't recall where.
PB
-
Rhino wrote:
Paul,
Do you have any idea if MySQL plans to support full outer joins at
some point in the future? I realize you can probably fake them without
having the s
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 3:55 PM
Subject: Re: Mysql Finding the country name from country prefix
Rhino wrote:
- Original Message -
Rhino wrote:
- Original Message - From: "Michael Stassen"
<[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 1:11 PM
Subject: Re: Mysql Finding the country name from country prefix
Rhino wrote:
- Ori
Hy everybody,
I think I solved the problem... Well it's working on my computer... :)
Take I look... If you have any remarks, PLEASE don't hesitate!
==
SELECT SQL_CACHE
contacts.
Another test.
I tried just to join the contacts table with the
contacts_to_addresses table, well worked just perfect. But I am not
able to figure it out how to join the addresses table on same join!
Regards,
Bruno B B Magalhaes
On Nov 19, 2005, at 5:30 PM, Rhino wrote:
Paul,
Do you have
Hello,
we are currently running std. MySQL 4.0.26 on an old production server using RH
7.3, using the std rpms downloaded from:
http://sunsite.informatik.rwth-aachen.de/mysql/Downloads/MySQL-4.0/
we would like to upgrade to 4.1.15, which I believe is the current stable
release, and was wonde
Paul,
Do you have any idea if MySQL plans to support full outer joins at some
point in the future? I realize you can probably fake them without having the
syntax available but it would be nice to be able to get them directly
Rhino
- Original Message -
From: "Paul DuBois" <[EMAIL
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "abhishek jain" <[EMAIL PROTECTED]>;
Sent: Saturday, November 19, 2005 1:11 PM
Subject: Re: Mysql Finding the country name from country prefix
Rhino wrote:
- Original Message -
Thanks everybody for the help,
Well, I think I wasn't clear as I'd expected. As Rhino said OUTER and
Peter said INNER (he he he).
As far as I can see, seams Rhino understood it better. But I read
some tutorials and tried some combinations, but none worked as I liked.
For example, I starte
Miles,
>SELECT events.name_short, events.type, events.location,
events.description, events.faculty, >concat(people2.First_Name,
people2.Last_Name) as zName, people2.roles
>FROM events INNER JOIN people2 ON events.faculty = people2.id
>WHERE people2.roles = "faculty" AND zName = "some name"
Michael,
My apologies for not formatting the request properly for readability.
I was typing fast...
THanks for the tip...I'll try it out
Most Sincerely,
M i l e s.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Rhino wrote:
> If you parsed the first example, you might assume that I am in
> Brazil, because '55' is the country code for Brazil. (Country codes '5' and
> '555' are not in use at present.)
And they never will as long as "55" is in use, because then phone numbers
would become ambiguous.
Björn
m i l e s wrote:
SELECT events.name_short, events.type, events.location,
events.description, events.faculty, concat(people2.First_Name,
people2.Last_Name) as zName, people2.roles
FROM events INNER JOIN people2 ON events.faculty = people2.id
WHERE people2.roles = "faculty" AND zName = "some na
Peter Brawley wrote:
abhishek jain,
>I need to find the country name from the country prefix so eg. i have
>a mysql table with prefix and name as the coumns and with datas like :
>1 USA
>11XYZ
>44UK
>91India
>92Pakistan
>123 ZXF
You mean 'Co
Rhino wrote:
- Original Message - From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Saturday, November 19, 2005 8:10 AM
Subject: Mysql Finding the country name from country prefix
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the country prefix so e
abhishek jain wrote:
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the country prefix so eg. i have a
mysql table with prefix and name as the coumns and with datas like :
Prefix, Name
1 USA
11XYZ
44UK
91India
92Pakistan
SELECT events.name_short, events.type, events.location,
events.description, events.faculty, concat(people2.First_Name,
people2.Last_Name) as zName, people2.roles
FROM events INNER JOIN people2 ON events.faculty = people2.id
WHERE people2.roles = "faculty" AND zName = "some name"
Is this SELEC
Exporting and then importing the table helped, now both the regexp and the
like query produce the same result. I saved the table MYI file and will
keep experimenting with it, maybe I can come up with something useful.
Thanks for the idea.
Zoltan
On Fri, 18 Nov 2005, Scott Haneda wrote:
on 1
At 12:51 -0200 11/19/05, bruno b b magalhães wrote:
Hi guys,
I need some help with an query that I know I
must use joins, but I can't figure out how to.
The problem is, when the contact has an address,
phone and email it works just fine, but I want
it to display those how doesnt also! Could
I don't have time today to answer your question in detail but the basic
technique you need to use is an _OUTER_ join. Those should be completely
compatible for version 4 and above of MySQL.
A regular join, which is usually called an "inner" or "natural" join,
combines rows of tables where the
> I have two tables with quite a few fields and I want to create a view
> into a limited join of the table. I have a query like:
>
>select * from person
> inner join student on person.id=student.id
> where person.dormant != 'Y';
>
> The select works fine but when I try to use My
Bruno,
>when the contact has an address, phone and email it works just fine, but
>I want it to display those how doesnt also! Could someone with JOINs
>experience help me?
Your FROM t1,t2,... WHERE condition1, condition2... joins are INNER, so
they exclude contacts without addresses, phone nu
I have two tables with quite a few fields and I want to create a view
into a limited join of the table. I have a query like:
select * from person
inner join student on person.id=student.id
where person.dormant != 'Y';
The select works fine but when I try to use MySQL Query Brows
abhishek jain,
>I need to find the country name from the country prefix so eg. i
have
>a mysql table with prefix and name as the coumns and with datas
like :
>1 USA
>11 XYZ
>44 UK
>91 India
>92 Pakistan
>123 ZXF
You mean 'Country Code', right?
Hi guys,
I need some help with an query that I know I must use joins, but I
can't figure out how to.
The problem is, when the contact has an address, phone and email it
works just fine, but I want it to display those how doesnt also!
Could someone with JOINs experience help me?
And one
Hello.
This is not exactly what you want, but it might be helpful:
http://dev.mysql.com/doc/refman/5.0/en/show-open-tables.html
>Hi,
>I know select .. update could lock selected rows, if the connection not
>release the lock, others always wait.
>If I use get_lock() to get a logical lo
Hello.
Usually I use mysql-server.sh which is from ports collection, however,
mysql.server script is used sometimes. See:
http://dev.mysql.com/doc/refman/5.0/en/mysql-server.html
Andrew Kuebler wrote:
> I'm running FreeBSD and MySQL version 4.1. How do I get FreeBSD to load
> MySQL on
- Original Message -
From: "abhishek jain" <[EMAIL PROTECTED]>
To:
Sent: Saturday, November 19, 2005 8:10 AM
Subject: Mysql Finding the country name from country prefix
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the country prefix so eg. i have a
It's not clear to me whether you want the search to be case sensitive or not,
but you need to make sure that the right collation is used. Case sensitive
collations end in "_cs" and case insensitive collations end in "_ci".
Read about collations in chapter 10 of the manual:
http://www.mysql.se/d
hi all
i want to install mysql5 on fc3 but i cant when i trying to implement it by
rpm.
i remove mysql3 with rpm -e directive.
who cabn help me?:(
thanks
rpm -ivh MySQL-server-5.0.15-0.i386.rpm
error: MySQL-server-5.0.15-0.i386.rpm: V3 DSA signature: BA
Hi Friends,
I have a ticky mysql problem.
I need to find the country name from the country prefix so eg. i have a
mysql table with prefix and name as the coumns and with datas like :
Prefix, Name
1 USA
11XYZ
44UK
91India
92Pakistan
123 ZXF
and i hav
Hello.
With SHOW DATABASES you see only those databases for which you have some
kind of privilege, unless you have the global SHOW DATABASES privilege.
Connect to mysql under the root user.
Rajesh Olafson <[EMAIL PROTECTED]> wrote:
>Hi,
>I'm on Solaris 9 with mysql 4.1.
>
>I've moved
Hello.
Start points for you problem:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
> socket=/home.dbdata/mysql/mysql.sock
What is your client thinks about the location of mysqld socket?
Put the same
Hello.
>an asteriks (*) is posted with the encrypted password to the password field
While solving this issue you might want to check what queries MySQL is
receiving from you PHP application. See:
http://dev.mysql.com/doc/refman/5.0/en/Query_log.html
"W Roothman" <[EMAIL PROTECTED]
Hello.
>When a binlog file be created after enable binlong?
What do you mean by 'enable binlog'? If you have changed
a configuration file, these changes won't have effect until the server is
restarted.
Binary log and index files will be created at the startup.
> Mysql increment ba
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
dtra-fyf wrote:
> hi all
>
> i just installed mysql 5 rpm onto fedora core 4 (i installed
> mysql-server, mysql-client, mysql-shared, mysql-devel, mysql-bench)
> but i'm having issues with the serv
Hello.
Have a look here:
http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html
For a pity prepared statements are disabled now in stored routines:
http://dev.mysql.com/doc/refman/5.0/en/routine-restrictions.html
AESYS S.p.A. [Enzo Arlati] wrote:
> I need to pass to
hi all
i just installed mysql 5 rpm onto fedora core 4 (i installed
mysql-server, mysql-client, mysql-shared, mysql-devel, mysql-bench)
but i'm having issues with the service starting
it never starts, when i look in the service manager, it says mysqld
dead, but subsys is locked
i also tried
50 matches
Mail list logo
