synopsis of the problem (one line)

2002-12-15 Thread mern
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

sorted tables and fast selects

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I think that the answer I'll get is index, but I don't know for sure... If I have a table with fields such as a client id number and a credit card id number, where a given client might have multiple cards on file, when I select from the

RE: Group by problem

2002-12-15 Thread Dmitry Kosoy
Hi, I checked it with 3.23.54 on Windows and got the same incorrect results. Regards, Dmitry -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:30 PM To: [EMAIL PROTECTED] Subject: Re: Group by problem Dmitry, - Original

Re: MySQL crashes with foreign key restraints

2002-12-15 Thread Heikki Tuuri
Stefan, - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 15, 2002 1:39 AM Subject: Re: MySQL crashes with foreign key restraints Dear Heikki, ... Hmm ... seems like 4.0.5 is the first MySQL/InnoDB

RE: INSERT confirmation? PHP

2002-12-15 Thread Roger Davis
If you are unsure about using the mysql_insert_id, have PHP use a session variable then do the following, 1. On the insert command, use the session variable as the Name of the class. 2. Retrieve the record with the session variable as the name. 3. Update the record you just

Re: running mysql (mysql users)

2002-12-15 Thread Ryan McDougall
TR, Ok first I would like to say that I have just recently started using MySQL so I feel your pain and I hope my explination helps you out. The mysql user your referring to is probably the user that is should be used to run the mysql daemon. Which would b e a seperate *nix/Windows(?) user, I'm

OS X 10.2.2: MySQL is running but I can not acces it with the terminal

2002-12-15 Thread Helmuth Lutz
Hello together, Early this year I created some test-db's. They are still accessable via the Internet-Explorer. Today I wanted to make some changes to the structure but could not access MySQL. Please can anybody help me what is possibly wrong? Can it be that the SQL4X MySQL Manager is the

RE: running mysql (mysql users)

2002-12-15 Thread Roger Davis
Most things I've read say to establish a mysql user -I take it this is to run the daemon(mysqld?) under? Correct Is the above user one that will be created in the users table of the mysql db? What mysql privileges does such a user need? No, this is a unix/linux user that is used to run the daemon

Re: running mysql (mysql users)

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 TR -- ...and then [EMAIL PROTECTED] said... % % I wish to attempt to clarify one of my earlier questions: That's always helpful :-) % % Most things I've read say to establish a mysql user -I take it this % is to run the daemon(mysqld?) under?

Re: MySQL crashes with foreign key restraints

2002-12-15 Thread Heikki Tuuri
Stefan, - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 15, 2002 1:39 AM Subject: Re: MySQL crashes with foreign key restraints Dear Heikki, ... Hmm ... seems like 4.0.5 is the first MySQL/InnoDB

Re: sorted tables and fast selects

2002-12-15 Thread Peter Brawley
David, Your reference to having the table sorted suggests physical table sorting, but a basic characteristic of a relational DBMS is that data retrieval does not depend on physical row order. The actual order of rows in a MySql table is entirely arbitrary, and shouldn't be your concern except

Re: Group by problem

