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
Project1 2300 1600
250
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 http:/
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 numeri
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
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]
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 st
Hi Martin, all,
again, there is quite a delay to my reply.
Martin Olsson wrote:
This is software I use:
D:\MD>mysql --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 cond
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 conversi
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
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
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 th
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
Project1 2300 1600
25
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, Gabr
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?
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 (
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
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 appli
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 + ot
[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 th
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
Project1 2300 1600
250
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 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:
Sent: Monday, April 24, 2006 4:46 PM
Subject: RE: mysql query browser- editing resultsets
Then, as the documentation states, you c
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; mysql@list
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 it,
The edit button is 'greyed out'
Ross
- Original Message -
From: "J.R. Bullington" <[EMAIL PROTECTED]>
To:
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 to
"activate" the
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
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 commi
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 d
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 tried
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 NULL
--- 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
>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
t/00base..
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
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
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
Us
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 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 13
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 T
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?
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
>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, wou
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
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.
>
> Thank
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 PROTECT
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 Span
45 matches
Mail list logo
