On 07.02.2008 03:52 CE(S)T, Chris wrote:
If you don't mind a mysql-specific fix, and can get the data you want
from a select query you could:
insert into table (select goes here) on duplicate key update;
or maybe a replace into ?
INSERT/REPLACE ... SELECT will always overwrite the entire
Hi,
On Feb 6, 2008 4:47 PM, Olaf Stein [EMAIL PROTECTED] wrote:
Hi All
I am trying to run this query:
update minpheno set TMP_ados_version='0' where ident=898;
On below table:
And get error 1136
ERROR 1136 (21S01): Column count doesn't match value count at row 1
How can that be
Dear List,
I want to create a stored procedure that runs a query using the IN
operator (or is IN a function???) on values sent as argument. That is,
my procedure should be called with something like:
CALL get_users((1,2));
and I was hoping to implement something like this:
CREATE PROCEDURE
Hi,
Thanks a lot Peter, that was useful and it worked fine. The only problem
is that the query I actually want to use this in, is a 100 line query
with lots of arguments. I don't feel to good about creating it into a
bunch of strings (16) that I have to concatenate with the variables
Magne,
I want to create a stored procedure that runs a query using the IN
operator ...
See 'Variable-length argument for query IN() clause' at
http://www.artfulsoftware.com/queries.php
PB
-
Magne Westlie wrote:
Dear List,
I want to create a stored procedure that runs a query using
Hi Magne
...the query I actually want to use this in, is a 100 line query with
lots of arguments.
I don't feel to good about creating it into a bunch of strings (16)
that I have to
concatenate with the variables inbetween.
The only alternative I know for current versions of MySQL is to
Hello:
I just stumbled on this hard to explain problem. Below
select * from BigTable (BigTable has 5 million rows)
takes forever to even print out the first row. as you could see
from the sql, it is supposed to print out some rows right away
regardless of server config in my.cnf. What is
Hi
thank you for reading my post
Is there a development workbench or development/ administration studio
available for linux?
Whether from MySQL AB itself or other 3rd party companies?
Thanks
--
View this message in context:
In the last episode (Feb 07), [EMAIL PROTECTED] said:
I just stumbled on this hard to explain problem. Below
select * from BigTable (BigTable has 5 million rows)
takes forever to even print out the first row. as you could see from
the sql, it is supposed to print out some rows right
Hi, all,
I had a server crash a few weeks ago and had to
restore my mySQL installation from backup after
reinstalling Fedora.
After the restore operation, I was no longer able to
log into mySQL, either as root or as myself. I believe
this may be because the UID in the recovered database
is now
Magne,
Sorry, the server is down at the moment, here is the entry ...
To have an sproc accept a variable-length parameter list for an
|IN(...)| clause in a query, code the sproc to |PREPARE| the query
statement:
|
DROP PROCEDURE IF EXISTS passInParam;
DELIMITER |
CREATE PROCEDURE
http://dev.mysql.com/downloads/gui-tools/5.0.html
http://dev.mysql.com/workbench/
legolas wrote:
Hi
thank you for reading my post
Is there a development workbench or development/ administration studio
available for linux?
Whether from MySQL AB itself or other 3rd party companies?
Thanks
Thanks very much. The default mysql behavior is a little
unusual. What is the parameter in my.cnf to control the cache
size before forcing a flush. I waited for 2 mininutes second
before the output came out without the -q option. My server
is fast enough to read in more than 2 GB data during this
Is there any plan to release the second link (workbench) for linux?
thanks
John Comerford-2 wrote:
http://dev.mysql.com/downloads/gui-tools/5.0.html
http://dev.mysql.com/workbench/
legolas wrote:
Hi
thank you for reading my post
Is there a development workbench or development/
From the download page:
Please note that at this point only the Windows Beta version is
available. Linux and OS X releases will be available in 2008.
It looks nice, I was looking for a similar tool 5 -6 years ago. It looks
like what I would have wanted at the time.
legolas wrote:
Is
Hello!
I am looking for an easy solution for eliminate duplicates but on a row
level.
I am having 2 tables. 1 destination for all not duplicated info (a)
and 1 for input table (b) which might have duplicates related to table
a. Now I am using this kind of insert:
INSERT INTO a
I'm trying to write an update which generates ranking data for a table.
Table is as follows
CREATE TABLE `A` ( `id` INT NOT NULL ,
`score` DOUBLE NOT NULL ,
`projrank` INT NOT NULL ,
`other` VARCHAR( 10 ) NOT NULL
) ENGINE = MYISAM
Real table actually contains 30 or so more fields but it gives
At 03:49 PM 2/7/2008, [EMAIL PROTECTED] wrote:
Thanks very much. The default mysql behavior is a little
unusual. What is the parameter in my.cnf to control the cache
size before forcing a flush. I waited for 2 mininutes second
before the output came out without the -q option. My server
is fast
Phil,
What happens if you drop the index when you do the update? Does it
run faster? If so then the index is slowing you down. Try increasing the
key_buffer_size to 756M. If there isn't much difference, try the update
without the Order By clause. If it runs considerably faster, then you
19 matches
Mail list logo