Re: Materialized Views

This site gives information on how to create triggers to automatically maintain your MV: www.materialized.info

Re: Materialized Views

There is also www.materialized.info , providing a simpler example of creating a MV, including triggers to maintain it.

Re: Materialized Views

Ok Thanks El 23/06/2013 21:13, "Reindl Harald" escribió: > > > Am 23.06.2013 20:59, schrieb Bruce Ferrell: > > On 06/23/2013 11:18 AM, Rafael Valenzuela wrote: > >> Hi All, > >> I have a question about the materialized views , i remember in the D

Re: Materialized Views

Am 23.06.2013 20:59, schrieb Bruce Ferrell: > On 06/23/2013 11:18 AM, Rafael Valenzuela wrote: >> Hi All, >> I have a question about the materialized views , i remember in the DBA >> course my trainer said me. In Mysql doesn't exist this type views like >> Oracle

Re: Materialized Views

On 06/23/2013 11:18 AM, Rafael Valenzuela wrote: Hi All, I have a question about the materialized views , i remember in the DBA course my trainer said me. In Mysql doesn't exist this type views like Oracle. But My boss think the opposite. In the new version has this type of view? an

Re: Materialized Views

On 06/23/2013 11:18 AM, Rafael Valenzuela wrote: Hi All, I have a question about the materialized views , i remember in the DBA course my trainer said me. In Mysql doesn't exist this type views like Oracle. But My boss think the opposite. In the new version has this type of view? an

Materialized Views

Hi All, I have a question about the materialized views , i remember in the DBA course my trainer said me. In Mysql doesn't exist this type views like Oracle. But My boss think the opposite. In the new version has this type of view? and the diferences the differences between views Mysq

Re: Long integer constant problem in views

2013/04/30 17:17 +0200, Martin Koch CREATE OR REPLACE VIEW foo AS SELECT * FROM mytable WHERE id = X'36a461c81cab40169791f49ad65a3728'; Try this: _binary X'36a461c81cab40169791f49ad65a3728' SHOW CREATE VIEW is the command for the client. -- MySQL General Mailing List Fo

RE: Long integer constant problem in views

WHERE id = UNHEX('36a461c81cab40169791f49ad65a3728') > -Original Message- > From: Martin Koch [mailto:m...@issuu.com] > Sent: Tuesday, April 30, 2013 8:18 AM > To: mysql@lists.mysql.com > Subject: Long integer constant problem in views > > Hi List > &

Long integer constant problem in views

Hi List I have a table with a primary key with type binary(16) and a few columns. I'd trying to create a view that looks up all rows with a particular key, i.e. something like CREATE OR REPLACE VIEW foo AS SELECT * FROM mytable WHERE id = X'36a461c81cab40169791f49ad65a3728'; I use the mysq

Re: MySQL 5.1: Views, queries, updates and performance issues

what columns are being indexed If any columns are not indexed that should be, create said index(es) Next view Of course, this process could be optimized by looking at the views in terms of their frequency of use. Finally, you didn't mention what sort of front end you're using. It'

MySQL 5.1: Views, queries, updates and performance issues

Hi all, I've got some semi-general questions on the topics in the title. What I'm looking for is more in the line of theory than query specifics. I am but a poor peasant boy. What I have is an application that makes heavy use of views. If I understand views correctly (and I may n

RE: Federated Tables versus Views

m] On Behalf Of Wellington Fan Sent: Friday, October 08, 2010 9:52 AM To: mysql@lists.mysql.com Subject: Federated Tables versus Views Hello All, What should I consider when trying to choose between a Federated table and a View when I have one table's data that I'd like to be ava

Federated Tables versus Views

Hello All, What should I consider when trying to choose between a Federated table and a View when I have one table's data that I'd like to be available in other databases on the same host. My view definition would be something like: CREATE [some options] VIEW [this_db].[this_view] AS

Re: question about VIEWS in 5.1.x

