mysql view implementation

Hi there, Does anyone know how views are implemented in MySQL? Is the view query executed each time the view is interacted with (ie. query modification) or is there some sort of caching involved (i.e. view materialization). thanks

SUBSELECT QUESTION?

Hi, I have a table SalaryInfo as below Salary | Department | Level 50 | RD| Director 3 | Maintenance| Groundsman ... I want to know what level in each department makes the highest salary and how much that salary is? Something like: SELECT Salary, Level, Department FROM

RE: mysql Digest 21 Oct 2003 17:33:01 -0000 Issue 2672

Hi, I have a table SalaryInfo as below Salary | Department | Level 50 | RD| Director 3 | Maintenance| Groundsman .. I want to know what level in each department makes the highest salary and how much that salary is? Something like: SELECT Salary, Level, Department FROM

boolean type

Does there exist a boolean column type? I checked the documentation, and it says that there exists a BOOL but it is a tinyint(1). Should I use that as a boolean? thanks in advance, prashant. query to go through filter. - Before

data migration between different computers with mysql

Hi, I am new to the database world, so I wanted to get some facts straight. I have built an application which runs with MySQL. I want to distribute the application along with the data. The target computers would also have MySQL. I have observed that I can zip up the data directory under mySQL