Hi!
As I wrote before this works fine and I DO get a nice result;
SELECT SUM(trans2.nettovikt) as summa FROM trans2 INNER JOIN artikel on
trans2.artikel=artikel.artikel WHERE trans2.transtid between '2007-07-01
00:00:00' and '2007-07-02 23:59:59' and artikel.reservinteger='01' group by
artikel.vol
On Dec 12, 2007, at 8:03 PM, jekillen wrote:
On Dec 12, 2007, at 6:41 PM, Ken Menzel wrote:
- Original Message - From: "Chris" <[EMAIL PROTECTED]>
To: "jekillen" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, December 11, 2007 9:12 PM
Subject: Re: mysqld startup failure
jekillen wrote:
On Dec 12, 2007, at 6:41 PM, Ken Menzel wrote:
- Original Message - From: "Chris" <[EMAIL PROTECTED]>
To: "jekillen" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, December 11, 2007 9:12 PM
Subject: Re: mysqld startup failure
jekillen wrote:
Hello:
The saga of this machine continues:
FreeB
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "jekillen" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, December 11, 2007 9:12 PM
Subject: Re: mysqld startup failure
jekillen wrote:
Hello:
The saga of this machine continues:
FreeBSD v6.2
latest mysql version installed from ports
Hi Tomas
I'll need more info so I could follow up
Do all the Tables exist in the currently selected DB?
Do all the tables have data?
Does the current user you are using to run the Procedure have the DML
permission to create/query/insert/update or execute?
M--
- Original Message -
From: "
Taking it step by step, this query will give you all the lowest ids,
for those records with duplicates.
SELECT min(id), email, count(*) AS cnt
FROM addressbook
GROUP BY email
HAVING cnt>1
Now think of that query as an already existing table, which you can
do, you just need to name the query r
Hi Brian
tough to say without looking at the script
http://www.php.net/function.mysql-connect
suggests allowing the current thread to sleep a bit to wait for the resource
to become available
M--
- Original Message -
Wrom: CLBDXRQBGJSNBOHMKHJYFMYXOEAIJJPHSCRTNHGS
To:
Sent: Wednesday, Dece
I've found a glaring problem with the latest ODBC connector. Data types have
been changed and data is no longer being read correctly.
I'm running MySQL 5.1.16 on Netware. My apps are VB6 and VBA using ADO. The
following query produces different data types depending on the version of the
ODBC d
Hi Ben,
On Dec 12, 2007 8:14 AM, Ben Clewett <[EMAIL PROTECTED]> wrote:
> Dear MySql,
>
> Using 5.0.41 I had a single innodb table which would not unlock. I
> wonder if this might be a bug, or an issue that is known to be fixed in
> later versions?
>
> Any DML like this example:
>
>UPDATE ws_
At 04:52 PM 12/12/2007, Baron Schwartz wrote:
Hi,
On Dec 12, 2007 5:39 PM, mos <[EMAIL PROTECTED]> wrote:
> I have a Char(50) column and I want to count the number of "." in the
> column using a Select statement. I don't see any MySQL function that can
> count the number of occurrences of a char
Hi,
On Dec 12, 2007 5:39 PM, mos <[EMAIL PROTECTED]> wrote:
> I have a Char(50) column and I want to count the number of "." in the
> column using a Select statement. I don't see any MySQL function that can
> count the number of occurrences of a character in a string. Is there a
> simple way to do
I have a Char(50) column and I want to count the number of "." in the
column using a Select statement. I don't see any MySQL function that can
count the number of occurrences of a character in a string. Is there a
simple way to do this?
TIA
Mike
--
MySQL General Mailing List
For list archives
OK, I have all my data on the new machine in a SQL file with 664,000
insert statements. But when I try to run it like this from the mysql
command line:
source filename.sql;
It starts to work, but after a few seconds the server freezes up with
"too many connections". How do I avoid this?
I have similar (not identical) tables in two different db's. I want to
merge all the data from one into the other, and will be dropping the
original. There will be some duplication of keys so some rows will
need to be ignored. Problem is these are on two different servers on
different machi
Hi all,
I have a query that is not quite producing what I expected:
select
n.nid,
n.title,
DATE_FORMAT(FROM_UNIXTIME(n.created), '%c/%e/%Y') as created,
c.field_product_price_value as price,
d.name,
t.tid,
v.value AS vote_average
from
node n
left join node_revi
As some of you might have noticed we've restructured the documentation
overview page quite a bit. Hopefully this will make it easier for you to
find the information you need. We've amended
http://dev.mysql.com/doc/index.html#refman with a section labeled
"Excerpts from the Reference Manual", where
Hi Yashesh, all !
Yashesh Bhatia wrote:
Hello:
I have the following table
select * from addressbook
+++
| id | email |
+++
| 1 | [EMAIL PROTECTED] |
| 2 | [EMAIL PROTECTED] |
| 3 | [EMAIL PROTECTED] |
++--
Hello:
I have the following table
select * from addressbook
+++
| id | email |
+++
| 1 | [EMAIL PROTECTED] |
| 2 | [EMAIL PROTECTED] |
| 3 | [EMAIL PROTECTED] |
+++
3 rows in set (0.00 sec)
Now i wanted t
Dear MySql,
Using 5.0.41 I had a single innodb table which would not unlock. I
wonder if this might be a bug, or an issue that is known to be fixed in
later versions?
Any DML like this example:
UPDATE ws_queue SET stage = 'committed' WHERE stage = 'running'
Would result in:
ERROR 1205 (
19 matches
Mail list logo
