MySQL when running on LiveDVD (GnackTrack - ubuntu based distro) - Error 2002

2011-02-28 Thread Matthew Phillips
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

is there a floating point type bigger than double?

2003-01-20 Thread Matthew Phillips
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

joins in update/delete

2003-01-16 Thread Matthew Phillips
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