Re: Two approaches, which one is better ?

2006-06-09 Thread Iván Alemán
create-index.html A view is a pseudo-table based on a query or set of queries. Consider a query that selects 3 columns from a table that contains 16 columns. You now have a particular 'view' of that tablein the form of a table. http://dev.mysql.com/doc/refman/5.1/en/create-view.html

Two approaches, which one is better ?

2006-06-09 Thread Iván Alemán
see any direct advantage of the use of #2 instead of #1, except that am using more SQL code ;), I've read about MySQL indexes on the manual but haven't founded the answer yet, so these are the questions: Which is the best way to do the query #1 or #2? Why query #1 or #2 is the best? Is

mysql workbench installation issues

2006-05-10 Thread Iván Alemán
Description +++-==-==- ii mysql-workbench1.0.6beta-2A MySQL visual modeling tool. So I don't know what going on, any thoughts Thank you Ivan -- Iván Alemán ~ [[ m o f o ]] ~ Debian (SID) -BEGIN GEEK CODE BLOCK- Version: 3.12 G!>GCM d+ s