Need Information About MySql Support for Application Blocks

2006-06-16 Thread Veerabhadra rao Narra
Hello, I am a dotnet developer and i want to use Data Access Application Blocks for dotnet, so i want to know whether MySql Supports Data Access APPlication Blocks, and if so pl provide the connector for that. -- Thanks & Regards, veerabhadra rao narra, +91-988-556-5556

Re: CRM: Labels instead of specific atributes

2006-06-16 Thread John Hicks
Bruno-- I am not an expert, but... I would think most contact systems probably have separate tables for organizations and individuals. And usually additional tables to allow multiple addresses and telephones to be linked to the organizations and individuals. Yours seems rather novel in havi

Join 2 tables using specific fields

2006-06-16 Thread Ow Mun Heng
I have 2 table. Zones(Z1..Z20) and Radius(R0..R4) where R0 is equivalent to Z1 R1 " Z5 R2 " Z9 R3 " Z13 R4 " Z17 How can I make the query to join them in such ways? eg: select A,B,C,D from Zone inner join radius on R1 = Z5 on R2 = Z9 on R3 = Z13 on R4 = Z17 or do I have to use a subquery??

Re: [mysql] Attention List

2006-06-16 Thread Daniel McQuay
i took it more as a grain of pepper and just wanted to warn y'all of the impending virus attack that may or may not be sent around. thanks for the break down though. On 6/16/06, Chris White <[EMAIL PROTECTED]> wrote: On Friday 16 June 2006 03:01 pm, Daniel McQuay wrote: > hello list, > > i hav

MySQL Performance Question

2006-06-16 Thread Robinson, Eric
Our server will be home to 50-100 separate clients. Each client will have their own set of databases that will be accessed by 10-60 users at each client's site. In terms of performance, is it better to have 1 instance of MySQL servicing multiple databases, or multiple instances of MySQL each serv

Re: [mysql] Attention List

2006-06-16 Thread Chris White
On Friday 16 June 2006 03:01 pm, Daniel McQuay wrote: > hello list, > > i have been receiving random emails infected with viruses from what appear > to be the mysql mailing list. gmail kills the virus form me but i thought i > would let y'all know about this, just to be on the safe side. here are

Re: localhost

2006-06-16 Thread Javier Carlos Viegas
--- Karl Larsen <[EMAIL PROTECTED]> escribió: > I'm trying to use mysql on Linux type Fedora > Core 4 and it works > part way but I have no guess how to fix this > problem. Here is what happens: > > [EMAIL PROTECTED] ~]$ mysql > Welcome to the MySQL monitor. Commands end with ; > or \g. >

[mysql] Attention List

2006-06-16 Thread Daniel McQuay
hello list, i have been receiving random emails infected with viruses from what appear to be the mysql mailing list. gmail kills the virus form me but i thought i would let y'all know about this, just to be on the safe side. here are the details of the email. Message de la Plate-Forme SECURITE

Re: The number of left join in one SQL statement.

2006-06-16 Thread Pooly
Hi, 2006/6/16, Takanobu Kawabe <[EMAIL PROTECTED]>: [snip] I tried this statement without error. But Ihave some questions. 1.How many left join keywords can I use in one SQL statement if there are 5000 datas in one table? as this blog point out, its 31 or 61 depending

Re: localhost

2006-06-16 Thread Jo�o C�ndido de Souza Neto
When you just call mysql, it tries to login using the current logged user in linux. Try to call "mysql -u root" may be work. "Karl Larsen" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] >I'm trying to use mysql on Linux type Fedora Core 4 and it works part > way but I have

localhost

2006-06-16 Thread Karl Larsen
I'm trying to use mysql on Linux type Fedora Core 4 and it works part way but I have no guess how to fix this problem. Here is what happens: [EMAIL PROTECTED] ~]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.1.20-log Type

Re: MyMonitor - A novel SQL monitor tool for MySQL release 1

2006-06-16 Thread Anders Karlsson
There will probably be a full-blown Windows GUI version eventually. But for now, I guess you have to compile it under cygwin, which should work but hasn't been tried so far. There is probably a demand for windows, keep me posted now and then, and I'll let you know when it's available. Or just

restrict and no action problem

2006-06-16 Thread Nenad Bosanac
Hi all I have problem in MYSQL query browser tool. I make a two tables ,one have primary key, and in second table i put reference to first table. I make all this in Query browser and set foreign key of second table to on delete no action. I apply changes but next time when i want to edit secon