On 03/09/2010 9:26 p, Hank wrote: On Fri, Sep 3, 2010 at 6:23 AM, Jangita wrote: On 02/09/2010 8:30 p, Hank wrote: Simple question about views: Hank, Have you tried "running away from the problem :-)" by doing... CREATE PROCEDURE `combo`(theid INT) BEGIN (SELECT * F

Re: question about VIEWS in 5.1.x

On 03/09/2010 9:27 p, Hank wrote: On 02/09/2010 8:30 p, Hank wrote: Simple question about views: Hank, Have you tried "running away from the problem :-)" by doing... CREATE PROCEDURE `combo`(theid INT) BEGIN (SELECT * FROM table1 WHERE id = theid) UNION

Re: question about VIEWS in 5.1.x

On 02/09/2010 8:30 p, Hank wrote: >> >> Simple question about views: >> >> > Hank, > Have you tried "running away from the problem :-)" by doing... > > CREATE PROCEDURE `combo`(theid INT) > BEGIN >(SELECT * FROM table1 WHERE id = theid)

Re: question about VIEWS in 5.1.x

On 9/3/2010 6:23 AM, Jangita wrote: On 02/09/2010 8:30 p, Hank wrote: Simple question about views: I have a view such as: create view combo as select * from table1 union select * from table2; ... (I've also tried "UNION ALL" with t

Re: question about VIEWS in 5.1.x

On 02/09/2010 8:30 p, Hank wrote: Simple question about views: I have a view such as: create view combo as select * from table1 union select * from table2; Where table1 and table2 are very large and identical and have a non-unique key on field &qu

question about VIEWS in 5.1.x

Simple question about views: I have a view such as: create view combo as select * from table1 union select * from table2; Where table1 and table2 are very large and identical and have a non-unique key on field "id".. when I do a: select * from c

Re: can't dump a database with views: "stack smashing detected ***: mysqldump terminated"

On 22.02.2010 13:04, Jesper Wisborg Krogh wrote: On 22/02/2010, at 9:20 PM, Tomasz Chmielewski wrote: When I try to dump a database which contains views, mysqldump crashes: # mysqldump -u root --opt --password=secret database > dump.sql *** stack smashing detected ***: mysqldump termina

Re: can't dump a database with views: "stack smashing detected ***: mysqldump terminated"

On 22/02/2010, at 9:20 PM, Tomasz Chmielewski wrote: When I try to dump a database which contains views, mysqldump crashes: # mysqldump -u root --opt --password=secret database > dump.sql *** stack smashing detected ***: mysqldump terminated Aborted # I use MySQL 5.0.89-0.glibc23 binar

can't dump a database with views: "stack smashing detected ***: mysqldump terminated"

When I try to dump a database which contains views, mysqldump crashes: # mysqldump -u root --opt --password=secret database > dump.sql *** stack smashing detected ***: mysqldump terminated Aborted # I use MySQL 5.0.89-0.glibc23 binaries from MySQL website. Is it a known problem? Are there

Fwd: Does mysql support materialized views?

1 PM, Lin Chun wrote: >> > Hi  Olexandr Melnyk >> > >> > That's to say, create the aggregation tables and update them by >> > triggers? >> > I've noticed a "update view" in Mysql , can it work under the aggretate >> > operatio

Re: Does mysql support materialized views?

On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun wrote: > Hi  Olexandr Melnyk > > That's to say, create the aggregation tables and update them by triggers? > I've noticed a "update view" in Mysql , can it work under the aggretate > operation? You're not looking

Re: Does mysql support materialized views?

On Apr 20, 2009, at 11:34 AM, Olexandr Melnyk wrote: No, you will have to "emulate" them using triggers or stored procedures. Or: 1. Create table "this_is_not_a_view" and use that as the materialized view 2. Build a new version in the background "this_is_not_a_view_pending" as per your

Re: Does mysql support materialized views?

No, you will have to "emulate" them using triggers or stored procedures. On Mon, Apr 20, 2009 at 12:28 PM, Lin Chun wrote: > Hi > > I am now working with Mondrian , and need  tuning the database, as the > materialized views can improve the performance > and doesn't

Re: Does mysql support materialized views?

No On Mon, Apr 20, 2009 at 2:58 PM, Lin Chun wrote: > Hi > > I am now working with Mondrian , and need tuning the database, as the > materialized views can improve the performance > and doesn't need to create the fact tables > > > > cheers > -- >

Does mysql support materialized views?

Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- - Lin Chun

Re: Views and replication

would mean "user > logged in in current session", not "user that was logged in when creating > the view". > > How can I get around this, I do not want to re-create all user that > potentially could create views on the slave. > > Thanks > Olaf > Tak

Views and replication

I get around this, I do not want to re-create all user that potentially could create views on the slave. Thanks Olaf - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may

RE: Efficient use of inline virtual views

Perhaps I am missing something, but why not do this as an inner join? SELECT man .name, GROUP_CONCAT( car. make ) AS 'makes' FROM man INNER JOIN car ON man. id = car.owner_id GROUP BY man .id On my box this query is about 3X faster. I think Mysql is known for not performing well with (especially c

Efficient use of inline virtual views

Hi, I have the below setup: --A man can have multiple cars CREATE TABLE man (id INTEGER, name VARCHAR(64)); CREATE TABLE car (id INTEGER, owner_id INTEGER, make VARCHAR(64)); --Add data INSERT INTO man VALUES (1, 'John'); INSERT INTO car VALUES (1, 1, 'Mazda'); INSERT INTO car VALUES (2, 1, '

Database with a lot of views

In our application, each user has an won set of tables. We're migrating to a shared table set, with an extra field in each table, identifying the user a particular rows belongs to. In order to keep database changes minimal, we're thinking of using an own set of views for each user. Is

RE: Views accessed as table in MS Access

Interesting. I also tried using views in Access, and found that it only gives data from the first table specified. However, when I tried accessing the same view from OpenOffice using ODBC, it worked fine. Are there any other ways we can find out if this is a MyODBC error or Access/MSJET

Re: Views accessed as table in MS Access

ect results for above situation. Is it MySQL ODBC driver probelm? Yes. The use of views and stored procedures is not yet stable and is unsupported. and if yes it is solved in latest ODBC 5 version? No. I still can't get any action from the latest MyODBC ( v5 ) release. or is it Access err

Views accessed as table in MS Access

Hello, I am using MySQL 5.0.17 and MyODBC 3.51.12 with MS Access 2003/Xp with Jet 4.0. Currently it is not giving the normal problem of Access while inserting new records (#deleted), but when a View created in database is linked with MS Access it is not giviing correct results. e.g. There are two

Re: RE: [others] Re: Views with functions and performance issues

The hit with a join on indexed columns is negligible. Relational databases live for joins - they eat them for breakfast! Seriously, as long as it's indexed in both tables, it'll be super-speedy. Dan On 9/22/06, Christopher Brooks <[EMAIL PROTECTED]> wrote: Hi, thanks for the comments, > If I

RE: [others] Re: Views with functions and performance issues

Hi, thanks for the comments, > If I'm understanding right - the view contains an additional > column that is an MD5 hash of some or all of the data in the > base table, right? Close. It's got all of the data in the base table except for the colum that's being hashed - we show the hashed versio

Re: Views with functions and performance issues

If I'm understanding right - the view contains an additional column that is an MD5 hash of some or all of the data in the base table, right? Yes, I would expect that to be very very slow. When selecting, your database engine has tro calculate 700K MD5 hashes. Slow. When selecting a subset it h

Views with functions and performance issues

Hi, I've got a view of a base table that is 100% identical to that base table except for one column, which is a projection of the base table after its MD5 hashed. The table is largish (~700,000 rows) and is growing quickly. Queries on the base table are nice and fast, but on the hashed view are p

Views can't refer to temporary tables

Greetings. Continuing on from my previous question, I've discovered that I *can't* create views which refer to temporary tables. Is there any plan to drop this requirement? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060

Question on views, stored procedures & temporary tables

Hi all. I have a long and complicated chain of queries in MS Access that I want to port to using stored procedures & views. What I'd like to do is something like: 1) stored procedures grabs original data set, and dumps into temporary tables 2) I open a view, which is in turn based

RE: Stored procedures and views

data_result END// DELIMITER ; > -Original Message- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: Friday, March 24, 2006 1:04 PM > To: Chris Carrier; mysql@lists.mysql.com > Subject: Re: Stored procedures and views > > > > > I just mean is it po

Re: Stored procedures and views

> I just mean is it possible to hook a set of stored procedures to a view as > opposed to a temporary table that we'd have to explicitly update? "hook"? If you mean: using the views in select statements inside a procedure: sure it. Did you try? Martijn Tonies Database Wo

RE: Stored procedures and views

bject: Re: Stored procedures and views Chriss, > I'm trying to create a flatfile dump from our database which requires some > functionality that's not possible with raw sql. Up to now we've been using > PHP tied to mySql to do all the work and get the data in the correct form

Re: Stored procedures and views

Chriss, > I'm trying to create a flatfile dump from our database which requires some > functionality that's not possible with raw sql. Up to now we've been using > PHP tied to mySql to do all the work and get the data in the correct format. > We would like to switch this functionality over to sto

Stored procedures and views

Howdy folks, I'm trying to create a flatfile dump from our database which requires some functionality that's not possible with raw sql. Up to now we've been using PHP tied to mySql to do all the work and get the data in the correct format. We would like to switch this functionality over to stored

On MySQL Views (Re: Accountability with MySQL)

Hello Gordon, > And now we are down to reality. This is a MySQL list. Views are a wonderful > thing for creating an isolation layer between the application and the > database. However, MySQL's current implementation makes it extremely > difficult in many cases to avoid full tab

Results of materialized views project

architecture of MySQL and suggest refactoring to implement materialized views. First off, thanks for all the responses we got; we got some good ideas from them. Since we are all fans of MySQL, I promised to post our results in the hope that it would be of help to MySQL. Our full final report can be

Re: Addition: Order By Statement in Views not working properly

Hello. What exact version of MySQL are you using? Please could you provide a repeatable test case. Scott Klarenbach wrote: > Must be a bug of sorts: > > If you add an ORDER BY clause to the view itself, then mysql allows > the caller to override with their own ORDER BY clause and it wor

Addition: Order By Statement in Views not working properly

Must be a bug of sorts: If you add an ORDER BY clause to the view itself, then mysql allows the caller to override with their own ORDER BY clause and it works as expected. However; if no ORDER BY clause is present in the CREATE VIEW statement, then the caller receives erroneous results if they ca

Order By Statement in Views not working properly

Mysql seems to have a problem returning ordered lists from views. ie, 'select * from myView order by column' does not return a properly ordered list. (it does change the ordering sequence, but to an erroneous list) converting myView to be a Temporary Table using 'ALGORITHM=TE

RE: Input on Materialized Views

> Better, mark this view (or particular rows if it's not too > expensive) as "dirty" and recompute it only on access, you > may spare few cycles... That sort of depends on what you're going for. Typically materialized views are used for summarizations of hypercubes

Re: Input on Materialized Views

2005/10/20, Heikki Tuuri <[EMAIL PROTECTED]>: > Andrew, > > how about using triggers to recompute materialized views? A challenge is to > write an automatic program that can compute the required triggers based on > the view definition. The materialized view would be a n

Re: Input on Materialized Views

On 10/19/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > So... which of the many storage engines are you hoping to extend? It would > be nice if you could do them all but I think we all anticipate that InnoDB > will pose special challenges. After a bit of group consultation, we've decided to

Re: Input on Materialized Views

Andrew, how about using triggers to recompute materialized views? A challenge is to write an automatic program that can compute the required triggers based on the view definition. The materialized view would be a normal table. Triggers would update it. Regards, Heikki Oracle/Innobase

Re: Input on Materialized Views

How you redefined your project definitely makes your goal much easier to reach. As I see it, most of what you need to do is related to figuring out how to create disk-cached VIEWs and how to invalidate the cache whenever any of the VIEW's underlying data has changed. This doe

Re: Input on Materialized Views

Thanks for the clarification and comments. I should reiterate that for our project, we do *not* need to actually implement materialized views, but only suggest refactoring and/or new components required to implement them. I think implementing it would too time consuming for a group of three

Re: Input on Materialized Views

group of three students in Professor Ric. Holt's Software > > Architecture class at the University of Waterloo. As our project, we > > would like to examine the MySQL source to determine the best way to > > implement materlialized views. > > It would be wise to hang arou

Re: Input on Materialized Views

Andrew Roth wrote: Hi all, We are a group of three students in Professor Ric. Holt's Software Architecture class at the University of Waterloo. As our project, we would like to examine the MySQL source to determine the best way to implement materlialized views. It would be wise to

Input on Materialized Views

Hi all, We are a group of three students in Professor Ric. Holt's Software Architecture class at the University of Waterloo. As our project, we would like to examine the MySQL source to determine the best way to implement materlialized views. What we would like to know is: 1. How fea

Re: views in 5.0.11

Hello. This is very similar to: http://bugs.mysql.com/bug.php?id=12382 Fix will appear in 5.0.12 Rich Allen <[EMAIL PROTECTED]> wrote: > iH > > i have a view created in 5.0.11 on several innodb tables. when doing > a select * on the view after first getting into the mysql comma

views in 5.0.11

iH i have a view created in 5.0.11 on several innodb tables. when doing a select * on the view after first getting into the mysql command line, the last column has incorrect values. without running any other command and performing the same select statement, all columns are correct. is t

Re: Date/Time Problem with V5.0.6 views

Hello. You said that you had created a view, but you continued using Tab_A instead of Tab_A_View in your next queries. Did you want to use view Tab_A_View? On my MySQL 5.0.9 all queries works both with view and original table. See: mysql> desc Tab_A; +++-

Date/Time Problem with V5.0.6 views

Hello everyone, I cannot figure this out. I have a table like the following: Tab_A datetime_field datetime not null, num_field bigint not null I do a SELECT as follows: Select datetime_field, num_field from Tab_A where datetime_field='2005-03-10' and num_field = 1234; I return 2 ro

Re: Views in 5.0.1

Thanks for the detailed information, this is much clearer. I look forward to 5.0.x becoming release. Kind regards, Ben Clewett. Joerg Bruehe wrote: Hi Ben, all! Ben Clewett wrote ((re-ordered into posting sequence)): Joerg Bruehe wrote: Hi Ben! Ben Clewett wrote: [[...]] Approxima

Re: Views in 5.0.1

Hi Ben, all! Ben Clewett wrote ((re-ordered into posting sequence)): Joerg Bruehe wrote: Hi Ben! Ben Clewett wrote: [[...]] Approximately when will 5.0.1 be available as stable release? 5.0.1 will never change, it is out (and obsolete by now). [[...]] I am trying to work out how s

Re: Views in 5.0.1

Ben Clewett wrote: Joerg, I am trying to work out how stable 5.0.x is. Related to why MySQL advise people to wait for the 'release' status. You say 5.0.1 is old and obsolete. Yet is not at release stage yet. This is curious. Will 5.0.1 be changed before release? For example: Will large

RE: Views in 5.0.1

ive' for 'production'. As such, there are no such live versions available yet. Hope this helps. Cheers, Jared. -Original Message- From: Ben Clewett [mailto:[EMAIL PROTECTED] Sent: 18 July 2005 14:35 To: Joerg Bruehe Cc: mysql@lists.mysql.com Subject: Re: Views in 5.0.1

Re: Views in 5.0.1

Joerg, I am trying to work out how stable 5.0.x is. Related to why MySQL advise people to wait for the 'release' status. You say 5.0.1 is old and obsolete. Yet is not at release stage yet. This is curious. Will 5.0.1 be changed before release? For example: Will large errors (eg, server

Re: Views in 5.0.1

Hi Ben! Ben Clewett wrote: [[...]] Approximately when will 5.0.1 be available as stable release? 5.0.1 will never change, it is out (and obsolete by now). You probably refer to the 5.0 family of releases, of which 5.0.9-beta was published last week. The 5.0 releases have to pass the "beta" a

Views in 5.0.1

Dear MySQL, I have need to use VIEWS. (This is to protect my database from programmers, but that's another story :) This is available in version 5.0.1, which is not at release level yet. We are on 4.1.9. May I ask a couple of questions! Approximately when will 5.0.1 be available as s

Re: How to implement views in mysql 4.12 version

Hi, Waiting for v5 for views, you can prepare them in inline view (subqueries): select ... from (select ...) Mathias Selon Duncan Hill <[EMAIL PROTECTED]>: > On Monday 23 May 2005 20:01, Dayakar wrote: > > Please give me solutions at the earliest as mirgration from oracle

Re: How to implement views in mysql 4.12 version

On Monday 23 May 2005 20:01, Dayakar wrote: > Please give me solutions at the earliest as mirgration from oracle to mysql > is started and i need to meet the solution as soon as possible. 4.1 does not support views. As documented in the online documentation: "Views (including upda

Re: How to implement views in mysql 4.12 version

At 0:31 +0530 5/24/05, Dayakar wrote: Hello, I want a solution to implement the views in mysql 4.12 version. It is urgent. Earlier our database was oracle and our search of database is done using views. I want to implement the same in mysql 4.12 version. Does any one know how to do it

Re: How to implement views in mysql 4.12 version

On Monday 23 May 2005 02:01 pm, Dayakar wrote: > I want a solution to implement the views in mysql 4.12 version. It is > urgent. Earlier our database was oracle and our search of database is done > using views. I want to implement the same in mysql 4.12 version. You need version 5.0.

How to implement views in mysql 4.12 version

Hello, I want a solution to implement the views in mysql 4.12 version. It is urgent. Earlier our database was oracle and our search of database is done using views. I want to implement the same in mysql 4.12 version. Does any one know how to do it. Please give me solutions at the earliest as

Re: how to create views in mysql4.1

On Sunday 21 November 2004 08:38 am, Dayakar wrote: > Can any one help me in creating view using mysql4.1. If we cannot then any > other alternative. It would be great if anyone give me an example for that. Thats a 5.0 feature.. Your not gonna get to far with 4.1.. Jeff -- =

Re: how to create views in mysql4.1

- Original Message - From: "Dayakar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 21, 2004 9:38 AM Subject: how to create views in mysql4.1 > Hello friends, > > Can any one help me in creating view using mysql4.1. If we cannot then

how to create views in mysql4.1

Hello friends, Can any one help me in creating view using mysql4.1. If we cannot then any other alternative. It would be great if anyone give me an example for that. regards dayakar SMILE ALL THE WHILE.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: strange difference in creating views (mysql 5.0.1)

I suspect that you actually have two records in address_association that don't match up with a record in address. Yes, either a data mismatch or data duplication would be suspected in a case like this. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Elim Qiu" <[EMAIL PROTEC

strange difference in creating views (mysql 5.0.1)

I'm trying to create a view from two tables address and address_association. So I did the following and expect they are the same: CREATE VIEW associated_address AS select t0.association_id AS association_id, t0.property_dict AS property_dict, t0.type_id AS type_id, t0.owner_id AS owner_id, t0.own

RE: views/cursors in mysql 4.0

Yes. Best of luck with your conversion! Shawn Green Database Administrator Unimin Corporation - Spruce Pine <[EMAIL PROTECTED]> wrote on 09/30/2004 05:25:22 PM: > > Hi, > > Thank you very much for your reply. So for the cursors result > set C API's will be suitable ..right?. > > thanks,

RE: views/cursors in mysql 4.0

Hi, Thank you very much for your reply. So for the cursors result set C API's will be suitable ..right?. thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of

RE: views/cursors in mysql 4.0

There are > 3 layers in the database like table layer, view layer and DBview > layer. The DBView layer communicates through API's with both table > and view layers. Views and tables are created dynamically through > API's. Here Views are created for each table (reason i too d

Re: views/cursors in mysql 4.0

> Could you please let me know the alternatives for stored procedures and Triggers in mysql 4.0. The only alternative is application code. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com

RE: views/cursors in mysql 4.0

through API's with both table and view layers. Views and tables are created dynamically through API's. Here Views are created for each table (reason i too donot know). And used some stored procedures at module level and some triggers on some table before/after updating. The above existe

RE: views/cursors in mysql 4.0

Views - instead of running queries against views, you will have to run your queries against the underlying tables. This may mean lots of changes to your SQL statements. What once appeared as a single query may now have to be performed in multiple steps to achieve the same results. Usually

RE: views/cursors in mysql 4.0

Hi, Thank you for your response. Strictly we have to use mysql 4.0 only. Actually the source data base is oracle 7.3, we need to migrate that database to mysql 4.0 . In oracle 7.3 views/cursors are used. That is why i need an alternative for views/cursors in mysql 4.0. We use C/C++ for

Re: views/cursors in mysql 4.0

Views and Cursors are not available in MySQL 4.x. Usually your scripting language handles cursors for you (having them in 4.x would do you little good as stored procedures don't exist yet. Look at the current 5.x development for cursors and stored procedures). What language do you s

views/cursors in mysql 4.0

Hi, How to implement views/cursors in mysql 4.0?. Normally in mysql how the selected data is maintained in the recordsets?. Is there any other alternatives to implement views/cursors in mysql 4.0?. Please advise me for the better solution. Thanks, Narasimha Confidentiality Notice

VIEWS and SHOW TABLE STATUS in MySQL 5.0.1

Hi, Currently, a VIEW lists "NULL" as value for the "Engine" column in the SHOW TABLE STATUS resultset. Is this the right behaviour? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- M

Re: Finding Tables created by views

In the last episode (Jul 01), Martin Gainty said: > I have a table that is chock full of errors..(PLAN shows Table Access > full) so I know that it was created wrong Is there an easy way to > setup a query to locate all views that use this table? Mysql doesn't support views yet. It

Finding Tables created by views

Folks- I have a table that is chock full of errors..(PLAN shows Table Access full) so I know that it was created wrong Is there an easy way to setup a query to locate all views that use this table? Thanks, Martin Gainty (cell) 617-852-7822 From: Bill MacAllister <[EMAIL PROTECTED]> To

Re: Views Syntax for MySQL 5

Un-named views are supposed to be there already. I know this is not the "real thing", I just thought I would mention it. ;-) Cheers Andrew. - Original Message - From: "Josh Trutwin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 22,

Re: Views Syntax for MySQL 5

On Tue, 22 Jun 2004 16:34:44 +0100 "Nic Skitt [Real Productions]" <[EMAIL PROTECTED]> wrote: > Hi All, > > I have noticed a lack of comments re Views. > > Is it 5.0 or 5.1 that we will have Views capability? > > I had hoped it was in the most up to d

Views Syntax for MySQL 5

Hi All, I have noticed a lack of comments re Views. Is it 5.0 or 5.1 that we will have Views capability? I had hoped it was in the most up to date public development release of 5. Unless I am getting the Views syntax wrong I assume its not there. If it is not already packaged in V5.0 then

Re: Are Views Supported?

On May 27, 2004, at 11:16 PM, Jake Johnson wrote: I was wondering when or will views be supported? http://dev.mysql.com/doc/mysql/en/ANSI_diff_Views.html -- greg willits -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Are Views Supported?

Hello, I was wondering when or will views be supported? -- Jake Johnson http://www.plutoid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   >