mysql checksum

Post

Posted
Rating:
#1 (In Topic #471)
bill-lancaster
Regular
bill-lancaster is in the usergroup ‘Regular’
I want to check if a record has changed in a myslq database.  I'm interested only in changes made while the record is displayed.
I can do:

Code

hResult = hConn.Exec("CHECKSUM TABLE test")
but hResult!checksum is null.
Any advice would be welcome
Online now: No Back to the top

Post

Posted
Rating:
#2
Matthew-Collins
Trainee
Hi Bill,

I got checksum table working in gambas, see below:

Code (gambas)

  1. Public Sub Button1_Click()
  2.  
  3.   Dim hConn As Connection = Connections["Connection1"]
  4.   hConn.Open
  5.  
  6.   Dim hresult As Result = hconn.Exec("CHECKSUM TABLE test")
  7.   Print hresult!Checksum
  8.  

Note case sensitive i.e …!Checksum

Also try in terminal:
sudo mysql
connect myDatabase
CHECKSUM TABLE test
+———-+———–+
| Table    | Checksum  |
+———-+———–+
| myDatabase.test | 736424448 |
+———-+———–+
1 row in set (0.00 sec)
 Cheers
Matt
Online now: No Back to the top

Post

Posted
Rating:
#3
bill-lancaster
Regular
bill-lancaster is in the usergroup ‘Regular’
 Thanks a lot Mathew, I'd misspelt the table name!
All is fine,
Thanks again
Online now: No Back to the top
1 guest and 0 members have just viewed this.