RE: Help with Query

2004-01-06 Thread Jay Blanchard
[snip] $query = SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate)) as timein FROM emp2 where mo nth(hdate)=$mymonth and empnum order by timein; [/snip] Change to single quotes around data $query = SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate)) as timein FROM

Re: Help with Query

2004-01-06 Thread Michael Stassen
Jay Blanchard wrote: [snip] $query = SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate)) as timein FROM emp2 where mo nth(hdate)=$mymonth and empnum order by timein; [/snip] Change to single quotes around data $query = SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) -

Re: Help with Query

2004-01-06 Thread robert_rowe
Try single quotes around instead of double quotes. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Need help with query. Please!

2003-12-05 Thread Robert Hughes
I have the following 3 tables: table 1: companies fields 1: company_id, company name, status Sample data: 1 , company 1 , 0 2 , company 2 , 1 3 , company 3 , 1 4 , company 4 , 0 5 , company 5 , 1 table 2: groups fields 2: group_id, group_name Sample data: 1 , Group 1 2 , Group 2 3 , Group 3 4 ,

Re: Need help with query. Please!

2003-12-05 Thread Diana Soares
Try: SELECT C.company_id, C.company_name FROM companies C LEFT JOIN company_group_intersect CG ON (C.company_id=CG.company_id AND CG.group_id='1') WHERE C.status='1' AND CG.company_id IS NULL -- Diana Soares On Fri, 2003-12-05 at 15:08, Robert Hughes wrote: I have the following 3 tables:

RE: Need help with query. Please!

