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:
-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
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
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
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
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
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
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
-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?
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
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
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
-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
-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
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:
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
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
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
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
-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:
#
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
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
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
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
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
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 =
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
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
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
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
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
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
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
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
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
-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
-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
%) ;
%
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
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
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
-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
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
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
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
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
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
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
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
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
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:
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
- 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
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
53 matches
Mail list logo