On MySQL Views (Re: Accountability with MySQL)

2006-03-16 Thread Martijn Tonies
le scans when you define the > logical view. {Not poking at the development team I think 5.x is a huge step > forward}. Can you elaborate on that? Any real world experience with MySQL views? The thing that annoys the blo*** cr** out of me with the current implementation is the maintainabi

re: MySQL Views

2002-09-20 Thread Egor Egorov
Art, Friday, September 20, 2002, 3:48:06 AM, you wrote: AF> Since MySQL does not have views or queries that can be within the database, AF> is there a way to make tables which are subtables of the main table? For AF> example, I have an ID that goes from 0010-10010 to 7000-. I want a table AF>

MySQL Views

2002-09-19 Thread Art Fore
Since MySQL does not have views or queries that can be within the database, is there a way to make tables which are subtables of the main table? For example, I have an ID that goes from 0010-10010 to 7000-. I want a table that will show only those items with LIKE '0080-%'. This table should be