| |
thread by: Mike Ruskai |
last post Jul 23 '05 by: Mike Ruskai
I've been trying to implement database axis using the C api for a
many-threaded application (several, actually), and keep running into a
problem on server disconnect. One of the main reasons is to get around the
packet size limit of ODBC (which seems to be somewhere around 10MB), which
prevents a few large BLOBs from being inserted into the...
|
thread by: - |
last post Jul 23 '05 by: -
i am using the development release of mysql and have a PROCEDURE that
executes a prepared statement. it works fine when i call the procedure
but repeating it multiple times produces an "incorrect arguments to
execute" error.
replacing the prepared statement with a normal statement eliminates the
error.
is this due to the release or is a...
|
thread by: - |
last post Jul 23 '05 by: Bill Karwin
i'm getting an errno: 150 when creating a table and this is what i read
from the mysql manual:
"Both tables must be InnoDB type. In the referencing table, there must
be an index where the foreign key columns are listed as the first
columns in the same order. In the referenced table, there must be an
index where the referenced columns are...
|
thread by: Sam |
last post Jul 23 '05 by: Bill Turczyn
Is there a way to filter 'show processlist'?
like
show processlist where Host rlike "abc"
Thanks,
Sam
|
thread by: dstewart |
last post Jul 23 '05 by: dstewart
I have 2 Suse 9.1 boxes with similar configurations. I'm in the
process of moving some PHP code from one server (192.168.0.100) to
another (192.168.0.102). MySQL is running on each server, and the same
PHP code can access its respective localhost databases and make queries
with no problem.
However, the code on the old server (.100) can...
|
thread by: Gianluca_Venezia |
last post Jul 23 '05 by: Gianluca_Venezia
I have a problem with MYSQLBINLOG.EXE: result file doesn't contain log
such as CREATE TABLE and DROP, even if bin files contains it correctly.
This is a problem because I use bin result file to manage update of my
(test) application, and when I create an Index, or modify a table,
exporting bin log files I can manage it simply.
But, and I...
|
thread by: - |
last post Jul 23 '05 by: Bill Karwin
how does one prevent someone from directly inserting into a table such
that any inserts should be passed to a stored procedure e.g
insert_data(....)
i have read the manual on revoke, grant but couldn't grasp the idea.
|
| |
thread by: - |
last post Jul 23 '05 by: -
is it possible to generate a random number within an sql script rather
than the client specifying which random row to select?
|
thread by: - |
last post Jul 23 '05 by: -
i have a stored procedure that does several things in the following order:
select record
do stuff with record
delete record
if there are multiple clients accessing the procedure, will the
resultset of 'select record' differ among the clients?
does each client execute the procedure until finish or will they take
|
thread by: - |
last post Jul 23 '05 by: -
i have a stored procedure that accepts parameters. is it possible to
'throw' a warning if the parameters are invalid?
e.g the parameter must be more than 0.
the client will then see "..... 0 rows affected, 1 warning .."
|
thread by: josys64 |
last post Jul 23 '05 by: Heikki Tuuri
i have a strange problem :
MySQL 4.0.21 innodb and php 4.3.9-1
all tables are in innodb type.
For a simple select statement sometimes i get result and sometimes
nothing (i.e mysql_num_rows()>0 or mysql_num_rows()==0). It's a random
behaviour.
If my table is MyISAM type no problem.
If someone have an idea ?
|
thread by: Gianluca_Venezia |
last post Jul 23 '05 by: Gianluca_Venezia
I have a problem with MYSQLBINLOG.EXE: result file doesn't contain log
such as CREATE TABLE and DROP, even if bin files contains it correctly.
This is a problem because I use bin result file to manage update of my
(test) application, and when I create an Index, or modify a table,
exporting bin log files I can manage it simply.
But, and I...
|
thread by: anmar |
last post Jul 23 '05 by: db_rookie
I'm trying to figure out how to select all the records in one table
which have multiple specified records in a second table.
Here's a simplified version of my problem.
I have two tables, resources and goals.
resources table:
ID TITLE
|
thread by: Marin August |
last post Jul 23 '05 by: Marin August
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>HermineLINE</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<p><span class="style11"><strong><font color="#FF0000" size="4" face="Arial, Helvetica, sans-serif">Is
your women satisfied with...
|
thread by: - |
last post Jul 23 '05 by: Bill Karwin
this is one way of creating a stored procedure in mysql:
CREATE PROCEDURE some_procedure (IN value1, OUT value2)
BEGIN
SELECT ... INTO value2 FROM ....
END//
and if called from another procedure, i can access the variable this way:
|
| |
thread by: - |
last post Jul 23 '05 by: Bill Karwin
i have a stored procedure consisting of several delete statements and i
want to be able to return the "Query OK, 0 rows affected" such that the
total number of rows deleted are summed up rather than returning the
number of affected rows of the last statement.
the number of rows deleted can be obtained through the ROW_COUNT() and i
can add...
|
thread by: CaptainMcBunnyTickle |
last post Jul 23 '05 by: CaptainMcBunnyTickle
Does anyone know how to GET (not search the filesystem yourself) the path
to any database, as in, where on the filesystem it lives? Is it a query? Is
it in a debug log?
TIA
The Bunny
|
thread by: nuked |
last post Jul 23 '05 by: Bill Karwin
I have a table that has values of variables for certain entities. The
columns of interest are targetID, variableID, and valueID. A row (1, 5,
9) means that target number 1 has a value of 9 for variable 5. Being
denormalized, target number one will have many possible rows in this
table, one for each variable for which it has a value.
My...
|
thread by: Chris |
last post Jul 23 '05 by: Bill Karwin
Has anyone ever accomplished a mass update off all databases, tables and
columns for collation?
If I try to change the collation/character set for the mysql daemon it
breaks all of our queries because they conflict with the swedish default
that they have been created with. The problem is we have about 90 databases
with hundreds of tables....
|
thread by: Mick White |
last post Jul 23 '05 by: Mick White
I inadvertantly named a field "in"
mysql> select * from guestbook;
+----+-------+-------+-----------------+----------------+
| id | fname | lname | comments | in |
+----+-------+-------+-----------------+----------------+
| 1 | Mick | White | Test 123 | 20050208000000 |
| 2 | Ann | White | Hello World |...
|
thread by: chuy |
last post Jul 23 '05 by: Bill Karwin
Is there a way to recover a lost password in Mysql 4.1. I have seen many
articles and howto's on how to kill the Mysql process and then restart using
skip grant tables option. I am not trying to reset the password but rather
recover it. Resetting the password to something else would cause a problem
some of the underlying programs that rely...
|
thread by: d |
last post Jul 23 '05 by: d
Hi,
I have setup a GigE LAN with 1 mysql server and another having the
mysql client. the OS is slackware 10.1. the mysql is compiled from
source and is ver 4.1.9.
How do I measure throughput and latency between mysqlclient and
server ?
Thanks
|
thread by: B. Verkerk |
last post Jul 23 '05 by: B. Verkerk
How can I convert a windows date stored in Mysql (ie 38397 for today) to something I can use in a where clause?
Thnaks,
Bart
|
| |
thread by: Raffi |
last post Jul 23 '05 by: Raffi
I use the --all-databases switch to backup my entire database.
Sometimes there's a need to restore individual databases or tables form
the backup file. What command should I use for this?
Thanks,
Raffi
|
thread by: James Walker |
last post Jul 23 '05 by: Thomas Bartkus
In Oracle there is a way to correct any mistakes in a query, by simply
entering the edit command. And from there, a text editor is opened, to
allow the corrections to be made to the query. This eleminates having
to retype the whole query. Is this possible in MySQL?
|