Good day

2006-06-16 Thread miguel
Message de la Plate-Forme SECURITE de l'Universite Sidi Med Ben Abdallah de Fes - USMBA - ALERT!!! This e-mail contained one or more infected files. The following attachments were infected and have been repaired: No attachments are in this category. The following infected attachments were dele

Re: Error 1045 - Access denied

2006-06-16 Thread Miles Thompson
Dan, I believe Dreamhost has it MySQL locked down so that only they have primary access, and yes phpMyAdmin is installed on their system. It would be .v. difficult for them to give me rights. This is sort of off-topic, but hub.org, which operates out of Wolfville, NS, has shut down the cent

Re: MyMonitor - A novel SQL monitor tool for MySQL release 1

2006-06-16 Thread Gabriel Mahiques
Anders I want this for Windows? how do I do it? Anders Karlsson escribió: The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http://sourceforge.net/projects/mymonitor The reason for this tool is simple, and it's also a bit different from

Re: Error 1045 - Access denied

2006-06-16 Thread Dan Buettner
Miles, can you access the remote database from any other tools on your local machine? mysql command line, etc. You state you can use phpmyadmin, but is that installed at your hosting provider? It's not unusual for hosting providers to lock down their database hosts to only allow access from

Re: my.cnf / mysqld logging

2006-06-16 Thread Dan Buettner
Hi Tom - In your my.cnf file, you need to specify that the setting you put in is for mysqld, the server process. Your file should look like so: [mysqld] log = /var/log/mysqld.log MySQL generally logs high-level info to files in the data directory: look for a file called .err Question: a

Error 1045 - Access denied

2006-06-16 Thread Miles Thompson
I have searched the MySQL Administrator forum for help on this, but no joy. When I try to conect to a database on Dreamhost, using MySQL Administrator, I get this error, with a red "X" in a Windows dialog box: (The name of the database and and user are changed) -

Error while displaying Multilanguages

2006-06-16 Thread VenuGopal Papasani
Hi all, I am having a problem with JSP while trying to read the data from mysql database and displaying it on the screen.It has been diplayed as ?? rather the actual data.May i know whether the problem is with JSP or MYSQL.Where the changes to be made in order get it work correctly.I a

Re: MyMonitor - A novel SQL monitor tool for MySQL release 1

2006-06-16 Thread John May
Sounds great. Being able to track the amount of data from requests - even having something like a slow query log but a "large query log" or the likes - would make a BIG difference in tracking down performance issues. Thanks! - John At 4:02 PM +0200 6/16/06, Anders Karlsson wrote:

Re: my.cnf / mysqld logging

2006-06-16 Thread Dilipkumar
Hi, log-queries=/path/ Tom Ray [Lists] wrote: How would I do that? I'm still a novice when it comes to many aspects of mysql. [EMAIL PROTECTED] wrote: Hi, Try to enable query log. Thanks & Regards Dilipkumar [EMAIL PROTECTED]: Hey there, I inherited a couple of servers that are

Re: my.cnf / mysqld logging

2006-06-16 Thread Tom Ray [Lists]
How would I do that? I'm still a novice when it comes to many aspects of mysql. [EMAIL PROTECTED] wrote: Hi, Try to enable query log. Thanks & Regards Dilipkumar [EMAIL PROTECTED]: Hey there, I inherited a couple of servers that are in production but I noticed that there\'s not activ

Re: MyMonitor - A novel SQL monitor tool for MySQL release 1

2006-06-16 Thread Anders Karlsson
Also, I need to learn how to spell. The docs arn't as bad as the language in the reply below. /Karlssons spellchecker Anders Karlsson wrote: John! No, that is not within the scope of this tool. One could imaging that is was possible though, but without some No, that is not within the sc

Re: MyMonitor - A novel SQL monitor tool for MySQL release 1

