The following occurs when running the Live version of GnackTrack, if you
install from the LiveDVD this issue is no longer present.
LiveDVD can be downloaded from www.gnacktrack.co.uk - this can be used to
demonstrate issue but i think it's likely somethign simple
root@root:~# mysql
ERROR 2002 (HY0
I am running 3.23 and am new to mysql
I would like to do something like this:
delete t1
from t1, t2
where t1.col = t2.col
and ...
basically deleting every row in t1 that has a matching row in t2.
4.x has mechanisms to join 2 or more tables in update and delete
statements, 3.x does not. Without
We need to store numbers that exceed the precision of the DOUBLE
datatype. The mysql manual makes no mention of a size bigger than
DOUBLE. Storing the number as a string is not preferable because of the
extra space a character string would take up. One thought is to store
two integers: the digits t