Brian Dunning wrote:
I definitely misunderstood what you guys are saying about the length.
That's clearly a problem for a lot of my values.
I can switch them both to bigint. One table has 34,000,000 records and
it's OK if this is hung up for a few minutes but not much longer than
that - any
Brian Dunning wrote:
I'm running the following code:
$query3 = DELETE FROM table1 WHERE referer=$referer ORDER BY creation
LIMIT $numtodelete;
$result3 = mysql_query($query3);
$string = $total found, $n kept, $numtodelete extras removed ($query3);
$x = mysql_query(insert into table2
$referer is always an integer, 6 to 10 digits long.
To clarify: the value of $referer is changing between line 1, where
$query3 is being set, and line 4, where it's being written into my
debugging log table2.
I can't see any way that $referer could be different in those two
places.
On
Brian Dunning wrote:
I'm running the following code:
$query3 = DELETE FROM table1 WHERE referer=$referer ORDER BY creation
LIMIT $numtodelete;
$result3 = mysql_query($query3);
$string = $total found, $n kept, $numtodelete extras removed ($query3);
$x = mysql_query(insert into table2
Brian Dunning wrote:
I'm running the following code:
$query3 = DELETE FROM table1 WHERE referer=$referer ORDER BY creation
LIMIT $numtodelete;
$result3 = mysql_query($query3);
$string = $total found, $n kept, $numtodelete extras removed ($query3);
$x = mysql_query(insert into
Richard Davey wrote:
What data type do the referer / friend_id columns have in MySQL? int?
tinyint? etc
Ahh of course. That'll be it. The different tables will have different
definitions of the friend_id field and one will be overflowing!
Well spotted Richard wood for the trees for me
6 matches
Mail list logo
