Re: Downloading MySQL
Rhino wrote: I've been away from MySQL for a few years and have not really been keeping close tabs on things, although I have kept my mysql mailing list subscription and am aware of a major player planning to purchase MySQL. Did that actually go ahead? Well... first Sun bought MySQL AB and recently Oracle bought Sun. The reason I ask is that I want to download a free copy of MySQL to use for development purposes and found that I couldn't simply download it any more the way I did several years ago. It gives you a form to complete where you have to supply all kinds of contact information and then assures you that someone will be in touch within 48 hours. What the heck is all that about? Is this some sort of "marketing offensive" where some sales guy is going to try to push me into purchasing MySQL and a service contract?? Go to www.mysql.com , select the "Downloads (GA)" tab, click on "MySQL Community Server" and select the operating system. After you've clicked on the "Download" button you will be presented with a form to login as a returning user, or register as a new user. Below that form is a link ">>No thanks, just take me to the downloads!" Pretty simple to avoid the questions. -- Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Downloading MySQL
> It gives you a form to complete... You can choose to skip all that. PB - Rhino wrote: What's the deal with downloads of MySQL? I've been away from MySQL for a few years and have not really been keeping close tabs on things, although I have kept my mysql mailing list subscription and am aware of a major player planning to purchase MySQL. Did that actually go ahead? The reason I ask is that I want to download a free copy of MySQL to use for development purposes and found that I couldn't simply download it any more the way I did several years ago. It gives you a form to complete where you have to supply all kinds of contact information and then assures you that someone will be in touch within 48 hours. What the heck is all that about? Is this some sort of "marketing offensive" where some sales guy is going to try to push me into purchasing MySQL and a service contract?? -- Rhino No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.437 / Virus Database: 271.1.1/2814 - Release Date: 04/16/10 06:31:00
Downloading MySQL
What's the deal with downloads of MySQL? I've been away from MySQL for a few years and have not really been keeping close tabs on things, although I have kept my mysql mailing list subscription and am aware of a major player planning to purchase MySQL. Did that actually go ahead? The reason I ask is that I want to download a free copy of MySQL to use for development purposes and found that I couldn't simply download it any more the way I did several years ago. It gives you a form to complete where you have to supply all kinds of contact information and then assures you that someone will be in touch within 48 hours. What the heck is all that about? Is this some sort of "marketing offensive" where some sales guy is going to try to push me into purchasing MySQL and a service contract?? -- Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: numeric types
Hi I have already tried DECIMAL type but I cannot get what I want. Maybe the simple way to get data out of MySQL and data inside MySQL the same, is to reproduce what MySQL does by default on my data out of MySQL. Check out the DECIMAL type. / Carsten Sebastien MORETTI skrev: Hello, I have a row which is defined as double unsigned (MySQL 5.0.26-Max, OpenSuse). Values in this row can go from a single digit, like 1, to values like 0.0006872207 or 1.2513e-18. I want to store exact numbers. But I would like also this: 1 stored as 1.0 0.098 stored as 0.09800 0.00707 stored as 0.00707 0.0006872207 stored as 0.0006872207 How could I get this ? MySQL stores at least double(6,5) but increases this automatically if the precision required is longer. Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)
On Fri, 16 Apr 2010 11:44:42 +0200, Jørn Dahl-Stamnes wrote: > The server does not know if the browser is closed or not (or if the > network > connection is losted). It will continue to execute the code until > finnished. Not quite true. If it decides to flush its output buffer and notices that there's no-one around to receive the output, the process may well be terminated. As long as you do not echo(), print() or flush() to a closed connection, you're probably going to be fine. / Carsten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)
http://php.net/manual/en/function.ignore-user-abort.php
/ Carsten
On Fri, 16 Apr 2010 18:39:07 +0900, Antonio PHP
wrote:
> This maybe a newbie question.
>
> Consider the following concept,
>
> ~/index.php
>
> #1. Fetch data from an external webpage using PHP Curl;
> #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take
a
> few secs
> #3. While Loop { INSERT data (from #2) into local MySQL } - this may
take
> only mili secs.
>
> Suppose this code is run by a random user (say, my website visitor), and
> he/she closes the browser while the code was running. The real problem
is
> when the browser is closed while #3 is executing. Because only portion
of
> data is inserted, ~/index.php, and it doesn't know if it needs to visit
the
> site again (i.e. repeat from #1 -> over visiting the same webpage /
> possibility of inaccurate data in local MySQL).
>
> Has anyone come across with a similar problem? Do I need to use other
> programming languages like C to execute the code from #2 in order not
> to depend upon users' browser status?
>
> Another general question : Is there a way to make sure all the data is
> INSERTED in a while loop once it's triggered?
>
> many thanks in advance,
>
> - Anton
>
>
> !DSPAM:451,4bc835a5518712071889376!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)
As a side-note: letting a random user (such as your website visitor) wait
for a couple of seconds is usually not good practice, unless you have a very
good incentive for them to do so.
2010/4/16 Jørn Dahl-Stamnes
> On Friday 16 April 2010 11:39, Antonio PHP wrote:
> > This maybe a newbie question.
> >
> > Consider the following concept,
> >
> > ~/index.php
> >
> > #1. Fetch data from an external webpage using PHP Curl;
> > #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a
> > few secs
> > #3. While Loop { INSERT data (from #2) into local MySQL } - this may take
> > only mili secs.
> >
> > Suppose this code is run by a random user (say, my website visitor), and
> > he/she closes the browser while the code was running. The real problem is
> > when the browser is closed while #3 is executing. Because only portion of
> > data is inserted, ~/index.php, and it doesn't know if it needs to visit
> the
> > site again (i.e. repeat from #1 -> over visiting the same webpage /
> > possibility of inaccurate data in local MySQL).
>
> The server does not know if the browser is closed or not (or if the network
> connection is losted). It will continue to execute the code until
> finnished.
>
> --
> Jørn Dahl-Stamnes
> homepage: http://www.dahl-stamnes.net/dahls/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=gbr...@gmail.com
>
>
Re: What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)
On Friday 16 April 2010 11:39, Antonio PHP wrote:
> This maybe a newbie question.
>
> Consider the following concept,
>
> ~/index.php
>
> #1. Fetch data from an external webpage using PHP Curl;
> #2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a
> few secs
> #3. While Loop { INSERT data (from #2) into local MySQL } - this may take
> only mili secs.
>
> Suppose this code is run by a random user (say, my website visitor), and
> he/she closes the browser while the code was running. The real problem is
> when the browser is closed while #3 is executing. Because only portion of
> data is inserted, ~/index.php, and it doesn't know if it needs to visit the
> site again (i.e. repeat from #1 -> over visiting the same webpage /
> possibility of inaccurate data in local MySQL).
The server does not know if the browser is closed or not (or if the network
connection is losted). It will continue to execute the code until finnished.
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
What if the user closes the browser while INSERT INTO MySQL? (PHP/MySQL)
This maybe a newbie question.
Consider the following concept,
~/index.php
#1. Fetch data from an external webpage using PHP Curl;
#2. Preg_match/Prepare Data to INSERT from local MySQL; - this may take a
few secs
#3. While Loop { INSERT data (from #2) into local MySQL } - this may take
only mili secs.
Suppose this code is run by a random user (say, my website visitor), and
he/she closes the browser while the code was running. The real problem is
when the browser is closed while #3 is executing. Because only portion of
data is inserted, ~/index.php, and it doesn't know if it needs to visit the
site again (i.e. repeat from #1 -> over visiting the same webpage /
possibility of inaccurate data in local MySQL).
Has anyone come across with a similar problem? Do I need to use other
programming languages like C to execute the code from #2 in order not
to depend upon users' browser status?
Another general question : Is there a way to make sure all the data is
INSERTED in a while loop once it's triggered?
many thanks in advance,
- Anton
