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
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 tod
> 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_quer
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 ta
$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 ta
6 matches
Mail list logo