2002-12-15 Thread Heikki Tuuri
Dmitry, - Original Message - From: Dmitry Kosoy [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, December 15, 2002 7:11 PM Subject: RE: Group by problem Hi, I checked it with 3.23.54 on Windows and got the same incorrect results. ... The following sql operators

Re: sorted tables and fast selects

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter, et al -- ...and then Peter Brawley said... % % Your reference to having the table sorted suggests physical table sorting, Right... % but a basic characteristic of a relational DBMS is that data retrieval does % not depend on physical row

to var or not to var (char, that is)

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- How does one decide whether to define a table with varchar() or char() field definitions? I'm going to be storing things like first and last names and mailing addresses, and I originally started planning for varchar() so that the extra

OS X 10.2.2 Can not access mysql with the terminal

2002-12-15 Thread Helmuth Lutz
Does anybody have an idea: - WHY does my currently installed MySQL 3.23.46 start at System-Start? - WHY do the currently installed db's work within Internet-Explorer? - WHY does the terminal not know the commands: mysql or mysqladmin? Not as user neither as root The terminal response:

InnoDB table lock status

2002-12-15 Thread Patricio Díaz G .
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My

Re: OS X 10.2.2: MySQL is running but I can not acces it with theterminal

2002-12-15 Thread Paul DuBois
At 18:54 +0100 12/15/02, Helmuth Lutz wrote: Hello together, Early this year I created some test-db's. They are still accessable via the Internet-Explorer. Today I wanted to make some changes to the structure but could not access MySQL. Please can anybody help me what is possibly wrong? Can it

Fwd: Re: Bug in auto_increment

2002-12-15 Thread Dennis Schwerdel
I think you did not properly process this request. Dennis Schwerdel Date: Sun, 15 Dec 2002 20:51:14 +0100 From: [EMAIL PROTECTED] To: Dennis Schwerdel [EMAIL PROTECTED] Subject: Re: Bug in auto_increment X-WEBDE-TAG: S Sender: [EMAIL PROTECTED] Your message cannot be posted to [EMAIL

Recover deleted records

2002-12-15 Thread Alexis Antonakis
Hi, I've managed to delete all the records in a table, well haven't we all done it sometime!, and was wondering whether it's possible to recover them. I notice that the .MYD and .MYI files still appear to be showing the original data. Thanks Alexis SQL

Re: Segfault -- RH8

2002-12-15 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: I'm having a problem with MySQL 4.0.4-beta and 4.0.5-alpha (both -MAX) on RedHat 8.0. Here's the setup: RedHat 8.0 (glibc-2.2.93-5) Kernel: 2.4.18-14 Apache 2.0.43 w/PHP 4.2.3 Mysql compiled into PHP using Mysql Libs: #

Re: running mysql (mysql users)

2002-12-15 Thread tlr7425
On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 TR -- ...and then [EMAIL PROTECTED] said... % % I wish to attempt to clarify one of my earlier questions: That's always helpful :-) % % Most things I've read say to establish a mysql

InnoDB table lock status

2002-12-15 Thread Patricio Díaz G .
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My

Re: Segfault -- RH8

2002-12-15 Thread johnny
Both versions, 4.0.4b and 4.0.5a are from mysql.com. RPM doesn't seem to have a way to get a description of a package (that i can find) or i would paste the information (maybe author or whatever) of the packages i'm using.. to make sure they really are MySQL AB's. -johnny Quoting Mark Matthews

InnoDB table lock status

2002-12-15 Thread Patricio Díaz G.
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My

Re: to var or not to var (char, that is)

2002-12-15 Thread Stefan Hinz, iConnect \(Berlin\)
Dave, How does one decide whether to define a table with varchar() or char() field definitions? Use CHAR, if you don't have to care about disk space, and if speed is your first goal. Using CHARs with lots of spaces in the data can be counterproductive, though, because MySQL will have to return

Segfault -- RH8

2002-12-15 Thread johnny
I'm having a problem with MySQL 4.0.4-beta and 4.0.5-alpha (both -MAX) on RedHat 8.0. Here's the setup: RedHat 8.0 (glibc-2.2.93-5) Kernel: 2.4.18-14 Apache 2.0.43 w/PHP 4.2.3 Mysql compiled into PHP using Mysql Libs: # ldd /usr/lib/httpd/libphp4.so libmysqlclient.so.11 =

[OT] I apologise

2002-12-15 Thread Patricio Díaz G .
Please forgive me for sending more than a copy of my request , [MySQL] InnoDB Lock status. That's becouse every time I send it, I receive a mail that says that address to wich I am sending my message does'nt exists, and I'm not receiving messages anymore, don't know why. I realized this reading

Re: InnoDB table lock status

2002-12-15 Thread Heikki Tuuri
Patricio, - Original Message - From: Patricio Díaz G. [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, December 16, 2002 12:35 AM Subject: InnoDB table lock status I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly

Re: [OT] I apologise

2002-12-15 Thread Paul DuBois
At 20:31 -0400 12/15/02, Patricio Díaz G. wrote: Please forgive me for sending more than a copy of my request , [MySQL] InnoDB Lock status. That's becouse every time I send it, I receive a mail that says that address to wich I am sending my message does'nt exists, and I'm not receiving messages

Re: OS X 10.2.2 Can not access mysql with the terminal

2002-12-15 Thread Paul DuBois
At 21:43 +0100 12/15/02, Helmuth Lutz wrote: Does anybody have an idea: - WHY does my currently installed MySQL 3.23.46 start at System-Start? Becasue something or someone installed the proper startup stuff under System/Library/StartupItems. - WHY do the currently installed db's work within

Re: Fwd: Re: Bug in auto_increment

2002-12-15 Thread Paul DuBois
At 22:42 +0100 12/15/02, Dennis Schwerdel wrote: I think you did not properly process this request. The phenomenon you describe below is not a bug in MySQL. The problem is that you are trying to use an AUTO_INCREMENT column in an unsupported manner. AUTO_INCREMENT columns are for use only

Re: sorted tables and fast selects

2002-12-15 Thread Paul DuBois
At 8:20 -0500 12/15/02, David T-G wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I think that the answer I'll get is index, but I don't know for sure... That's right. If I have a table with fields such as a client id number and a credit card id number, where a given client

running MySQL 101

2002-12-15 Thread tlr7425
Sorry all, but I'm trying! What is the fix for the following behavior (besides shoot the user ;) --- Welcome to Darwin! [greenroom:~] ted% safe_mysqld --user=ted [1] 551 [greenroom:~] ted% touch: /var/mysql/greenroom.err: Permission denied chown: /var/mysql/greenroom.err: Operation not permitted

handling of diacritics?

2002-12-15 Thread Andy Ingham
Everyone -- We have a bibliographic database in which diacritics are impeding search results. That is to say, we would like for a search of 'zeitschrift fur%' to retrieve records that begin not only with zeitschrift fur but also zeitschrift für (notice the umlaut over the second to last

Re: running MySQL 101

2002-12-15 Thread Paul DuBois
At 20:34 -0500 12/15/02, [EMAIL PROTECTED] wrote: Sorry all, but I'm trying! What is the fix for the following behavior (besides shoot the user ;) Looks like the stuff under /var/mysql isn't owned by ted. For starters, try this as the Unix root user: chown -R ted /var/mysql Then try running

Re: running mysql (mysql users)

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ted -- ...and then [EMAIL PROTECTED] said... % % On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote: % % ...and then [EMAIL PROTECTED] said... % % ... % % Most things I've read say to establish a mysql user -I take it this % % is to run the

Re: sorted tables and fast selects

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter, et al -- ...and then Peter Brawley said... % % Assuming a table 'clients' with a client ID and a table 'cards' with a ... % type varchar(10) , # MC, Visa, AmEx, Disc, ... maybe a set()? % card int # references cards.id %) ; %

slave pukes with hostname change

2002-12-15 Thread Eric Frazier
Hi, Ok, I am begging now. Has no one ran into this problem? I can't believe it would not come up, it is the only thing that mysql does wrong with a hostname change. All of the log files for example just are rewritten with the new hostname. I know one way I could fix it, RESET MASTER on the

How to start use MySQL in Windows

2002-12-15 Thread tmb
1 - How do I start MySQL on a Windows box? I can do it from the command line in Linux. 2 - Once started can I create a db, tables, etc the same as if it were on a Linux machine? thanks for any help. tmb ps - I have phpMyAdmin running on the Windows machine, but I wanted to know how to do it

Re: i18n

2002-12-15 Thread Muruganandam
Dear all, Greetings. I am developing an application using PHP and MySQL which should support japanese, chinese and english languages.can any one give me the configuration details so that i can perform pattern matching and filtering data based on the user entry(can be in japanese, chinese

Re: to var or not to var (char, that is)

2002-12-15 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % Dave, % % How does one decide whether to define a table with varchar() or char() % field definitions? % % Use CHAR, if you don't have to care about disk space, and if speed

Re: slave pukes with hostname change

2002-12-15 Thread Jeremy Zawodny
On Sun, Dec 15, 2002 at 07:34:49PM -0500, Eric Frazier wrote: Hi, Ok, I am begging now. Has no one ran into this problem? I can't believe it would not come up, it is the only thing that mysql does wrong with a hostname change. All of the log files for example just are rewritten with the

Re: slave pukes with hostname change

2002-12-15 Thread Eric Frazier
Hi, sorry, I didn't realize that. The slave's hostname. Thanks, Eric At 08:01 PM 12/15/02 -0800, Jeremy Zawodny wrote: On Sun, Dec 15, 2002 at 07:34:49PM -0500, Eric Frazier wrote: Hi, Ok, I am begging now. Has no one ran into this problem? I can't believe it would not come up, it is

MySQL on Mac OS XS 10.2

2002-12-15 Thread tlr7425
Ok, got the Apple OX XS 10.2 MySQL install happening. The ENTIRE reason I have had s many problems getting going with the Apple installed MySQL (Mac OS XS 10.2) is because: The MySQL Manager (/Applications/Utilities) will run the initial 'mysql_install_db' script, it may not start mysqld

Re: running mysql (mysql users)

2002-12-15 Thread tlr7425
On Sunday, December 15, 2002, at 10:03 PM, David T-G wrote: % --- % Does anyone know what NetInfo Manager means when it shows a username % (mysql) whose passwd is * (an asterisk)? And how I might incorporate % that user into... whatever I need it for? :) No idea here; sorry. Well, some

How to start use MySQL in Windows

2002-12-15 Thread tmb
1 - How do I start MySQL on a Windows box? I can do it from the command line in Linux. 2 - Once started can I create a db, tables, etc the same as if it were on a Linux machine? thanks for any help. tmb ps - I have phpMyAdmin running on the Windows machine, but I wanted to know how to do it

RE: How to start use MySQL in Windows

2002-12-15 Thread Haksun Li
Run \mysql\bin\mysql It is the client program. After connecting, you can start using mysql, e.g. use dbname; show tables; etc. etc. Haksun -Original Message- From: tmb [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 15, 2002 11:26 PM To: [EMAIL PROTECTED] Cc: [EMAIL

replication between two databases with different names.

2002-12-15 Thread sinu
Hi Group, I have two mysql server ver 3.23.49 running in RedHat7.2. In both servers I have two data bases. My requirement is I want to replicate the tableA of first database in the first server to the tableA of second data base in the second server. server A server B

mysql getting stuck with use of or in query

2002-12-15 Thread ashish shrivastav
There is a really strange thing happening with mysql 3.23.52. mysql is getting stuck in a select query, the query is a straight join between table a,b and c The problem arises when i give condition to search c.nId for 2 values then it is taking large amount of time to excute this query and is

Re: problem with replication

2002-12-15 Thread Jeremy Zawodny
On Wed, Dec 11, 2002 at 05:03:51PM +0100, Natale Babbo wrote: Hi all, I have a problem with replication between two servers. I created user repl on the master, I restored the master's dump on the slave, I changed both my.cnf settings but I got this error from slave .err file: MySql:

mysql.host error.

2002-12-15 Thread Matthieu Lalonde
Hi, I'm trying to get mysql workin' and have had the same prob on both OS X sever and NetBSD... here is what's spit out of the .err file: 021215 22:33:00 mysqld started 021215 22:33:02 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 021215 22:33:02 mysqld ended and when i run

Re: How to start use MySQL in Windows

2002-12-15 Thread Peter Watts
- Mensage Original De: tmb [EMAIL PROTECTED] Para: [EMAIL PROTECTED] [EMAIL PROTECTED] Copia: [EMAIL PROTECTED] Asunto: How to start use MySQL in Windows Fecha: 15/12/02 21:29 1 - How do I start MySQL on a Windows box? I can do it from the command line in Linux. I think you

What is wrong with this Alter statement?

2002-12-15 Thread C. Reeve
From the MySQL Manual: ALTER TABLE tbl_name MODIFY [COLUMN] create_definition [FIRST | AFTER column_name] I have also tried CHANGE instead of MODIFY. My Statement: alter table manager change column w1 decimal(8,2) not null after moves; The problem is the AFTER statement, if I omit it I have