[plumberg]

Hi,

This seems to be a great place. Hope to get some clarifications of doubts that I have....

1. In Oracle, we have "select * from dual", a temporary table. Does Mysql Also support any such formation?

2. In Oracle, we have "select count(1) from dual v/s Select count(*) from dual". Any efficient way to count number of rows returned in MYSql?

3. I have an master table of Products (product id, product name), identified uniquely by a product ID. Now, i haves some orders associated with the products. Tomorrow, I modify the Product name, i believe all references will be affected. I want to know a mechanism which would allow usage of OLD Product name and New Product name.. ie. for all transactions with OLD Product name, they should be referred with the old name, however, new transactions for same product should be associated with NEW Name.. how can we associate them.. any date usage required???... Hope I am not too confusing..

4. How can we store the UNIX Timestamp in MYSQL and then, retrieve it for comparision?

Hope to receive the replies to the above queries soon. Thanks for the gr8 site once again.

-Calvin P

[UnrealEd]

hi,

i have answers for the first two questions.

1. yes you can use practicly the same syntax in MySQL:
"SELECT * FROM yourtable"
2. yes, same as with 1:
this one counts the total number of entries:
"SELECT count(*) FROM yourtable"
this one counts the selected entries of a query:
mysql_num_rows(mysql_query($query));

the third, i didn't understand quite well
and the fourth i don't know: i tried mysql.com, but no results

Greetz,
UnrealEd