Page 1 of 1

Select * from ALL Tables

Posted: Wed Apr 26, 2006 7:50 am
by RootKit
i have 2 problem.

1) I want to designe a link counter. when you click the link the number should increase and be writen to the table at mysql

2) How can I list the informations at ALL TABLES at Mysql that order by the most clicked 100? and how can I list the 20 last inserted data??

what can i do ?

Posted: Wed Apr 26, 2006 10:07 am
by feyd
  1. That would be a "specially" crafted UPDATE query. We've had many examples of this on the forum. I can remember one recently being asked. Poke around for a bit.
  2. A UNION can be used to select from multiple tables somewhat independantly of other queries in it. Why would there be multiple tables that contain the same information though? I fail to see a use for this.