Parham Doustdar wrote:
Hello there,
A friend called me today and was wondering what happens if the ID colomn of
an MYSQL database, set to autoinc reaches the int limit. Will it return and
begin choosing the ID's that have been deleted, or... what?
Thanks!
Ask Slashdot... I believe they hit
On Mon, Jan 25, 2010 at 17:15, Parham Doustdar parha...@gmail.com wrote:
Hello there,
A friend called me today and was wondering what happens if the ID colomn of
an MYSQL database, set to autoinc reaches the int limit. Will it return and
begin choosing the ID's that have been deleted, or...
For such a large data set, they would split into several sub tables,
otherwise the performance will be horrible
On Mon, Jan 25, 2010 at 3:39 PM, Robert Cummings rob...@interjinn.comwrote:
Parham Doustdar wrote:
Hello there,
A friend called me today and was wondering what happens if the ID
That is incorrect. What will happen is as follows:
1. The value will be incremented by 1 causing the value to be greater
than the maximum integer allowed.
2. MySQL will see this as a problem and truncate it to the closest value.
3. MySQL will then try and insert the new row with the
On Mon, Jan 25, 2010 at 18:51, Joseph Thayne webad...@thaynefam.org wrote:
That is incorrect. What will happen is as follows:
1. The value will be incremented by 1 causing the value to be greater than
the maximum integer allowed.
2. MySQL will see this as a problem and truncate it to the
Joseph Thayne wrote:
That is incorrect. What will happen is as follows:
1. The value will be incremented by 1 causing the value to be greater
than the maximum integer allowed.
2. MySQL will see this as a problem and truncate it to the closest
value.
3. MySQL will then try and insert
Shawn McKenzie wrote:
Joseph Thayne wrote:
That is incorrect. What will happen is as follows:
1. The value will be incremented by 1 causing the value to be greater
than the maximum integer allowed.
2. MySQL will see this as a problem and truncate it to the closest
value.
3. MySQL will then
On Mon, Jan 25, 2010 at 10:00 PM, Michael A. Peters mpet...@mac.com wrote:
Shawn McKenzie wrote:
Joseph Thayne wrote:
That is incorrect. What will happen is as follows:
1. The value will be incremented by 1 causing the value to be greater
than the maximum integer allowed.
2. MySQL will
Hello Ben,
I had the same question yesterday (but with SQLite) and there are at
least 2 solutions.
The first was already mentioned:
UPDATE table SET value = value + 1 WHERE foo = bar;
The second solution which also works is:
UPDATE table SET value = (SELECT value FROM table WHERE foo =
On Dec 29, 2009, at 3:10 AM, muzy p...@muzybot.de wrote:
Hello Ben,
I had the same question yesterday (but with SQLite) and there are at
least 2 solutions.
The first was already mentioned:
UPDATE table SET value = value + 1 WHERE foo = bar;
The second solution which also works is:
Ben Miller wrote:
I hope this isn't a bone-head question - Is there a MySQL query that will
increment/decrement the value in an integer column with a single query - in
other words, I don't have to run a SELECT query to get the value,
add/subtract to/from the value, and then run an UPDATE query
UPDATE SQLTABLE SET count = (count+1) WHERE PromoID=1
Is this valid for your issue? I have no way of testing or toying
On Mon, Dec 28, 2009 at 8:54 PM, Ben Miller b...@tottd.com wrote:
I hope this isn't a bone-head question - Is there a MySQL query that will
increment/decrement the value in
Ben
It seems that you can just update the column with a update query like this,
update table set field = field + 1 where some condition
This might be the thing you need.
Eric
On 12/29/09, Ben Miller b...@tottd.com wrote:
I hope this isn't a bone-head question - Is there a MySQL query
On Dec 15, 2009, at 6:03 AM, Ashley Sheridan wrote:
On Tue, 2009-12-15 at 02:53 +, Joseph Masoud wrote:
On 14 Dec 2009, at 22:01, Ashley Sheridan a...@ashleysheridan.co.uk
wrote:
On Mon, 2009-12-14 at 15:59 -0600, Philip Thompson wrote:
On Dec 14, 2009, at 12:51 AM, Lester
On Wed, Dec 16, 2009 at 3:14 PM, Philip Thompson philthath...@gmail.comwrote:
On Dec 15, 2009, at 6:03 AM, Ashley Sheridan wrote:
On Tue, 2009-12-15 at 02:53 +, Joseph Masoud wrote:
On 14 Dec 2009, at 22:01, Ashley Sheridan a...@ashleysheridan.co.uk
wrote:
On Mon, 2009-12-14 at
On Dec 16, 2009, at 1:48 PM, Yousif Masoud wrote:
On Wed, Dec 16, 2009 at 3:14 PM, Philip Thompson philthath...@gmail.com
wrote:
On Dec 15, 2009, at 6:03 AM, Ashley Sheridan wrote:
On Tue, 2009-12-15 at 02:53 +, Joseph Masoud wrote:
On 14 Dec 2009, at 22:01, Ashley Sheridan
On Tue, 2009-12-15 at 02:53 +, Joseph Masoud wrote:
On 14 Dec 2009, at 22:01, Ashley Sheridan a...@ashleysheridan.co.uk
wrote:
On Mon, 2009-12-14 at 15:59 -0600, Philip Thompson wrote:
On Dec 14, 2009, at 12:51 AM, Lester Caine wrote:
Lenin wrote:
You might also like this:
On Tue, Dec 15, 2009 at 12:03:23PM +, Ashley Sheridan wrote:
snip
I've always been led to believe that you go with MySQL if you want
speed, Oracle if you want data integrity. I know they both handle each
one admirably, but Oracle is known more for guarding the data against
mishaps and
On Dec 14, 2009, at 12:51 AM, Lester Caine wrote:
Lenin wrote:
You might also like this:
Come on Monty - Lukas Smith http://bit.ly/5lmwwD
I've been watching some of this debate with interest, but I'll stay with a
database that has none of the baggage that MySQL has always had, and IS
On Mon, 2009-12-14 at 15:59 -0600, Philip Thompson wrote:
On Dec 14, 2009, at 12:51 AM, Lester Caine wrote:
Lenin wrote:
You might also like this:
Come on Monty - Lukas Smith http://bit.ly/5lmwwD
I've been watching some of this debate with interest, but I'll stay with a
database
On 14 Dec 2009, at 22:01, Ashley Sheridan a...@ashleysheridan.co.uk
wrote:
On Mon, 2009-12-14 at 15:59 -0600, Philip Thompson wrote:
On Dec 14, 2009, at 12:51 AM, Lester Caine wrote:
Lenin wrote:
You might also like this:
Come on Monty - Lukas Smith http://bit.ly/5lmwwD
I've been
Philip Thompson wrote:
On Dec 14, 2009, at 12:51 AM, Lester Caine wrote:
Lenin wrote:
You might also like this:
Come on Monty - Lukas Smith http://bit.ly/5lmwwD
I've been watching some of this debate with interest, but I'll stay with a
database that has none of the baggage that MySQL has
rich...@rgraph.net wrote:
Hi,
You might have already seen this, however if you haven't this may interest
you:
http://monty-says.blogspot.com/2009/12/help-saving-mysql.html
Sent my appeal to comp-merger-regis...@ec.europa.eu and I would suggest
everyone on this list does the same.
The
You might also like this:
Come on Monty - Lukas Smith http://bit.ly/5lmwwD
Lenin wrote:
You might also like this:
Come on Monty - Lukas Smith http://bit.ly/5lmwwD
I've been watching some of this debate with interest, but I'll stay with a
database that has none of the baggage that MySQL has always had, and IS
currently replacing Oracle in many large sites :)
--
Allen McCabe wrote:
I have a page on my site where I can optionaly filter by certain fields
(order by filesize or file category), but I am implementing a shopping
cart type of idea where users can submit an order.
As administrators, my coworkers and I need to be able to filter orders by
On Mon, 16 Nov 2009 14:21:41 -0800, Allen McCabe wrote:
I have an order table that keeps track of the order_id, the date, the
status, etc. I also have an order_lineitem table that is the contents of the
order. This has a one-to-many structure (without foreign keys because it is
mysql).
Thanks Manuel your input is greatly appreciated.
Jerome
-Original Message-
From: Manuel Lemos [mailto:mle...@acm.org]
Sent: 01 October 2009 20:46
To: Jerome Botbol
Cc: php-general@lists.php.net
Subject: Re: PHP/MySQL Superstars
Hello,
on 10/01/2009 10:09 AM Jerome Botbol said
Hello,
on 10/01/2009 10:09 AM Jerome Botbol said the following:
Hi All,
We require a PHP / MySQL superstar to work in-house at our offices near
Edgware, London for 3 months on a ground breaking new web 2.0 project
which involves a variety of exciting new technologies. You will need at
ad...@buskirkgraphics.com wrote:
Before most of you go on a rampage of how to please read below...
As most of you already know when using MySQL from the shell you can write
your queries in html format in an out file.
Example: shellmysql -uyourmom -plovesme --html
This now will return
-Original Message-
From: Tom Worster [mailto:f...@thefsb.org]
Sent: 09 September 2009 02:29
thanks, Devendra, that's pretty much the same as my handler. (though
i can't
figure Rich Smith's $sess_save_path global. do you know what is
for?)
I think if you look at the comments on
On 9/9/09 4:16 AM, Ford, Mike m.f...@leedsmet.ac.uk wrote:
-Original Message-
From: Tom Worster [mailto:f...@thefsb.org]
Sent: 09 September 2009 02:29
thanks, Devendra, that's pretty much the same as my handler. (though
i can't
figure Rich Smith's $sess_save_path global. do you
good point, gabriel.
i really need to stop procrastinating with the whole memcache project.
perhaps i ought to postpone consideration of the session handler until i've
learned something about memcache, which i need to do anyway.
On 9/8/09 10:06 PM, Gabriel Sosa sosagabr...@gmail.com wrote:
http://www.devshed.com/c/a/PHP/Storing-PHP-Sessions-in-a-Database/
On Tue, Sep 8, 2009 at 10:53 PM, Tom Worster f...@thefsb.org wrote:
questions for those of you with a user session handler using mysql:
did you write your own handler, write one based off some other you found
(if
so,
thanks, Devendra, that's pretty much the same as my handler. (though i can't
figure Rich Smith's $sess_save_path global. do you know what is for?)
but what i'm really interested in is people's experience in switching over
to and using this kind of handler: pitfalls, gotchas, etc. or is it really
I'm our case we opt for memcache to store the sessions
Mmc its soo much faster and you will have less net overhead because
the simple protocol
Also the configuration its easier. If you see in the php manual you
only need to touch two lines in the php.ini
On 9/8/09, Tom Worster f...@thefsb.org
At 12:47 AM +0200 8/10/09, Ralph Deffke wrote:
I would like to have a KNOWN status of my database after a NEW installation
of the application, because the further installation relais on information
stored in record 1 of each table.
Sounds like a problem waiting to happen.
Cheers,
tedd
--
ALTER TABLE T1 AUTO_INCREMENT=1;
It's likely that you dropped every record and expected the auto_increment to
reset.
Jerry Wilborn
jerrywilb...@gmail.com
On Sun, Aug 9, 2009 at 1:17 PM, Ralph Deffke ralph_def...@yahoo.de wrote:
Hi all,
I'm facing the fact that it seems that auto_increment
no this is not the point ! if I do this, the next auto_increment is still
10720
i can do what I want however the is defined long unsigned unique
auto_increment, what happens is in t1 the value is set to 10720 in t2 the
next value ist set to 10721 while the next record in t1 gets 10721.
it seems
no this is not the point ! if I do this, the next auto_increment is still
10720
i can do what I want however the field is defined long unsigned unique
auto_increment, what happens is in t1 the value is set to 10720 in t2 the
next value ist set to 10721 while the next record in t1 gets 10722.
At 8:17 PM +0200 8/9/09, Ralph Deffke wrote:
Hi all,
I'm facing the fact that it seems that auto_increment fields in a table not
start at 1 like it was in earlier versions even if I install mySQL brand new
creating all tables new. it seems to me that auto_increments handling has
changed to
I would like to have a KNOWN status of my database after a NEW installation
of the application, because the further installation relais on information
stored in record 1 of each table.
tedd tedd.sperl...@gmail.com wrote in message
news:p06240801c6a4fe331...@[192.168.1.100]...
At 8:17 PM +0200
Things I have used prepared statements for:
1. SELECT
2. UPDATE
3. INSERT
4. DELETE
5. Stored procedures
Things I am aware of that prepared statements are not capable of doing:
What have you read that prepared statements can't do? I've not heard
of anything, nor have I encountered anything,
On Tue, Jul 14, 2009 at 2:29 AM, Tom Chubbtomch...@gmail.com wrote:
Hi List,
Just wanted to pick your brains please?
I'm trying to standardise on the way I query databases and move away from
the Dreamweaver built-in functions (which I know you all hate!) ;)
I've been on this list for about 5
On Tue, 2009-07-14 at 01:52 -0400, Andrew Ballard wrote:
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyanhdede...@videotron.ca wrote:
for the phone #'s, I'm using int as the data type storing each part of the
phone # in its own cell,
When it gets displayed, I add a dash in between each part
2009/7/14 Eddie Drapkin oorza...@gmail.com
On Tue, Jul 14, 2009 at 2:29 AM, Tom Chubbtomch...@gmail.com wrote:
Hi List,
Just wanted to pick your brains please?
I'm trying to standardise on the way I query databases and move away from
the Dreamweaver built-in functions (which I know you
Eddie Drapkin wrote:
Things I have used prepared statements for:
1. SELECT
2. UPDATE
3. INSERT
4. DELETE
5. Stored procedures
Things I am aware of that prepared statements are not capable of doing:
What have you read that prepared statements can't do? I've not heard
of anything, nor have I
2009/7/14 Tom Chubb tomch...@gmail.com
2009/7/14 Eddie Drapkin oorza...@gmail.com
On Tue, Jul 14, 2009 at 2:29 AM, Tom Chubbtomch...@gmail.com wrote:
Hi List,
Just wanted to pick your brains please?
I'm trying to standardise on the way I query databases and move away
from
the
On July 12, 2009 03:34:49 pm Haig Dedeyan wrote:
On Sat, 11 Jul 2009 21:26:36 -0400, Haig Dedeyan wrote:
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan hdede...@videotron.ca
wrote:
mysql_query(INSERT INTO phonedir
(fname, lname) VALUES('$new_fname','$new_lname'))
or die(mysql_error());
On July 12, 2009 08:52:56 am Haig Dedeyan wrote:
At 6:39 PM -0400 7/11/09, Haig Dedeyan wrote:
[1]
mysql_query(INSERT INTO phonedir
(fname, lname) VALUES('$new_fname','$new_lname'))
or die(mysql_error());
or
[2]
mysql_query(INSERT INTO phonedir
(fname, lname)
At 8:50 PM +0530 7/12/09, Zareef Ahmed wrote:
On Sun, Jul 12, 2009 at 8:42 PM, tedd
mailto:tedd.sperl...@gmail.comtedd.sperl...@gmail.com wrote:
As with all communication, it's better to be clear than obtuse.
Agree, but I believe obtuse word meaning is contextual and depends :)
The word
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for prepared statements, I'm no authority on them, but from what
I've read they are not going to be something I'll be practicing
anytime soon.
Aside from Stuart's comments about
On Monday 13 July 2009 14:31:09 tedd wrote:
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for prepared statements, I'm no authority on them, but from what
I've read they are not going to be something I'll be practicing
On July 13, 2009 09:48:54 am Haig Dedeyan wrote:
On Monday 13 July 2009 14:31:09 tedd wrote:
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for prepared statements, I'm no authority on them, but from what
I've read
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyanhdede...@videotron.ca wrote:
On July 13, 2009 09:48:54 am Haig Dedeyan wrote:
On Monday 13 July 2009 14:31:09 tedd wrote:
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for
On Mon, 2009-07-13 at 16:30 -0400, Bastien Koert wrote:
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyanhdede...@videotron.ca wrote:
On July 13, 2009 09:48:54 am Haig Dedeyan wrote:
On Monday 13 July 2009 14:31:09 tedd wrote:
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12,
On Mon, Jul 13, 2009 at 5:52 PM, Ashley
Sheridana...@ashleysheridan.co.uk wrote:
On Mon, 2009-07-13 at 16:30 -0400, Bastien Koert wrote:
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyanhdede...@videotron.ca wrote:
On July 13, 2009 09:48:54 am Haig Dedeyan wrote:
On Monday 13 July 2009 14:31:09
tedd wrote:
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for prepared statements, I'm no authority on them, but from what
I've read they are not going to be something I'll be practicing
anytime soon.
Aside from Stuart's
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyanhdede...@videotron.ca wrote:
for the phone #'s, I'm using int as the data type storing each part of the
phone # in its own cell,
When it gets displayed, I add a dash in between each part of the phone #'s
(country code-area code-1st set of
2009/7/12 Haig Dedeyan hdede...@videotron.ca
On July 11, 2009 08:21:34 pm Haig Dedeyan wrote:
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan hdede...@videotron.ca
wrote:
On July 11, 2009 10:57:14 am Haig Dedeyan wrote:
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
At 6:39 PM -0400 7/11/09, Haig Dedeyan wrote:
[1]
mysql_query(INSERT INTO phonedir
(fname, lname) VALUES('$new_fname','$new_lname'))
or die(mysql_error());
or
[2]
mysql_query(INSERT INTO phonedir
(fname, lname)
Hi gang:
I am top posting only to show that the following post makes no sense
as to who said what.
At what point here Zareef, did you think you were helping anyone? Or
is this more of your I'm going to do whatever I want attitude?
I would hate to review code with such lack of forethought
At 9:26 PM -0400 7/11/09, Haig Dedeyan wrote:
@Tedd - I will be looking into prepared statements eventually but I
still want to understand escaping.
Haig:
I'm not the one pushing the prepared statements, that's someone else.
However, I can see how you might think that considering how
On Sun, Jul 12, 2009 at 6:32 PM, tedd tedd.sperl...@gmail.com wrote:
Hi gang:
I am top posting only to show that the following post makes no sense as to
who said what.
At what point here Zareef, did you think you were helping anyone? Or is
this more of your I'm going to do whatever I want
At 8:24 PM +0530 7/12/09, Zareef Ahmed wrote:
On Sun, Jul 12, 2009 at 6:32 PM, tedd
mailto:tedd.sperl...@gmail.comtedd.sperl...@gmail.com wrote:
Hi gang:
I am top posting only to show that the following post makes no sense
as to who said what.
At what point here Zareef, did you think you
On Sun, Jul 12, 2009 at 8:42 PM, tedd tedd.sperl...@gmail.com wrote:
At 8:24 PM +0530 7/12/09, Zareef Ahmed wrote:
On Sun, Jul 12, 2009 at 6:32 PM, tedd mailto:tedd.sperl...@gmail.com
tedd.sperl...@gmail.com wrote:
Hi gang:
I am top posting only to show that the following post makes no
On Sat, 11 Jul 2009 21:26:36 -0400, Haig Dedeyan wrote:
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan hdede...@videotron.ca wrote:
mysql_query(INSERT INTO phonedir
(fname, lname) VALUES('$new_fname','$new_lname'))
or die(mysql_error());
I won;t be using 2x escapes but I just need to know
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for prepared statements, I'm no authority on them, but from what
I've read they are not going to be something I'll be practicing
anytime soon.
Aside from Stuart's comments about slowness, what else have you read
that makes you
On Jul 10, 2009, at 10:12 PM, Haig Dedeyan hdede...@videotron.ca
wrote:
Hi everyone,
I'm starting to experiment with an edit form and I am seeing the
following
behaviour:
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE id=$id;
$result = mysql_query($sql);
echo mysql_error() . \n;
This will result in the
On July 11, 2009 10:57:14 am Haig Dedeyan wrote:
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE
id=$id; $result =
On Sat, Jul 11, 2009 at 6:39 PM, Haig Dedeyanhdede...@videotron.ca wrote:
On July 11, 2009 10:57:14 am Haig Dedeyan wrote:
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir SET
2009/7/12 Eddie Drapkin oorza...@gmail.com:
No offense or anything, but all of this work you've done is
immediately mode obsolete the second you switch to prepared
statements. They're easier to use and more secure, as well as making
code more readable. I don't understand why it's so hard for
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan hdede...@videotron.ca wrote:
On July 11, 2009 10:57:14 am Haig Dedeyan wrote:
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE
On July 11, 2009 08:21:34 pm Haig Dedeyan wrote:
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan hdede...@videotron.ca wrote:
On July 11, 2009 10:57:14 am Haig Dedeyan wrote:
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
$fname = mysql_real_escape_string($fname);
$lname =
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at mysql-subscr...@lists.mysql.com to follow the thread for responses.
If
On Fri, Jul 10, 2009 at 12:36 PM, Daniel Browndanbr...@php.net wrote:
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at
hi andrew i think you understand my problem a little,
but if 100 user load this query at the same time, the two mysql server
had a lot to do!
so i think to cache this query as xml to the application server local
make thinks faster,
but, i would like to have the same performance to read this xml
On Fri, Jul 10, 2009 at 12:59, Andrew Ballardaball...@gmail.com wrote:
I understood the question to be how to improve performance by caching
MySQL results into an XML document (which, given that it was posted
here) within a PHP script. Perhaps this is not the correct
interpretation, but if so
On Fri, Jul 10, 2009 at 13:07,
workerho...@studysite.euworkerho...@studysite.eu wrote:
hi andrew i think you understand my problem a little,
but if 100 user load this query at the same time, the two mysql server had a
lot to do!
so i think to cache this query as xml to the application server
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server and
store just this table
and read the query from them, it could solve my problem litte, i hope so!
Daniel Brown schrieb:
On Fri, Jul 10, 2009 at 13:07,
On Fri, Jul 10, 2009 at 13:23,
workerho...@studysite.euworkerho...@studysite.eu wrote:
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server and store
just this table
and read the query from them, it could solve my
On Fri, Jul 10, 2009 at 1:23 PM,
workerho...@studysite.euworkerho...@studysite.eu wrote:
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server and store
just this table
and read the query from them, it could solve my
yes i think i should do this
Daniel Brown schrieb:
On Fri, Jul 10, 2009 at 13:23,
workerho...@studysite.euworkerho...@studysite.eu wrote:
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server and store
just this
On Fri, 10 Jul 2009 13:29:31 -0400
Bastien Koert phps...@gmail.com wrote:
On Fri, Jul 10, 2009 at 1:23 PM,
workerho...@studysite.euworkerho...@studysite.eu wrote:
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server
workerho...@studysite.eu wrote:
hi andrew i think you understand my problem a little,
but if 100 user load this query at the same time, the two mysql server
had a lot to do!
so i think to cache this query as xml to the application server local
make thinks faster,
but, i would like to have the
first thanks to all who have read ;-)
your solution looks like the method how i done it actually,
i have tested the last hours the solution with sql lite on application
server
the Solution:
3 Mysql Server ( 1 more to handle the big load ) (1 Master, 2 Slaves)
mysql replication
10
On Jul 10, 2009, at 5:25 PM, workerho...@studysite.eu workerho...@studysite.eu
wrote:
first thanks to all who have read ;-)
your solution looks like the method how i done it actually,
i have tested the last hours the solution with sql lite on
application server
the Solution:
3
Haig Dedeyan wrote:
Hi everyone,
I'm starting to experiment with an edit form and I am seeing the following
behaviour:
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE id=$id;
$result =
On July 10, 2009 11:26:04 pm Haig Dedeyan wrote:
Haig Dedeyan wrote:
Hi everyone,
I'm starting to experiment with an edit form and I am seeing the
following behaviour:
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir
On Tuesday 02 June 2009 11:36:28 pm optoma...@rogers.com wrote:
Everybody has given Angus really great advice in this previous thread
and I have learned a lot too. I hope no one mines the fork but I am in
the exact same situation as Angus. If anyone could spare a bit of time
regarding
From: Sancar Saran
And if you so much thinking about future DB change. Just wrote
compatible sql
and use multi drive layer (phpADO db).
And you are problem free
I have some questions about this suggestion. We currently have
production systems using Postgres, Sybase ASA, Oracle and MS SQL
Sadly, Mr. Saran wasted a lot of time writing a pluggable backend db layer,
as one is built into PHP now, PDO: http://us2.php.net/pdo
Sybase / MsSQL: http://www.php.net/manual/en/ref.pdo-dblib.php
Postgres: http://us2.php.net/manual/en/ref.pdo-pgsql.php
Oracle:
On Tue, Jun 02, 2009 at 04:36:28PM -0400, optoma...@rogers.com wrote:
Everybody has given Angus really great advice in this previous thread
and I have learned a lot too. I hope no one mines the fork but I am in
the exact same situation as Angus. If anyone could spare a bit of time
regarding
High-performance builds of mysql are still faster. And with 5.4 integrating
a lot of performance boosts, I'd expect MySQL to retain that lead for a lot
longer. There's also a lot more guides / support for MySQL around, as well
as having a more robust choosing of UDF's, if you were to need them.
2009/5/21 Leidago !Noabeb leid...@googlemail.com
Hi All
I know this is not strictly a PHP question, but i have a problem whenever i
insert a record using PHP. Basically the auto increment field does not work
at all. Here's the structure of the table that i'm using:
CREATE TABLE `children`
Leidago !Noabeb wrote:
Hi All
I know this is not strictly a PHP question, but i have a problem
whenever i insert a record using PHP. Basically the auto increment
field does not work at all. Here's the structure of the table that i'm
using:
CREATE TABLE `children` (
`cid` int(4) NOT
Bogdan Stancescu wrote:
On 24-Apr-09 03:45, Chris wrote:
I don't think mysql has any way of finding that out. If you're using an
abstraction layer, it's easy enough in code - though rollback's are a
little harder - should they do a complete rollback or just to a savepoint?
Thank you for
Bogdan Stancescu wrote:
Hello list,
I'm developing a library and would need to know if the code calling my
library has already started a MySQL transaction or not. I want to know
whether I should start one or use savepoints instead -- starting a
transaction if one is already in progress commits
Jan G.B. wrote:
2009/4/21 Per Jessen p...@computer.org:
Jan G.B. wrote:
A web application that uses an external db server would be quite ...
uhm... slow! Anyone did this, yet? ;)
Certainly, and it's not slow. It depends entirely on your connection
to the public internet.
As we're
101 - 200 of 1710 matches
Mail list logo