mysql view implementation

[Prashant Pai]

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
_
All the news that matters. Just the way you like it. 
http://www.msn.co.in/News/ Only at MSN News!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SUBSELECT QUESTION?

[Prashant Pai]

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 SalaryInfo WHERE
Salary=Max(Salary)

Would using MySQL 4.1 that has support for nested select help my case?

Thanks in advance
prashant

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[Prashant Pai]

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 SalaryInfo WHERE
Salary=Max(Salary)

Would using MySQL 4.1 that has support for nested select help my case?

Thanks in advance
prashant



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

boolean type

[Prashant Pai]

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 posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

data migration between different computers with mysql

[Prashant Pai]

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 and then
unzip it in the target computer and it works.

What I want to know is whether, this is the best and easiest way. (the other
being to import/export to text files, XML etc.) or are they are chasms which
I fail to see?

thanks.

ps: It would be great if you could cc your replies to this one
prashantpaiAThotmailDOTcom



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php