Re: SQL DATA

2011/12/13 16:10 -0500, Shawn Green (MySQL) Many of you are missing the big picture. This flag (along with most of the others you can use to describe a stored procedure) are meant to indicate to the replication system whether it needs to log the CALL to this procedure and in which form

Re: SQL DATA

Hello All, On 12/5/2011 14:20, wrote: A procedure MODIFIES SQL DATA if all the modifying involves a temporary table, or only READS SQL DATA? Does it matter whether the temporary table is meant to outlast the procedure-call? Many of you are missing the big picture. This flag (along with

Re: SQL DATA

I didn't say anything about recursive optimizations. All I said was the following statement: "When the procedure is executed, each query in the procedure is obviously run through the query optimizer. " 2011/12/13 Arthur Fuller > I am not sure that the db engineers should look into supporting re

Re: SQL DATA

I am not sure that the db engineers should look into supporting recursive optimizations. That sounds to me like a waste of their time, and conversely an investment in your (my) time. This kind of thing is far too app-specific to generalize into an all-encompassing algorithm, IMO, and even if it cou

Re: SQL DATA

binding in any way. There's nothing > preventing me from declaring my procedure > > * READS SQL DATA indicates that the routine contains statements that > read data (for example, < > http://dev.mysql.com/doc/refman/5.0/en/select.html>SELECT), but not > s

Re: SQL DATA

2011/12/09 20:37 -0500, Singer X.J. Wang When the procedure is executed, each query in the procedure is obviously run through the query optimizer. But the flags are symbolic only for humans. "Obviously"? As I wrote, someone said that the optimizer does _not_ look into procedur

Re: SQL DATA

;>>> 2011/12/08 10:21 -0500, Singer X.J. Wang >>>> But again one of the flags are binding in any way. There's nothing preventing me from declaring my procedure * READS SQL DATA indicates that the routine contains statements that read data (for example, <http:/

Re: SQL DATA

2011/12/05 14:26 -0500, Singer X.J. Wang Note that all the flags are non binding.. YMMV... Yes, but what does it _mean_? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

SQL DATA

A procedure MODIFIES SQL DATA if all the modifying involves a temporary table, or only READS SQL DATA? Does it matter whether the temporary table is meant to outlast the procedure-call? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

[ANN] SQL Data Wizard 1.3 released

Hello, SQL Maestro Group is happy to announce the release of SQL Data Wizard 1.3 - a powerful Windows GUI utility for MySQL data export, import, database conversion and PHP script generation. The trial version of the software is available at http://www.sqlmaestro.com/products/mywizard

RE: using .dat SQL Data in mySQL DB

] Subject:using .dat SQL Data in mySQL DB Hi, I have a .dat file.. with some data like this : 02001IN00100213200207120020412200204122002041710002002041720020417 02002IN00100213200207220020415200204152002041810002002041820020418

using .dat SQL Data in mySQL DB

Hi, I have a .dat file.. with some data like this : 02001IN00100213200207120020412200204122002041710002002041720020417 02002IN00100213200207220020415200204152002041810002002041820020418 02003IN00100213200207320020416200204162002041910002002041920020419

my sql data base

Apologies in advance: I am a developer with mysql and active and my work involved CAPI of MYSQl,Database DeZign with Dezign and database development. Currently looking out for job opportunities in mySQl related areas.Can suggest me any exclusive websites and openings in mysql related areas. ..

My sql data base and the version

Hi, I wonder whether any of the database has support for the following situation: I created a database in mysql with the name "SAMPLE". Now whenever I change this database in any manner ie by adding one additional table or an additional column to the database table,I would like to have a version

conversion of sql data to mysql

hi I am willing to convert the data from sql to mysql but i don't what quary should i pass to do the same, can you help me out. thanking you in anticipation manish __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a