2003-12-05 Thread Robert Hughes
That worked perfectly!!! Thanks so much :-) -Original Message- From: Diana Soares [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 10:31 AM To: Robert Hughes Cc: [EMAIL PROTECTED] Subject: Re: Need help with query. Please! Try: SELECT C.company_id, C.company_name FROM

Help with query

2003-11-18 Thread Ed Peterson
Hello, I'm new to this list, and relatively new to SQL (well more rusty then new). Anyhow, I really need some assistance with the following query. When I made it up it worked fine, but then during my testing I deleted all of the info from the gallery_info table and that blew this query outta the

Need help constructing query ...

2003-11-09 Thread John Kelly
I have a table of full URLs and IPs and am using the following query to return distinct web requests by domain. Using SUBSTRING_INDEX it only returns the domain part of the URL: SELECT SUBSTRING_INDEX(url, '/', 3) as topsites, count(distinct ip) as count from tablename WHERE SUBSTRING_INDEX(url,

Re: Need help constructing query ...

2003-11-09 Thread Roger Baklund
* John Kelly I have a table of full URLs and IPs and am using the following query to return distinct web requests by domain. Using SUBSTRING_INDEX it only returns the domain part of the URL: SELECT SUBSTRING_INDEX(url, '/', 3) as topsites, count(distinct ip) as count from tablename WHERE

Re: Need help constructing query ...

2003-10-22 Thread Patrick Shoaf
] : Cc: [EMAIL PROTECTED] : Subject: Re: Need help constructing query ... : : : - Original Message - : From: Daniel Clark [EMAIL PROTECTED] : To: [EMAIL PROTECTED] : Cc: [EMAIL PROTECTED] : Sent: Tuesday, October 21, 2003 2:33 PM : Subject: Re: Need help constructing query

Need help constructing query ...

2003-10-21 Thread John Kelly
Hi, I have a table full of logged urls and ip addresses. The following query returns all the urls and the number of requests. How would I modify it to return unique requests based on distinct ip addresses? select url, count(*) as pageviews from table group by url order by pageviews desc --

Re: Need help constructing query ...

2003-10-21 Thread Daniel Clark
Hi, I have a table full of logged urls and ip addresses. The following query returns all the urls and the number of requests. How would I modify it to return unique requests based on distinct ip addresses? select url, count(*) as pageviews from table group by url order by pageviews desc

Re: Need help constructing query ...

2003-10-21 Thread John Kelly
- Original Message - From: Daniel Clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 2:33 PM Subject: Re: Need help constructing query ... : Hi, I have a table full of logged urls and ip addresses. The following : query returns all

RE: Need help constructing query ...

2003-10-21 Thread Kevin Fries
Then I think you want SELECT url, COUNT(DISTINCT ip_address) FROM tablename GROUP BY url; -Original Message- From: John Kelly [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 3:45 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Need help constructing query

Re: Need help constructing query ...

2003-10-21 Thread John Kelly
: -Original Message- : From: John Kelly [mailto:[EMAIL PROTECTED] : Sent: Tuesday, October 21, 2003 3:45 PM : To: [EMAIL PROTECTED] : Cc: [EMAIL PROTECTED] : Subject: Re: Need help constructing query ... : : : - Original Message - : From: Daniel Clark [EMAIL PROTECTED

Need help writing query

2003-09-18 Thread Patrick Shoaf
I have a table name product defined as follows: Item_Code Item_Size Item_Color Item_img Description Cost Retail_Price Category and other non-essential items, such as qty based on code,size,color The data is as follows: j2400 S BLK j2400blk.jpgBlack Jacket12.00 24.00 Jacket

Re: Need help writing query

2003-09-18 Thread Egor Egorov
Patrick Shoaf [EMAIL PROTECTED] wrote: I have a table name product defined as follows: Item_Code Item_Size Item_Color Item_img Description Cost Retail_Price Category and other non-essential items, such as qty based on code,size,color The data is as follows: j2400 S BLK

Re: Need help writing query

2003-09-18 Thread Patrick Shoaf
I loaded MySQL 4.1, but now the text is gibberish in the Group_Concat field SELECT Cat_Item_Img,Cat_Price,Product.Item_Code,GROUP_CONCAT(Item_Size SEPARATOR ;) as sizes,Item_Img, Description,Category,Retail_Price,Short_Desc,Product.Item_Color FROM Cat_Items,Product WHERE cat_code =BoltTech and

Re: Need help optimizing query, awfully slow on only 20000 records

2003-08-21 Thread SAQIB
Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html Saqib Ali - http://www.xml-dev.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need help optimizing query, awfully slow on only 20000 records

2003-08-21 Thread Apollo (Carmel Entertainment)
Absolutely! I have multiple indexes. I think it might be a problem with ODBC Are your tables indexed? http://www.mysql.com/doc/en/MySQL_indexes.html Saqib Ali - http://www.xml-dev.com - Visit CARMEL MUSIC ENTERTAINMENT website

Need help optimizing query, awfully slow on only 20000 records

2003-08-20 Thread Mechain Marc
Two Questions: Is the same query running directly on the linux server thru mysql is also very slow ? Have you done a explain plan on the query ? Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Need help optimizing query, awfully slow on only 20000 records

2003-08-20 Thread Apollo (Carmel Entertainment)
list? Which parts of the process are slow? How does the query perform from the mysql command line? -Original Message- From: Apollo (Carmel Entertainment) [mailto:[EMAIL PROTECTED] Sent: 19 August 2003 17:29 To: [EMAIL PROTECTED] Subject: Need help optimizing query, awfully slow

RE: Need help optimizing query, awfully slow on only 20000 records

2003-08-20 Thread Apollo (Carmel Entertainment)
: Wednesday, August 20, 2003 2:52 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Need help optimizing query, awfully slow on only 2 records When following query is pulled up, it takes about whole 1-2 minutes to come up. inquiries table has 17000 records, contacts

Re: Need help optimizing query, awfully slow on only 20000 records

2003-08-20 Thread Apollo (Carmel Entertainment)
Query takes 3.4 seconds to run on the server, but it takes 1-2minutes to run via MyODBC 3.51.06 using passthrough (Access97 is the front end, but it has query type that allows bypass of Access interpretation. Two Questions: Is the same query running directly on the linux server thru mysql is

RE: Need help optimizing query, awfully slow on only 20000 records

2003-08-20 Thread Apollo (Carmel Entertainment)
To: Michael S. Fischer Cc: [EMAIL PROTECTED] Subject: RE: Need help optimizing query, awfully slow on only 2 records Result of EXPLAIN is: table|type|possible_keys|key|key_len|ref|rows|Extra inquiries|ALL|contact_id| | | |8253|Using filesort individual_contacts|eq_ref

RE: Need help optimizing query, awfully slow on only 20000 records

2003-08-20 Thread Michael S. Fischer
] Sent: Wednesday, August 20, 2003 3:14 PM To: Michael S. Fischer Cc: [EMAIL PROTECTED] Subject: RE: Need help optimizing query, awfully slow on only 2 records Result of EXPLAIN is: table|type|possible_keys|key|key_len|ref|rows|Extra inquiries|ALL|contact_id| | | |8253

RE: Need help optimizing query, awfully slow on only 20000 records

2003-08-20 Thread Michael S. Fischer
To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Need help optimizing query, awfully slow on only 2 records When following query is pulled up, it takes about whole 1-2 minutes to come up. inquiries table has 17000 records, contacts has about 7000, individual_contacts has about

Need help optimizing query, awfully slow on only 20000 records

2003-08-19 Thread Apollo (Carmel Entertainment)
1.2Ghz Pentium, with 1/2Gig of ram, 4.0.14MySQL, RedHat9.0 I have about 20K records that result from the following query. Front end for the database is ACCESS97 and pulling up 20K records makes a huge performance hit. For the form in question I am using PASSTHROUGH type query (the one that just

Re: Help with Query

2003-03-19 Thread Daren Cotter
Thanks, this works great in the MySQL server...I guess I've never used temp tables before, but when I try to run this in a PHP script, I get table does not exist. How do I do this? --- Harald Fuchs [EMAIL PROTECTED] wrote: In article [EMAIL PROTECTED], Daren Cotter [EMAIL PROTECTED] writes:

Re: Help with Query

2003-03-18 Thread Jeff Shapiro
OK, attempt number two: Let's see what you are after is the number of emails that a member has received (say 25), and then you also want the number of members that have received x-number (say 25) emails. Is this even close to what you want? I think the only way to answer the question(s) is to

Re: Help with Query

2003-03-18 Thread Zak Greant
On Mon, Mar 17, 2003 at 10:47:09PM -0800, Daren Cotter wrote: This seems to be doing the same thing as the previously mentioned query...simply listing all mailing IDs, along with the # of members it was sent to. I've included both queries with their results below. Hi Daren, Heh. The

Help with Query

2003-03-17 Thread Daren Cotter
I have a table that keeps track of when members of my site are mailed. The important fields in the table are: member_id, mail_id I need to write a query that will return the # of members and # of mailings, like the table below: # of mailings sent # of members

Re: Help with Query

2003-03-17 Thread Jeff Shapiro
This should get you close: SELECT mail_id, count(member_id) AS `# of members` FROM yourtable GROUP BY mail_id; At 18:44 -0800 3/17/03, Daren Cotter wrote: I have a table that keeps track of when members of my site are mailed. The important fields in the table are: member_id, mail_id I need to

Re: Help with Query

2003-03-17 Thread Daren Cotter
Jeff, That query simply gives me each mailing ID, along with the # of members associated with that mailing ID. What I NEED is to return the # of mailings sent to a member, and the number of members associated with that number. I.e., if I do: SELECT count(*) FROM member_mailings WHERE member_id

Re: Help with Query

2003-03-17 Thread Zak Greant
On Mon, Mar 17, 2003 at 09:52:44PM -0800, Daren Cotter wrote: Jeff, That query simply gives me each mailing ID, along with the # of members associated with that mailing ID. What I NEED is to return the # of mailings sent to a member, and the number of members associated with that number.

Re: Help with Query

2003-03-17 Thread Daren Cotter
This seems to be doing the same thing as the previously mentioned query...simply listing all mailing IDs, along with the # of members it was sent to. I've included both queries with their results below. mysql SELECT COUNT(member_id), COUNT(mailing_id) FROM member_mailings GROUP BY mailing_id;

Re: help with query

2003-01-24 Thread Roger Baklund
* Justin French I have four (relevant) tables: category partner(pid,pname,etc) service(sid,sname,cid) sid2pid(sid,pid) This works fine, listing all services available within a category: SELECT service.sid,service.sname FROM service WHERE cid='3' ORDER BY service.sname ASC eg:

help with query

2003-01-23 Thread Justin French
sorry for the ambiguos subject, but not sure what terms to use! I have four (relevant) tables: category partner(pid,pname,etc) service(sid,sname,cid) sid2pid(sid,pid) This works fine, listing all services available within a category: SELECT service.sid,service.sname FROM service WHERE

Re: help with query

2003-01-14 Thread Leonardo Javier Belén
] Sent: Monday, January 13, 2003 9:52 PM Subject: Re: help with query Hi, I do not clearly understand your question, but if it's looking for query, please try the following: select * from planttable where substring(id, 1, 2)=01 and substring(id, 3,2)=02; Hi all! I would like to build

Re: help with query

2003-01-14 Thread CH Tsang
? Thanks in advance. Leo. - Original Message - From: Anthony Richardson To: Leonardo Javier BelÈn [EMAIL PROTECTED] Sent: Monday, January 13, 2003 9:52 PM Subject: Re: help with query Hi, I do not clearly understand your question, but if it's looking for query, please try the following

Re: help with query

2003-01-14 Thread Leonardo Javier Belén
: help with query Hi Leo, how about this: select * from planttable where id like 01% or id like %02 CH Leonardo Javier Belén wrote: Thanks but actually I'm looking for a way to return all the relations upwards and downwards of a term. no matter the position (so I need general query to do

Re: help with query

2003-01-14 Thread Roger Baklund
* Leonardo Javier Belén Thanks but actually I'm looking for a way to return all the relations upwards and downwards of a term. no matter the position (so I need general query to do that. Any ideas? 0100 - Rose tree 0101 - pink rose tree 0102 - red rose tree 0103 - rococo rose tree 0200 -

help with query

2003-01-13 Thread Leonardo Javier Belén
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is

help with query

2003-01-13 Thread Leonardo Javier Belén
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is

help with query

2003-01-13 Thread Leonardo Javier Belén
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is

help with query

2003-01-13 Thread Leonardo Javier Belén
Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is

Re: help with query

2003-01-13 Thread Gelu Gogancea
] [EMAIL PROTECTED] - Original Message - From: Leonardo Javier Beln [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:09 PM Subject: help with query Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed

RE: help with query

2003-01-13 Thread Kenneth Hylton
]] Sent: Monday, January 13, 2003 2:10 PM To: [EMAIL PROTECTED] Subject: help with query Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower

Newbie- Help with query

2002-12-11 Thread Max Clark
Help! I am a new mysql user, I understand the basic syntax of the commands for different sql queries. I am trying to write a query and I can't seem to figure it out. I would like to select all domain,transport fields from the transport table where the transport id = a query agains the acl

RE: Newbie- Help with query

2002-12-11 Thread Joe Stump
:26 AM To: [EMAIL PROTECTED] Subject: Newbie- Help with query Help! I am a new mysql user, I understand the basic syntax of the commands for different sql queries. I am trying to write a query and I can't seem to figure it out. I would like to select all domain,transport fields from

Re: syntax help , sql,query

2002-10-08 Thread Roger Baklund
* Dragos Madalin Popa I am trying to run this update statement, but I got an error syntax...near offsetCould You please point out what is wrong? Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where ABBREVIATION is null; Use the CONCAT function: URL:

re: syntax help , sql,query

2002-10-08 Thread Victoria Reznichenko
Dragos, Monday, October 07, 2002, 7:30:47 PM, you wrote: DMP I am trying to run this update statement, but I got an error syntax...near DMP offsetCould You please point out what is wrong? DMP Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where DMP ABBREVIATION is null;

syntax help , sql,query

2002-10-07 Thread Dragos Madalin Popa
sql,query Hi, I am trying to run this update statement, but I got an error syntax...near offsetCould You please point out what is wrong? Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where ABBREVIATION is null; Thank You, Best Regards, Madalin.

Need help optimizing query

2002-10-05 Thread johnt
Greetings, I am struggling trying to get good performance using indexes. I'll spare the details and narrow down the situation. I have about 100,000 rows of data with the following fields: title - vachar(64) description - text state - varchar(2) priority - int modified - date People type in

Re: help with query

2002-06-16 Thread Zak Greant
On Fri, 2002-06-14 at 18:16, Hathaway, Scott L wrote: I am trying to get something like the following: Title - topic #1 sub topic #1.1 topic #2 sub topic #2.1 sub topic #2.2 from the following table (I am using php for scripting). forum

help with query

2002-06-14 Thread Hathaway, Scott L
I am trying to get something like the following: Title - topic #1 sub topic #1.1 topic #2 sub topic #2.1 sub topic #2.2 from the following table (I am using php for scripting). forum id int parent_id

Re: help with query

2002-06-14 Thread Nick Stuart
I think the best way to do this is to set up two tables. One for the main topic list, then one for each sub topic. You may already have this but I cant see it here. Anyways to get your selection order correct you could do something like:SELECT * FROM forum ORDER BY parent_id, id Have any exampls

Help Optimizing Query...

2002-06-12 Thread Matthew Walker
I need help optimizing the query below. I've included the query, the table declerations, and the output of explain. Any help would be greatly appreciated. What I'd really like is to find out how to get it to use a key on the lineitems table. I've tried adding indexes on the OrderID

Need help with query result

2002-05-30 Thread Memon, Michele
Hello Everyone, I haven't used SQL in a long time and I am having trouble designing the query to get the result I need. I have 1 select query that looks like this: SELECT WC.FIRST_NAME ' ' WC.LAST_NAME AS NAME, C.COMM_NO AS PHONE FROM WRK_CNTRCTR AS WC, WRK_COMM_NUMBER AS C WHERE WC.PERS_ID =

Recall: Need help with query result

2002-05-30 Thread Memon, Michele
Memon, Michele would like to recall the message, Need help with query result. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: HELP uncancelled query

2002-05-23 Thread Dtsig
I posted this yesterday .. and it didn't seem to catch anyones imagination .. sigh PLEASE .. the developers are looking into their side but I need to find what could cause this type of thing to happen .. We do not have this problem against Oracle. I would prefer not to use Oracle for this

Help w/Query

2002-04-10 Thread Mike
Hi, I've been trying to find some info on running a select statement that would return a few rows and leave out one specific row. Here is my select statement: $result = mysql_query(SELECT ent_nws_id,img_path,substring_index(ent_body, \.\ ,1) AS ent_body FROM stns,images INNER JOIN ent_nws

Re: Help w/Query

2002-04-10 Thread Keith C. Ivey
On 10 Apr 2002, at 17:23, Mike wrote: $result = mysql_query(SELECT ent_nws_id,img_path,substring_index(ent_body, \.\ ,1) AS ent_body FROM stns,images INNER JOIN ent_nws ON stns.stns_id=ent_nws.stns_id and images.img_id=ent_nws.img_id WHERE stns.stns_id=1,$db); I'd like to leave out

RE: Help w/Query

2002-04-10 Thread Peter Lovatt
-1473 --- -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: 10 April 2002 22:24 To: mysql list Subject: Help w/Query Hi, I've been trying to find some info on running a select statement that would return a few rows

Re: help with query, pelase

2002-04-04 Thread Michael Zimmermann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At Donnerstag, 4. April 2002 15:29 Hathaway, Scott L wrote: I have the following query: select *, max(event_date) as high, min(event_date) as low from schedule where event_date between '2002-03-01' and '2003-04-30' group by

RE: help with query, pelase

2002-04-04 Thread Hathaway, Scott L
Yes, that should only cause a reordering within the group itself, but in my case, the group breaks into two groups! Scott -Original Message- From: Michael Zimmermann [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 8:58 AM To: Hathaway, Scott L; Mysql (E-mail) Subject: Re: help

Re: help with query, pelase

2002-04-04 Thread Michael Zimmermann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At Donnerstag, 4. April 2002 17:57 Hathaway, Scott L wrote: Yes, that should only cause a reordering within the group itself, but in my case, the group breaks into two groups! Your 'group by' clause needs to have the same fields (and in the same

Re: HELP: postgreSQL query - MySQL query

2002-02-26 Thread Benjamin Pflugmann
. On Mon, Feb 25, 2002 at 06:32:55PM -0800, [EMAIL PROTECTED] wrote: Hi there, I have a postgreSQL query like (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) and I'd like to have an equivalent MySQL query. Your

Re: HELP: postgreSQL query - MySQL query

2002-02-26 Thread wally liau
an equivalent MySQL query. Your help would be greatly appreciated. The reason is that we were running Java programs from Linux machines that has postgreSQL and now switched to Unix that has only MySQL (don't ask me why not get postgreSQL installed). Please copy to my email address

HELP: postgreSQL query - MySQL Query

2002-02-25 Thread wally liau
Hi there, I have a postgreSQL query like (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) and I'd like to have an equivalent MySQL query. Your help would be greatly appreciated. The reason is that we were running Java

HELP: postgreSQL query - MySQL query

2002-02-25 Thread wally liau
Hi there, I have a postgreSQL query like (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) and I'd like to have an equivalent MySQL query. Your help would be greatly appreciated. The reason is that we were running Java

HELP: postgreSQL query - MySQL query

2002-02-25 Thread wally liau
Hi there, I have a postgreSQL query like (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) INTERSECT (SELECT ... FROM... WHERE...) and I'd like to have an equivalent MySQL query. Your help would be greatly appreciated. The reason is that we were running Java

Plz help w/ query

2002-01-31 Thread Anthony Rodriguez
The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. ?php $connection=mysql_connect(localhost,wagner,xxx) or die (No connection!);

RE: Plz help w/ query

2002-01-31 Thread Rick Emery
: Plz help w/ query The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. ?php $connection=mysql_connect(localhost,wagner,xxx) or die (No connection!); $db

Re: Plz help w/ query

2002-01-31 Thread DL Neil
7:32 AM To: [EMAIL PROTECTED] Subject: Plz help w/ query The following query displays 0 e-mails. Why? Tbl con_inf holds 51 records w/ 51 usernames. Tbl scr_149 holds 37 records with 37 equivalent usernames of which 14 show date_done=0. ?php $connection=mysql_connect(localhost,wagner

RE: HELP PLEASE - C API code help: UPDATE query using result from SELECT

2001-10-01 Thread John Mravunac
- From: John Mravnuac [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 8:28 PM To: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Subject: HELP PLEASE - C API code help: UPDATE query using result from SELECT Hi, I believe that the query below is correct, but I do not believe

Re: HELP PLEASE - C API code help: UPDATE query using result from SELECT

2001-10-01 Thread Benjamin Pflugmann
Hi. As is described somewhere (http://www.mysql.com/doc/R/E/REPLACE.html), REPLACE mainly behaves like INSERT and therefore the target table may not appear in the SELECT clause (as described here: http://www.mysql.com/doc/I/N/INSERT_SELECT.html). Sorry, but it seems you have to use a temporary

Re: HELP PLEASE - C API code help: UPDATE query using result from SELECT

2001-10-01 Thread Benjamin Pflugmann
Hi. On Tue, Oct 02, 2001 at 03:53:12PM +1000, [EMAIL PROTECTED] wrote: Aha, much appreciated...your words therefore the target table may not appear in the SELECT clause have made it clear to me...but can I assume that if I was to use aliases, then I would be able to sneak past this problem?

Re: HELP PLEASE - C API code help: UPDATE query using result from SELECT

2001-10-01 Thread John Mravunac
Aha, much appreciated...your words therefore the target table may not appear in the SELECT clause have made it clear to me...but can I assume that if I was to use aliases, then I would be able to sneak past this problem? :) John :^) Benjamin Pflugmann wrote: Hi. As is described

HELP PLEASE - C API code help: UPDATE query using result from SELECT

2001-09-19 Thread John Mravnuac
Hi, I believe that the query below is correct, but I do not believe that it is possible in MySQL currently due to it not supporting sub-selects: UPDATE table1 SET ID=table2.ID, Company=table2.Company, Modified=table2.Modified FROM table1 INNER JOIN table2 ON table1.Company=table2.Company

RE: HELP PLEASE - C API code help: UPDATE query using result from SELECT

2001-09-19 Thread Will French
: John Mravnuac [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 8:28 PM To: [EMAIL PROTECTED] Subject: HELP PLEASE - C API code help: UPDATE query using result from SELECT Hi, I believe that the query below is correct, but I do not believe that it is possible in MySQL currently

C API code help: UPDATE query using result from SELECT

2001-09-18 Thread John Mravnuac
Hi, I believe that the query below is correct, but I do not believe that it is possible in MySQL currently due to it not supporting sub-selects: UPDATE table1 SET ID=table2.ID, Company=table2.Company, Modified=table2.Modified FROM table1 INNER JOIN table2 ON table1.Company=table2.Company

Help Slow Query

2001-08-06 Thread Patrick J. Militzer
Hi there, I have a query that is taking 19 - 23 sec's to complete, it used to take 5 sec or less to complete, the only thing we have added are a new database unrelated to this on. The system is a Sun Ultra 10s running Solaris 2.7 with 256mb and 333mhz processor. Mysql version is 3.22.27. Any

Re: Help Slow Query

2001-08-06 Thread Grigory Bakunov
Date |Mon, 6 Aug 2001 09:59:04 -0500 From |Patrick J. Militzer [EMAIL PROTECTED] Hello! PJM Hi there, PJM I have a query that is taking 19 - 23 sec's to complete, it used to take 5 sec PJM or less to complete, the only thing we have added are a new database unrelated PJM to this on. PJM The

Help with Query Syntax?

2001-01-29 Thread Lee Jenkins
Hi all. I'm having a little trouble with this query. **Table 1 (Orders) ** OrderID SmallInt OrderStatus VarChar(20) CustomerPhone VarChar(10) SalesRepIDSmallInt(11) **Table 2 (Customers)** CustomerFirst VarChar(20) CustomerLast

Re: Help with Query Syntax?

2001-01-29 Thread Roger Ramirez
the o.OrderID but I usually like selecting the ID from the main table being queried. - Original Message - From: "Lee Jenkins" [EMAIL PROTECTED] To: "MySQL Mail list" [EMAIL PROTECTED] Sent: Monday, January 29, 2001 10:18 PM Subject: Help with Query Syntax? Hi all.

<    1   2   3