substring and a join?

2001-03-05 Thread Lauri Vain
Hello, I have the following query: "SELECT thara_plane.id,thara_plane.nam e,thara_plane.nick,thara_plane.bodytext,thara_category.category " ."FROM thara_plane,thara_category,substring(thara_plane.bodytext,225) as bodytext " ."WHERE ((thara_plane.category = thara_category.id)) " ."ORDER

Isamchk

2001-02-20 Thread Lauri Vain
Hello, Several of my tables are corrupted. I have a Win system. How can I repair my DB's with isamchk. What would I have to enter to the command line if I would like to check all DB's and all tables? The help says that I have to specify the table on the command line - it gives the error "file

Error 127

2001-02-19 Thread Lauri Vain
Hello everybody, About two hours ago I had a system crash and one of my MySQL databases was extensively used at the same time. When the system went back up, the table (the table has 37000 rows) that was used at the time of the crash started to give me the error : Got error: 1030: Got error 127