Friends,
im having troubles with the following query:
---
INSERT drp_volumen_venta_diaria_deposito (drp_id_sku, drp_id_deposito,
drp_volumen, drp_es_cct, drp_dia, drp_mes, drp_anno, drp_fecha_dia_cargado )
SELECT DISTINCT s.drp_id_sku,
Hi Patricio,
Some options are to prevent programmers/users make a bad queries into
the database' SQL_BIG_SELECTS = 0 | 1
The documentation say :
If set to 0, MySQL will abort if a SELECT is attempted that probably will
take a very long time. This is useful when an inadvisable WHERE statement
Juan Eduardo,
Great to hear about you :)
One thing you must know is that i can run this query from a mysql client,
without the insert part.
The problem only happens when is run from the J2EE (Websphere - drp)
application.
I run the query as you asked, here are some results:
Hi Patricio,
Your explain is scary.No use of index...Please, ask to programers in
order to create some index in the schema.
Development Server has the same version of MySQL production environment?.
4.0.18?
Resume:
1) Please check the version of mysql ( prod and development)
2) Please use
: martes 22 de mayo de 2007 13H31 (GMT-0400) America/Santiago
Asunto: Re: Problem with compex query
Hi Patricio,
Your explain is scary.No use of index...Please, ask to programers in order
to create some index in the schema.
Development Server has the same version of MySQL production
for the query?
3) Im goint to try that.
4) Good Idea.
Thanks.
- Mensaje Original -
De: Juan Eduardo Moreno [EMAIL PROTECTED]
Para: Patricio A. Bruna [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Enviados: martes 22 de mayo de 2007 13H31 (GMT-0400) America/Santiago
Asunto: Re: Problem with compex
* Jack Lauman
I have a table with a column date that contains dates in SQL format,
i.e. 2003-08-10
I need to query the table and return all the rows from the current date
thru the next 6 days. (i.e. today 2003-08-10 thru Saturday 2003-08-16).
I have tried the following query which returns
I have a table with a column date that contains dates in SQL format,
i.e. 2003-08-10
I need to query the table and return all the rows from the current date
thru the next 6 days. (i.e. today 2003-08-10 thru Saturday 2003-08-16).
I have tried the following query which returns all of the desired
Subject: Problem with a query - help!!?
Hi,
I am new to this list so I apologise if this is not the place to post this
message.
I am in the final stages of completing a project and I have one query that
is causing problems.
I need the query to get a story or stories from the story table
PROTECTED]
Sent: Monday, February 03, 2003 15:46
Subject: Problem with a query - help!!?
Hi,
I am new to this list so I apologise if this is not the place to post this
message.
I am in the final stages of completing a project and I have one query that
is causing problems.
I need the query
= ''
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: David Phipps [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, February 03, 2003 15:46
Subject: Problem with a query - help!!?
Hi,
I am new to this list so I apologise
Hi,
I think the problem is that your assuming that journoNatOpt.journoid is
'' (empty) when journoDetails.journoid has no entry in journoNatOpt.
But that's not true, the value is NULL.
So, try replacing
AND journoNatOpt.journoid = ''
with
AND journoNatOpt.journoid IS NULL
On Mon,
Hi,
I am new to this list so I apologise if this is not the place to post this
message.
I am in the final stages of completing a project and I have one query that
is causing problems.
I need the query to get a story or stories from the story table and
journalists from the journalist table
We have the following problem: on the server (quite fast) we have the
Mysqld-nt daemon running ; and the data resides in it. When a user
access the server with a very long query and another try to do the
same , but with a very simple query ; the last one has to wait a very
long time because of the
Andis,
Friday, September 06, 2002, 12:08:58 PM, you wrote:
AG Is it's possible to execute such query in MySQL?
AG update table_name set table1.field1=table2.field2 where
AG table1.key=table2.key
If you use 4.0.2 or higher yes, otherwise nope.
Pre-version of multi-table updates came only in
Hi!
Is it's possible to execute such query in MySQL?
update table_name set table1.field1=table2.field2 where
table1.key=table2.key
Thanx
Andis
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Ramanathan,
Saturday, August 31, 2002, 3:54:27 PM, you wrote:
RPS I have two connections open to a mysql-nt server. I am using one
RPS connection to add a field field to a table using the command
RPS ALTER TABLE testtable ADD testfield int;
RPS Now if I issue any query from the second
I have just installed redhat linux 7.1 and now need to install Mysql. with
innodb support.
I downloaded the rpm (3.23.51) from the mysql site and tried to install it.
The process appeared to stop mysql and then complained it could not find a
file:
/etc/rc.d/mysql
A query on rpm -qa | grep mysql
Hi,
I have two connections open to a mysql-nt server. I am using one
connection to add a field field to a table using the command
ALTER TABLE testtable ADD testfield int;
Now if I issue any query from the second connection, the mysql-nt daemon
crashes with a Dr.Watson error. The but if
, 2002 07:32
Subject: Re: Problem with a query
Hi Mikhail
What i meant to say is that My First Query returns 3 rows satisfying two
conditions Like CI.IndustryID IN (2,3) and Count(C.CompanyID) = 2
So when i add another OR say (CI.IndustryID IN (2,3) OR C.b2b = 'N') and
Count(C.CompanyID
Subject: Re: Problem with a query
No Mikhail
I dont think i can agree with you .
If you could see my first query which returned 3 rows also had a Having
Clause.
I just added an OR condition inside the query which should always increase
the Number of Rows Returned..Am i correct..Check the Query
Dear Sinisa,
I have this error compiling code that uses the mysql++-1.7.9
I am using
gcc-3.0
mysql-3.23.48
mysql++-1.7.9 with patch for compiling with gcc-3.0
under Tru64 Unix v.4.0f
thanks in advance payment for the aid.
Erminio Riezzo.
Erminio Efisio Riezzo writes:
Dear Sinisa,
I have this error compiling code that uses the mysql++-1.7.9
I am using
gcc-3.0
mysql-3.23.48
mysql++-1.7.9 with patch for compiling with gcc-3.0
under Tru64 Unix v.4.0f
thanks in advance payment for the aid.
Erminio Riezzo.
Hi!
If
procedure in case of non existance of a
personid, personid has a value of null on mssql.
so it is better to cheque on mssql personid IS NULL.
- Original Message -
From: Pure Krome [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, November 17, 2001 9:02 AM
Subject: [QUERY] Problem
G'Day All.
I'm trying to do the following in a query, in mySQL.
All my previous years of SQL has been on MS-SQL, and i'm having some little
problems with tricky sql statements.
*
i'm trying to insert a new record if the name doesn't exist in the table. If
i insert, return ID, else return 0
Hi, i'm trying to make a simple message board and I need a bit of help to
finish up. Here's my database structure first with some example data:
TABLE: mboard
mid | topic | name| date
1 New site John Doe
2 Re: New site
Barry,
I suspect you might have more luck sending your question to a
PowerBuilder list (what is it anyway ? A Borland product ?), althought
you might have some luck here...
regards,
P
On Tue, 24 Apr 2001, Barry Reynolds wrote:
I am having a problem with setting up a query in using MySql.
I am having a problem with setting up a query in using MySql. The query uses a
user-defined parameter and searches the table against it. e.g.
int search//user peramater
select * from table
where member_id = :search;
When trying to run this query (using powerbuilder) it doesnt return the
28 matches
Mail list logo