Having done my upgrade from version 3 to 5, I'm looking forward to
the benefits of language support beyond the confines of Western
Europe. However, it seems I need to convert the database I have now.
We have material in the database at the moment in English, Dutch,
Italian, Portuguese and
I've just found convert()...
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
I used to think I was indecisive, but now I'm not so sure.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Nico Rittner wrote:
hello,
does anybody now how mysqldump handles the actions
for 'on delete' and 'on update' ? In my Version 4.1.14
the action clauses are missing. When reimporting the
dump, how does mysql know about the 'action' when altering
the table with forein keys.
Thanks,
When I use coalesce function I receive this error:
FUNCTION sirius.coalesce does not exist. sirius is the name of db. Can someone
help me with this error
Thanks,
Pedro
___
O SAPO já está livre de vírus com a Panda Software, fique
When I use coalesce function I receive this error:
FUNCTION sirius.coalesce does not exist. sirius is the name of db. Can
someone
help me with this error
Sure: use functions that exist.
Now, if you want a better answer, try asking a better question.
Showing us the code, for example, would
Hi Pedro,
What version of MySQL are you running? From the manual
COALESCE(value,...)
Returns the first non-NULL value in the list, or NULL if there are no non-NULL
values.
mysql SELECT COALESCE(NULL,1);
- 1
mysql SELECT COALESCE(NULL,NULL,NULL);
- NULL
COALESCE() was added in
MySQL version is 5.0.19. Runs in Win. XP pack 2. I put sql in command line and i
try using jdbc.
The code:
SELECT mfn,COALESCE (user_id,0)
FROM hits WHERE mfn =1;
Citando Logan, David (SST - Adelaide) [EMAIL PROTECTED]:
Hi Pedro,
What version of MySQL are you running? From
Hello Pedro,
MySQL version is 5.0.19. Runs in Win. XP pack 2. I put sql in command line
and i
try using jdbc.
The code:
SELECT mfn,COALESCE (user_id,0)
FROM hits WHERE mfn =1;
Although it sounds silly, remove the space between COALESCE and the (
That should do the trick.
Martijn Tonies
I think you are using .ini files present in the source directory .
Can you copy the .ini file to your datadir ( eg : my-innodb-heavy-4G.ini conf
file for 4GB RAM ) and pt out the same at startup ?
Not sure whether iam in the right path .. Correct me if iam wrong
--Praj
On Mon, 24 Apr 2006
You can find out whether the server has picked up the changes from your
configuration file by running the following SQL:
show variables like 'ft_min_word_len';
As per the instructions in the manual
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html you must
rebuild the indexes on
I migrated to mysql 5 but the applications with Visual Basic 5 return
error in data.
We have installed ODBC 3.51
--
Saludos cordiales.
Ing. Gabriel Mahiques
Dto. Control de Gestión
ELECTROINGENIERA S.A.
Telefono: 474 1414
On 4/23/06, John Hicks [EMAIL PROTECTED] wrote:
Paul Halliday wrote:
I am doing queries that produce a table that looks something like this:
Count | IP Address| First Seen| Last Seen | Days
5000 10.0.0.1 2005-12-102006-04-15 50*
6500 10.0.0.2
I think you will need to give the list some more information!
What error message do you get? Is it an error when running SQL queries, or a
problem connecting to the database?
James Harvard
At 9:22 am -0300 24/4/06, Gabriel Mahiques wrote:
I migrated to mysql 5 but the applications with Visual
Description:
I have Problem Compiling DBD::mysql with MySQL 5.0.20a.
I get the following Message:
meyer-lx:~/.cpan/build/DBD-mysql-3.0002 # make test
PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e test_harness(0,
'blib/lib', 'blib/arch') t/*.t
--- Paul Halliday [EMAIL PROTECTED] wrote:
On 4/23/06, John Hicks [EMAIL PROTECTED] wrote:
Paul Halliday wrote:
I am doing queries that produce a table that looks something like
this:
Count | IP Address| First Seen| Last Seen | Days
5000 10.0.0.1
hi,
are you using the InnoDB storage engine for your tables?
yes, i do.
example:
$ mysqldump -d core groups :
CREATE TABLE `groups` (
`id` smallint(5) unsigned NOT NULL default '0',
`name` varchar(32) NOT NULL default '',
`parent_id` smallint(5) unsigned default NULL,
`setting_` text NOT
Hello Adam
Adam Wolff wrote:
Actually runs through the table four times instead of twice, and maybe
can't even use the index for the whole query.
Assuming my results are not typical of MySQL query times, this would
explain the sqrt() relationship of returned rows to query time.
I have
Can someone explain to me how to edit this...I click on the cells and nothing
From the manual
If the query resultset is editable, you can click the Edit button below the
resultset view. Double clicking cells in the resultset will allow you to edit
their contents. Changes are commited to the
There is an EDIT button on the bottom of the Query Browser. You have to
activate the edit feature by clicking on this. You will see that it
remains highlighted.
To edit your cells, double click on them. When finished, hit APPLY CHANGES
at the bottom. If you do not apply them, they will not
Well, I hadn't known about the spatial features of MySQL. If you're ok
using vendor extensions then that definitely looks like the way to go:
http://dev.mysql.com/doc/refman/5.0/en/gis-introduction.html
A
On Apr 24, Nick Hill wrote:
Hello Adam
Adam Wolff wrote:
Actually runs through the
The edit button is 'greyed out'
Ross
- Original Message -
From: J.R. Bullington [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, April 24, 2006 4:20 PM
Subject: RE: mysql query browser- editing resultsets
There is an EDIT button on the bottom of the Query Browser. You have
Then, as the documentation states, you cannot edit the fields in that
particular query. Either the table is read-only, you have multiple tables
(like a join) in your SQL string, or you have functions
(max(),min(),count()) in your string.
Check out those items again, and if you still can't edit
In this case, the result set is not editable. It needs to have some way to
uniquely identify the row(s) under edit so it can perform an update.
Tim
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, April 24, 2006 11:42 AM
To: J.R. Bullington;
I think the most likely case is the table is read-only. How do I change
this?
Ross
- Original Message -
From: J.R. Bullington [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, April 24, 2006 4:46 PM
Subject: RE: mysql query browser- editing resultsets
Then, as the
I am a phpmyadmin user and have never really used mysql query browser before. I
have a database sitting on my localhost and I want to export the whole thing
via mysql query browser to the host. What is the easiest way to do it?
Ross
i have three Values in each row of my MySQL database, im needing to sum
them in the table as they are displayed per Row ?? how do i do this ?
Projectname Elecremain Controlremainotherremain
?php ?
Project1 2300 1600
250
[EMAIL PROTECTED] wrote:
I am a phpmyadmin user and have never really used mysql query browser before. I
have a database sitting on my localhost and I want to export the whole thing
via mysql query browser to the host. What is the easiest way to do it?
Ross
Use the MySQL admin tool, not
Hi, Brian!
First of all I think next time you should better attach your database
structure. It'll be much easier to understand your problem if you will...
Maybe you're asking for something like this:
SELECT project_name, elecremain, controlremain, otherremain, elecremain
+ controlremain +
Hi.
A Brief description about my problem.
We have many applications development in Visual Basic 5. These
applications read data from MySQL 4.0 installed on Linux (and odbc
3.51.06). Many fields in our tables are in decimal format.
Last weekend we installed MySQL 5 on Linux
When we ran the
Hello List,
If I have a table:
CREATE TABLE t (
id int(11) NOT NULL auto_increment,
fk1 mediumint(9) NOT NULL default '0',
fk2 smallint(6) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY idxfk1 (fk1,fk2),
UNIQUE KEY idxfk2 (fk2,fk1)
) TYPE=MyISAM;
I will about half the time have
In the last episode (Apr 24), Fan, Wellington said:
If I have a table:
CREATE TABLE t (
id int(11) NOT NULL auto_increment,
fk1 mediumint(9) NOT NULL default '0',
fk2 smallint(6) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY idxfk1 (fk1,fk2),
UNIQUE KEY idxfk2 (fk2,fk1)
Hey Dan,
Thanks; I was really trying to ask about the potential performance gain,
however. I don't care so much about the UNIQUEness, but the INDEXness.
See, I am wondering if I create an 2-column index wiht fk1 as the first
component, will that index help me if I am refering fk2 in my query?
Check the way your forms deal with the data from the resultset, any
implicit conversion? Maybe a declaration of type that is casting
another type for the value returned from the resultset.
Also check this:
http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html
On 4/24/06,
Brian,
i have three Values in each row of my MySQL database, im needing to
sum them in the table as they are displayed per Row ?? how do i do
this ?
Projectname Elecremain Controlremain
otherremain ?php ?
Project1 2300 1600
In the last episode (Apr 24), Fan, Wellington said:
Thanks; I was really trying to ask about the potential performance
gain, however. I don't care so much about the UNIQUEness, but the
INDEXness.
See, I am wondering if I create an 2-column index wiht fk1 as the
first component, will that
Paul,
I am doing queries that produce a table that looks
something like this:
Count | IP Address | First Seen | Last
Seen | Days
5000 10.0.0.1 2005-12-10
2006-04-15 50*
6500 10.0.0.2 2006-04-01
2006-04-06 3**
*So of the 5000 events "count(*) between 2005-12-10
and
Mike, all,
the packages you need should exist:
Mike Blezien wrote:
Hello,
I am attempting to upgrade one of our older servers running RH 7.3
w/glibc-2.2.5-44
Ok, so you need a package for glibc 2.2.
There are two choices, both on the 4.0 download page:
1) From the section Linux (non RPM
but, when the fields are float type, this error don't happen. When the
fileds are float the result is the correct (if I have 1.2569 in the
table, in the application I see 1.2569.)
Daniel da Veiga escribió:
Check the way your forms deal with the data from the resultset, any
implicit
Hi Martin, all,
again, there is quite a delay to my reply.
Martin Olsson wrote:
This is software I use:
D:\MDmysql --version
mysql Ver 14.7 Distrib 4.1.12, for Win32 (ia32)
Until now, I lived under the impression that error 2006 would not occur
on Windows, as it happens on a Unix
Please answer to list next time.
Good. Now, what is your Elecremain, Controlremain, otherremain?
How should they be calculated...
P.S.: Why don't you give a try to some numerical data types? ;) To use
varchar everythere isn't a right way I think.
Brian E Boothe wrote:
my database
Is there any way to turn off collation in mysql 4.1? PHPadmin is showing a
new colation dropdown menu which I need to get rid of.
Thanks,
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
well i have this
$sql2=SELECT ordernumber,Elecrem, CtrlProjrem, OthrProjrem
SUM(Elecrem+CtrlProjrem+OthrProjrem) AS btstotal9 FROM orders GROUP BY
ordernumber ORDER BY ordernumber;
only add's up the first row it hits and adds it to the remaining
rows ,,
I need individual Row
Brian E Boothe wrote:
i have three Values in each row of my MySQL database, im needing to
sum them in the table as they are displayed per Row ?? how do i do
this ?
As Eugene said, VARCHAR values don't sum, since they are not numeric.
Either cast the column values you wish sums of to a
Hi James,
Yes I have verified whether the variable has changed with show variables,
and it has not changed as per my first email.
I have not gotten to rebuilding as the variable just will not change ;-)
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox
44 matches
Mail list logo
