Something like this should work if you want to do it in SQL:
SELECT a, b, c, a+b+c
FROM table
UNION ALL
SELECT SUM(a), SUM(b), SUM(c), SUM(a+b+c)
Dan
On 10/20/06, Brian E Boothe <[EMAIL PROTECTED]> wrote:
How can I keep a running sum of the values in rows as well as columns in a
> mysql
chris smith wrote:
> On 10/21/06, Dwight Tovey <[EMAIL PROTECTED]> wrote:
>> Hello all
>> Maybe it's been a long week, but I'm trying to do something that should
>> be
>> simple and just not getting anywhere.
>>
>> I have two tables:
>> accounts
>> acctid: int unique
>> acctowner: char
>> ..
On 10/21/06, Dwight Tovey <[EMAIL PROTECTED]> wrote:
Hello all
Maybe it's been a long week, but I'm trying to do something that should be
simple and just not getting anywhere.
I have two tables:
accounts
acctid: int unique
acctowner: char
...
docs
docid: int unique
acctid: int
docti
Hello,
I am trying to install php nuke and I get this error:
File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file
I have researched it and nothing ive tried works.
Any
Hello all
Maybe it's been a long week, but I'm trying to do something that should be
simple and just not getting anywhere.
I have two tables:
accounts
acctid: int unique
acctowner: char
...
docs
docid: int unique
acctid: int
doctitle: char
...
I want to list my accounts along with
How can I keep a running sum of the values in rows as well as columns in a
> mysql database and display them,,
> Can someone show examples of this thanks
>
>
> Value1 12 14 34 Sum > --
> Value2 14 23 45 Sum> --
>
> Sum > -- -- --
--
No virus
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 5.0.4 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
This is a bugfix release for the current production branch of Connector/J.
Version 5.0.4 is suitable for use with any MySQL version including
On Fri, 20 Oct 2006, [EMAIL PROTECTED] wrote:
Ok. Just found I gave wrong info. To make my life easier, the person who
created db named cust_id in 'orders' table as SoldTo
[EMAIL PROTECTED]
in this case,
select cust_id from customers
where cust_id not in
(select Soldto from orders);
will no
On Thu, 2006-10-19 at 18:18 -0300, JoXo CXndido de Souza Neto wrote:
> I tried to escape the pipe character but it does not work.
>
> I shall try to explain better what is happening.
>
> I have got a .sql file which create my whole database (including triggers).
>
> When i run it at phpmyadmin i
Paul Warner wrote:
Now we are in UTF-8, it is saving everything I can throw at it
without creating garbage characters. Whew.
Yep. Even though it wasn't the solution to your immediate problem,
switching to UTF-8 will prevent a whole class of future ones.
--
MySQL General Mailing List
For
Ok. Just found I gave wrong info. To make my life easier, the person who
created db named cust_id in 'orders' table as SoldTo
[EMAIL PROTECTED]
in this case,
select cust_id from customers
where cust_id not in
(select Soldto from orders);
will not work
:(
> On Fri, 20 Oct 2006, [EMAIL P
I know that MySQL does not currently support using stored procedures as
a subquery and, as far I understand, this is not planned.
I personally would like this and got used to it in ms sqlserver. For
people interested in the topic here is a thread I found on Jon Haddad's
site Rusty Razor Blade:
On Fri, 20 Oct 2006, [EMAIL PROTECTED] wrote:
hi to all,
I have table customers (PK cust_id)
I have table orders (PK order_id, FK cust_id)
I need query that will selecct all customers from 'customers' they don't
have any order, there is not their cust_id in 'orders'.
couls somebody help me?
t
hi to all,
I have table customers (PK cust_id)
I have table orders (PK order_id, FK cust_id)
I need query that will selecct all customers from 'customers' they don't
have any order, there is not their cust_id in 'orders'.
couls somebody help me?
thanks.
-afan
--
MySQL General Mailing List
For
I just deleted and re-created my indexes and the query works now... I guess
the index got corrupted somehow. Strange that I never saw any indications of
this in messages, just that 0 rows were returned.
Don
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, Octobe
Yes, there is a full text index, there are about 12,000 rows or so.
Don
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 11:47 PM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: Problem with query on 5.11
Don O'Neil wrote:
> Why does this
As its first example of creating accounts, the manual says
After connecting to the server as `root', you can add new accounts.
The following statements use `GRANT' to set up four new accounts:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.14, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.14 is a bugfix release for the "legacy" stable branch that
is suitable for use with any MySQL version including MySQL-4.1,
MySQL-
On Thu, October 19, 2006 18:24, Ow Mun Heng said:
> Just curious to know,
>
> I tried to update a table with ~1.7 million rows (~1G in size) and the
> update took close to 15-20 minutes before it says it's done.
> Is this kind of speed expected?
>
> I don't really understand how the alter table add
One further post for the archive:
the version of mysql we are running now is 5.0.22
the mysql connector is now mysql-connector-java-5.0.3-bin.jar
The old connector worked fine with mysql 3.23 (and I tested again with the old
database this morning, and all was fine, including £ signs). Then we
In my tests here i saw something strange.
I tried to run my .sql file in the mysql prompt and it works fine.
When i change my data structure and tried to run again, it gives me again
the old error in create trigger (it was not changed). Then i copy whole code
of creating triggers from my .sql f
Thanks, Warren and Phil for your responses. And Martijn.
Yesterday I went through all my code and tomcat/web application configuration
settings, and converted all to UTF-8. I converted the database to UTF-8.
According to all the books and articles I've read, I have set every setting to
use U
Jerry,
Is "9640" a word by itself? A full-text search wouldn't find "abc9640",
No a full text search would find numbers pretending to be a "word", the
full text search has a fairly high level definition of a "word". Try
searching for "1960" over at http://ftvdb.bfi.org.uk/search.php.
Regar
Jerry,
Is "9640" a word by itself? A full-text search wouldn't find "abc9640",
No a full text search would find numbers pretending to be a "word", the
full text search has a fairly high level definition of a "word". Try
searching for "1960" over at http://ftvdb.bfi.org.uk/search.php.
Regar
> -Original Message-
> From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 20, 2006 10:00 AM
> To: MySQL List
> Subject: Reports
>
> Hi everyone
>
> do you know any good (free) application that make it easy to generate
> (with charts) a very nice reports from mysql ?
Hi everyone
do you know any good (free) application that make it easy to generate
(with charts) a very nice reports from mysql ?
Thanks
---
Ahmad
http://www.v-tadawul.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
Is "9640" a word by itself? A full-text search wouldn't find "abc9640",
you'd need to use LIKE for that.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Don O'Neil [mailto:[EM
Warren Young wrote:
Paul Warner wrote:
When a user enters text with a £ sign (Great Britain Pound) in the
browser and clicks enter, any insert or update statement apparently
gets truncated in mysql.
It's possible that somewhere along the line, the character is getting
translated to a multiby
Warren Young wrote:
Paul Warner wrote:
When a user enters text with a £ sign (Great Britain Pound) in the
browser and clicks enter, any insert or update statement apparently
gets truncated in mysql.
It's possible that somewhere along the line, the character is getting
translated to a multiby
Paul Warner wrote:
When a user enters text with a £ sign (Great Britain Pound) in the
browser and clicks enter, any insert or update statement apparently
gets truncated in mysql.
It's possible that somewhere along the line, the character is getting
translated to a multibyte Unicode format. (
Sid Lane wrote:
any update on the 5.1 general release date? is it still on target for
Q4 -
Q1? any narrower window?
Last I heard, Q2 next year.
Regards
--jm
On 8/30/06, Colin Charles <[EMAIL PROTECTED]> wrote:
Logan, David (SST - Adelaide) wrote:
Hi!
> Does anybody have any idea when 5
Thanks for your input.
Currently I am managing the foreign key links in my application and not
within the database so this is a possibility to look into.
A stored procedure is also a good idea, however I must upgrade my MySQL
version to >= 5.0.
I am currently running an optimize on all tables ea
Thanks Chris for your input.
I have no redundant indexes but of course I will double check.
I will look into making smaller tables.
Marvin
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: 19 October 2006 23:52
To: Marvin Wright
Cc: mysql@lists.mysql.com
Subject: Re: Dele
Thanks dear. i thought u could be of some use in Oracle aswelll
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>;
Sent: Friday, October 20, 2006 1:59 PM
Subject: Re: Oracle query..
Renish wrote:
Hello,
Sorry. Again u r wrong..
Thers n
Paul,
> I have a Java Struts application running on Tomcat 5. I have
> mysql 5 installed on redhat EL 3. When a user enters text
> with a £ sign (Great Britain Pound) in the browser and clicks
> enter, any insert or update statement apparently gets
> truncated in mysql. The insert reliably
35 matches
Mail list logo