2006-06-16 Thread Anders Karlsson
John! No, that is not within the scope of this tool. One could imaging that is was possible though, but without some effort. This information is not available in the show processlist, so some other means needs to be figured out. For a seelct one could always reissue the statement (not all

Re: my.cnf / mysqld logging

2006-06-16 Thread dilipkumar_parikh
Hi, Try to enable query log. Thanks & Regards Dilipkumar [EMAIL PROTECTED]: > Hey there, I inherited a couple of servers that are in production but I > > noticed that there\'s not active logging for mysql on any of them. I > looked and they don\'t have an active my.cnf file any where on the

my.cnf / mysqld logging

2006-06-16 Thread Tom Ray [Lists]
Hey there, I inherited a couple of servers that are in production but I noticed that there's not active logging for mysql on any of them. I looked and they don't have an active my.cnf file any where on the machines. One machine is running mysql 4.1.5 and the other is running mysql 5.0.18 When

Re: MyMonitor - A novel SQL monitor tool for MySQL release 1

2006-06-16 Thread John May
Is there any way with this tool, or some other tool, to monitor the amount of data (in KBytes or the likes) returned by a particular query? - John The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http://sourceforge.net/project

MyMonitor - A novel SQL monitor tool for MySQL release 1

2006-06-16 Thread Anders Karlsson
The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http://sourceforge.net/projects/mymonitor The reason for this tool is simple, and it's also a bit different from other similar tools (at least the ones I've looked at). The tool gets the o

Re: Strange "Illegal mix of collations" error

2006-06-16 Thread Dušan Pavlica
flyerheaven - Barry Krein napsal(a): Dušan Pavlica schrieb: Barry napsal(a): Dušan Pavlica schrieb: Hello, could someone help me to explain and resolve this error? Or maybe it is a bug. DROP TABLE IF EXISTS `test`.`karty`; CREATE TABLE `test`.`karty` ( `ICO` char(12) collate latin2_czech_

Re: Strange "Illegal mix of collations" error

2006-06-16 Thread Barry
Dušan Pavlica schrieb: Hello, could someone help me to explain and resolve this error? Or maybe it is a bug. DROP TABLE IF EXISTS `test`.`karty`; CREATE TABLE `test`.`karty` ( `ICO` char(12) collate latin2_czech_cs NOT NULL default '', `CisloProvozu` char(6) collate latin2_czech_cs NOT NULL

Strange "Illegal mix of collations" error

2006-06-16 Thread Dušan Pavlica
Hello, could someone help me to explain and resolve this error? Or maybe it is a bug. DROP TABLE IF EXISTS `test`.`karty`; CREATE TABLE `test`.`karty` ( `ICO` char(12) collate latin2_czech_cs NOT NULL default '', `CisloProvozu` char(6) collate latin2_czech_cs NOT NULL default '', `CisPrac`

Re: *****SPAM***** Re: Aborted clients status variable seems increasing -how to tune the server to reduce the same

2006-06-16 Thread Lakshmi
Thanks Brent. I increased my wait_timeout.But now also my aborted clients seems increasing than connections.As u said most of my front end code use mysql persistent connect only.Can u clarify my one more doubt that when to use persistent connect and when to use mysql_connect and their advanta

Re: The number of left join in one SQL statement.

2006-06-16 Thread Barry
Takanobu Kawabe schrieb: > Hello, my name is Takanobu Kawabe. こんいちわ孝信さん:) > I have some questions about left join SQL statement. > > I want to join some tables, and using left join statement . > > the system is the following. I use two machines. > > I created the same datab

The number of left join in one SQL statement.

2006-06-16 Thread Takanobu Kawabe
Hello, my name is Takanobu Kawabe. I have some questions about left join SQL statement. I want to join some tables, and using left join statement . the system is the following. I use two machines. I created the same databases and tables on both machines. OS : Debian L

Re: order field of a table

2006-06-16 Thread theo
> > ...just realize this might get you more confused than clearing it out > for you, but what the hey. > Thanks, your answers surely help. But I was also interested in the question how to optimize the whole process. Say: In a php script, I want to delete an employee-record passing his ID to the

Re: Mysql and Aix 5.3

2006-06-16 Thread Sébastien Lardière
Joerg Bruehe a écrit : > Hello Sébastien, all! > > Sébastien Lardière wrote: >> Hello >> >> I'm looking for mysql 4.1 for Aix 5.3. >> >> I found mysql for aix 5.2 but no where 5.3 package. Is there anyway to >> provide this version ? > > Sorry, no - the build machine used by MySQL for AIX is runn

Re: Mysql and Aix 5.3

2006-06-16 Thread Joerg Bruehe
Hello Sébastien, all! Sébastien Lardière wrote: Hello I'm looking for mysql 4.1 for Aix 5.3. I found mysql for aix 5.2 but no where 5.3 package. Is there anyway to provide this version ? Sorry, no - the build machine used by MySQL for AIX is running AIX 5.2. You can rely on IBM's upward com