I am not sure I understand what you want.
If you want to search for all cds, and books, and dvds based on a certain
criteria, you can use that method I've told you about.
May you want sometimes to search only in fewer tables that you know before
making the query? If yes, then you can create m
Kevin Waterson wrote:
This one time, at band camp, Warren Young <[EMAIL PROTECTED]> wrote:
Storing arbitrary data in a BLOB column is
tantamount to trying to turn the database into a file system. If you
want a file system, use a file system.
What is a file system, if not a database?
That
I have a multi-threaded daemon process written in C/C++ for FreeBSD.
I am using libmysqlclient_r.so.15 to connect to a mysql db. Both
libmysqlclient_r and the daemon process are compiled with -lpthread.
I get the following core if I start the daemon at system boot
up(through rc.d), but can't repro
Buy the mysql 5.0 certification study guide.
It covers all aspects of mysql. For more detailed information on
functionality use the online documentation.
Olaf
On 6/26/07 4:03 PM, "Peter Teunissen" <[EMAIL PROTECTED]> wrote:
> Hi All,
>
>
> For an opensource project at work, I need to get to
I'm honestly not sure. How would that work when the first table tells you
what other tables to pull additional information from?
> -Original Message-
> What about using PREPARED STATEMENTS in a stored procedure?
>
> Something like:
>
> CREATE PROCEDURE `GetInventory`( IN strTableName
Thanks for the info Jerry. =)
> -Original Message-
> From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 26, 2007 1:59 PM
> To: 'Ed Lazor'; 'Octavian Rasnita'; mysql@lists.mysql.com
> Subject: RE: select statement with variable for table_reference?
>
> Getting back to
What about using PREPARED STATEMENTS in a stored procedure?
Something like:
CREATE PROCEDURE `GetInventory`( IN strTableName VARCHAR(50), ...)
BEGIN
SET @strSQL = CONCAT("SELECT * FROM ", strTableName);
...
...
PREPARE Statement FROM @strSQL;
EXECUTE Statem
Getting back to your original question, I don't know of any way you can use
a variable as a table name directly. You can, however, pull off something
like this:
mysql> set @table = "stage";
Query OK, 0 rows affected (0.06 sec)
mysql> set @stmt = CONCAT("SELECT * FROM ", @table); /* Arbitrarily co
The MYSQL general query log does not include timestamp of queries that
it logs because queries are logged many many seconds before they are
executed. Can someone help me associated queries found in the query log
with wall clock? I am trying to get a list of queries that were executed
within a give
Ok, I used your approach like this:
--
select i.scanned_barcode, v.title from inventory as i
left join version as v on i.record_id = v.id
where
i.database_id = '1' AND i.table_id = '1' AND
i.user_id = '33' and category_id = '766')
UNION
Hi All,
For an opensource project at work, I need to get to know mysql in a
few days. I need some advise on what to read and what tutorials to
work through.
We are going to build a data warehouse using mysql 5.0. We will try
to build the entire ETL stream using sql scripts and stored
p
I am using the following method for doing this, but I am sure it is not the
best one:
(select id, title, author, 'book' as type from books)
union
(select id, title, author, 'cd' as type from cds)
union
(select id, title, author, 'dvd' as type from dvds)
where ...
order by ...
limit ...;
Octavia
Is there a way to get something like this to work?
Set @tname="mytable";
Select * from @tname;
Here's what I'm trying to really accomplish in case there is yet another way
to approach this...
I have to work with product data from multiple databases and multiple
tables. For example, one databas
Hi Konstantin,
On Jun 26, 2007, at 1:37 PM, Konstantin Osipov wrote:
* Paul McCullagh <[EMAIL PROTECTED]> [07/06/26 15:35]:
I am about to release the first version of the BLOB Streaming engine.
We are not that far yet (obviously), but our aim is to create an open
platform which will be extenda
Hi All,
I have just released the first version of the BLOB Streaming engine
for MySQL (MyBS). You can download the source code of the engine from
http://www.blobstreaming.org/download. Pluggable binaries for MySQL
5.1.19 (32-bit Linux and Mac OS X) are also available.
To install the plug-
Ravi,
Got it, thanks!!
Ben
Ravi Prasad wrote:
Make sure each of the replication slaves uses different server_id.
--Ravi
Ben Clewett wrote:
MySql,
I am running 5.0.41 on a master and four replication slaves, all 64
bit Linux.
In the error.log on all four replication servers I keep seei
Make sure each of the replication slaves uses different server_id.
--Ravi
Ben Clewett wrote:
MySql,
I am running 5.0.41 on a master and four replication slaves, all 64
bit Linux.
In the error.log on all four replication servers I keep seeing:
070626 8:34:23 [Note] Slave: received end pac
Hi Steve,
Some very good points.
We are working on a solution for BLOBs in the a MySQL database at
www.blobstreaming.org.
Any good solution will have to take your comments into account...
On Jun 22, 2007, at 9:24 AM, Steve Edberg wrote:
At 12:11 PM +0530 6/22/07, Ratheesh K J wrote:
Hell
MySql,
I am running 5.0.41 on a master and four replication slaves, all 64 bit
Linux.
In the error.log on all four replication servers I keep seeing:
070626 8:34:23 [Note] Slave: received end packet from server, apparent
master shutdown:
070626 8:34:23 [Note] Slave I/O thread: Failed readi
19 matches
Mail list logo
