Is there a query to update record by specify the position of record or row?
update tableA set col_name = somthing ...( at row number 123)
thanks for help!
Regards,
_
MSN Photos is the easiest way to share and print your photos:
I have 2 tables, let says, table A and table B. Each table record person
name.
select B.name from B, A where B.name = A.name
Query above should return the name which recorded in both tables (duplicate
name)
In reverse, how can I retrive the name which recorded in Table B and not
present in
You can do with both of perl and php
but, you should not to do that, you'll get slow data retrieval
and you database's size will extremely large!
Save pathname should be enough.
From: ST Ooi [EMAIL PROTECTED]
Reply-To: ST Ooi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: How to read blob
Howabout
select record.* from record left join user on
user.account=record.account where user.username='george';
Since there is no table name account
select record.* from record left join account on
account.username=record.account where account.username='george'
SELECT account FROM user