the problem or at least eliminate that problem from this problem. Also, could
it be the backup is corrupted?
Jonathan
-Original Message-
From: walt [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 12:12 PM
To: Jonathan Patton
Cc: [EMAIL PROTECTED]
Subject: Re: table error 127
:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 10:18 AM
To: Jonathan Patton
Cc: [EMAIL PROTECTED]
Subject: Re: table error 127
On Tuesday 05 August 2003 08:58 am, Jonathan Patton wrote:
Walt,
Thanks for the suggestion. I ran myisamchk on the table and
it said it was
corrupted. So I
I have mysql setup on two computers with identical databases. When I run a group of
queries on the one computer I get back an error 127 which I checked on an it appears
to be a table corruption error. On the other computer, the queries run fine. Since I
had all the data for the table in
Jason,
For example, if you had a table named test with a column named a, which contained
one row [EMAIL PROTECTED] you would do a query like:
mysql select substring(a,1,instr(a,'@')-1) from test;
+---+
| substring(a,1,instr(a,'@')-1) |
Hi,
I have a query that runs in Microsoft Access against my mysql database just fine. It
is:
UPDATE discussion_categories AS discussion_categories_1
INNER JOIN discussion_categories ON
discussion_categories_1.parent_1_text = discussion_categories.name
SET discussion_categories_1.parent_1
discussion_categories1.`parent_1_text` = discussion_categories.name
-Original Message-
From: Jonathan Patton
Sent: Wednesday, July 23, 2003 8:39 AM
To: [EMAIL PROTECTED]
Subject: update query using inner join on same table
Hi,
I have a query that runs in Microsoft Access
I need to convert dates in the format below into mysql date format. If I try to change
the column type to date, it wipes out the data.
+-+
| 26-Jan-2001 |
| 26-Jan-2001 |
| 15-Apr-2001 |
| 1-Nov-2001 |
| 31-Oct-2001 |
| 26-Jan-2001 |
| 22-Jun-2001 |
| 23-Jul-2000 |
| 1-Nov-2001 |
|