query to update record by the position of row

2002-07-09 Thread Pichan M.
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:

Retrive distinct data from two tables

2002-03-13 Thread Pichan M.
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

Re: How to read blob field data as picture and display on browser?

2002-01-22 Thread Pichan M.
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

Re: How to join MsQL queries?

2001-09-21 Thread Pichan M.
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