Views !!

Hi again Folks !! How may create a view in mysql, o make some seem to the queiries in access !!! THanks Pablo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Another Localtion for databases

Hi Folks!! I have a question, How may set another location for my productions db, so, for instance if i want put my db in /mydb filesystem in my Linux Redhat??? because when i create a db, this is in /var/lib/mysql/data Please , help me Thanks !! Pablo -