SQL Aggregator

I'm having trouble with the following query, if only one result is returned it executes in a second or two, however if there are multiple reuslts it errors out. I also tried to us = ANY and = ALL and the query runs endlessly. Any suggestions? SELECT t1.DATE, t1.REASON, t1.TITLE, Left( t1.REASON, 8 ) AS CLAIM_NO, Right( t1.REASON, 2 ) AS STAGE, t1.ID AS transatn_ID, t1.CLAIM, o1.ID AS ORDER_ID, o1.SUBREF, t1.SPOOL_ORD FROM order_ln o1 INNER JOIN transatn t1 ON o1.ID = t1.TRANS_REF WHERE t1.ID =

When running the following stored procedure mutliple times, I see memory growth on the mysqld daemon: DELIMITER // DROP PROCEDURE IF EXISTS test_information_schema_select; CREATE PROCEDURE test_information_schema_select () BEGIN SELECT * from information_schema.tables; END// DELIMITER ;

This is possibly a very newbie question, but what is the default action for MySQL with regards to storing query data? I have a situation where a developer created a php application that seems to have a recursion problem. The odd thing is that his search interface will return a result, but at the same time a temporary table is created in the MySQL data directory that begins to fill up with data until the disk is full. I've observed this happening on a few separate occasions. I've reviewed the code and no where does he specifically create a temporary table.

We have just installed MySQL on a local server. I downloaded and installed ODBC version 5.1.4 and installed both on the Server (WinXP Pro box) and my workstation (WinXP Pro)--so we could connect MS Access. I can install the ODBC on the server using "localHost" as the Server Name--no other name will work. On my workstation I cannot make an ODBC connection. It will not accept the servername "BR123XL". I receive an error message that looks like this:

I searched for this topic but the closest thing I found was a listing for Multiple Foreign Keys to Multiple Tables. I could also have not been searching for the right thing. I have a table that contains a list of people. And I have another table that has two foreign key columns, each setup as a foreign key to the people table. I am trying to do a join on the tables so that I can retrieve the names of both people from the people table in one record.

how to combined the below 2 statement into 1 ? SELECT CONCAT_WS(' ',su.firstName,NULL,su.lastName) as fullName , CONCAT_WS(',',fnet.userId,NULL,fnet.friendId) as id , fnet.status as status from friends_network fnet join security_user su on fnet.userId = su.id and fnet.friendId like 'userABC' SELECT CONCAT_WS(' ',su.firstName,NULL,su.lastName) as fullName , CONCAT_WS(',',fnet.userId,NULL,fnet.friendId) as id , fnet.status as status from friends_network fnet join security_user su

Hi i'm begening with my sql! I follow a tutorial using XAMPP and all my pages works. Now i have an account on 11vm-serv.net but i can't use my first page with the code to connect the database. Here is the code i use : "" is it something wrong?

I have a table with 40 milions rows and the fulltext index for the column 'name' takes longer than 2 minutes for any search. An example of the select is "select nome, nascimento from table clientes where match(nome) against('ricardo')>0.01 and match(nome) against('medeiros')>0.01 limit 100" Details: the min_word_len is 2 and I has repaired the table after restart de server. How can I get better results? thanks

We have been in the process of trying to profile a couple of SQL queries that were taking 6-7 sec. The result from the MySQL profiler looks like this: +--------------------+-----------+----------+------------+ | Status | Duration | CPU_user | CPU_system | +--------------------+-----------+----------+------------+ | (initialization) | 0.0000012 | NULL | NULL | | Opening tables | 0.0000277 | NULL | NULL | | System lock | 0.000004 | NULL | NULL |

Hi, Installed MySQL a lot of times. The previous installs were successful until now: [root@call mysql-community]# rpm -Uvh MySQL* --nodeps warning: MySQL-bench-5.0.67-0.glibc23.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 Preparing... ########################################### [100%] 1:MySQL-shared-compat ########################################### [ 17%] 2:MySQL-bench ########################################### [ 33%]