>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 n
- 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
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 safe_mysq
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:
>
> MySq
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 g
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
test1.
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 PROTE
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 di
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 id
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 up
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
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
>
-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
> 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
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 di
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 maste
-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
% > ) ;
-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 ru
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 runnin
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 lett
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 permitt
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 clien
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 with
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 I
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 an
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, mostl
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 the
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 => /usr/lib/libmysqlcl
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 retur
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 questio
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 questio
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" u
-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:
# l
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
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 PROTEC
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'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 questio
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:
[hlut
-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 spa
-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
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 op
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 pe
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
-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?
>>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 t
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 reaso
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 no
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 retrieve
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
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 Message
-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
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mys
53 matches
Mail list logo
