- Forwarded by Shawn Green on 10/26/2004 01:52 PM -
ok - I just forgot this idea with left comparision
thanks for explanation
about indexes i thought about another index on client_tbl containing
fields:
clientid and zoneid
both fields are used very often
I also thought about index conta
Sorry guys, I forgot to post to the list as well..
-Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Friday, 6 August 2004 9:27 AM
To: [EMAIL PROTECTED]
Subject: RE: Question
Hi there,
Can you please provide a sample of a query that is not working? Also if you
cou
On Wednesday 22 January 2003 21:10, Norris Joseph wrote:
> Hello,
>
> I have the following in my SQL:
>
> update call_center set call_center.who_for_id = activeemployees.hr_emp_no
> where call_center.who_for_id = activeemployees.id;
>
>
> This is something I think that I should be able to do, but
-Original Message-
From: Norris, Joseph
Sent: Wednesday, January 22, 2003 10:56 AM
To: Mysql_List (E-mail)
Subject: question about update sql
Hello,
I have the following in my SQL:
update call_center set call_center.who_for_id = activeemployees.hr_emp_no
where call_center.who_for_id
At 11:20 +0200 11/22/02, Mircea LUTIC wrote:
Hello!
Question: Can I rely on the following behaviour?
mysql> create table test(id integer not null auto_increment primary key, t
char(15));
mysql> insert into test(t) values (last_insert_id());
mysql> insert into test(t) values (last_insert_id()+1);
Hello!
Question: Can I rely on the following behaviour?
mysql> create table test(id integer not null auto_increment primary key, t
char(15));
mysql> insert into test(t) values (last_insert_id());
mysql> insert into test(t) values (last_insert_id()+1);
mysql> select * from test;
++--+
| id
Please ignore the last email, I just found the link :) (need more coffee)
---
Chris Kay
Technical Support - Techex Communications
Website: www.techex.com.au Email: [EMAIL PROTECTED]
Telephone: 1300 88 111 2 - Fax: (02) 99
