Does "repair table" work in this case?
--- "Logan, David (SST - Adelaide)"
<[EMAIL PROTECTED]> wrote:
> Hi Vicki,
>
> If you have a backup of the .MYD file, you should be
> able to copy this
> over the existing one and run myisamchk -r to
> rebuild the index.
>
> Regards
>
> David Logan
> Data
Thanks Jim. Great suggestions.
I will try both to see which one is better for my
case.
Appreciated your help.
Monet
--- Jim Grill <[EMAIL PROTECTED]> wrote:
> > Yeah. I am moving data from mysql server to sql
> > server.
> > Because I have single quote in some strings,
ed single
quote?
Thanks,
Monet
--- [EMAIL PROTECTED] wrote:
> Jim - He needs to change the format because he isn't
> exporting from one
> MySQL database to another His destination
> database doesn't like the
> escaped single quotes.
>
> Here is the manual page fo
like:
INSERT INTO week VALUES (2004-03-23
10:13:00,3015,201,2003-06-13, coach children's
league)
So, is there any way to define mysqldump output file
format?
Thanks,
Monet
__
Do you Yahoo!?
Yahoo! Mail is new and improved - Check i
to count columns not rows since I want to know how
many fields in a table.
Any advise? Thanks.
Monet
__
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list
Great explanison. I guest this is the point. after
each time the table crashed during such process, it
always followed a error message saying something about
the memory violation.
Thanks a lot. your idea also open my mind and deeper
my understanding about mysql.
Monet
--- Dathan Vance
REPAIR table. I've not figure out
the reason of the crash yet. but i think you should be
aware of it.
Monet
--- Oliver Hirschi <[EMAIL PROTECTED]> wrote:
> Hi people
>
> Due to MySQL does not support "inner-selects", I
> generate a string (I
> programm java-
s why I feel so wired. after a simple
update, all records has been erased.
does anyone have same problem before?
Thanks,
Monet
--- Rhino <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: "Monet" <[EMAIL PROTECTED]>
> To: "mysql" &l
ows how many rows was affected. Then I
did query to pull out all updated records:
select qid, qd5,q1, reviewcomments
from temp
where qid IN
(3029,3041,3053,3076,3120,3121,3128,3133,3134)
order by qid asc;
There is no records return. The table is empty.
This happened second time
Bingo. Yeah, that works very well.
Really appreciated.
BTW, still curious about the reason of duplicate.:)
Any thoughts?
Monet
--- Jim Grill <[EMAIL PROTECTED]> wrote:
> > Hello there,
> >
> > I tried "REPAIR TABLE" to recovery the crushed
> temp
&
anyone has any idea about what happened and what
should I do to delete duplicate records?
Many thanks for any advise.
Monet
--- "V. M. Brasseur" <[EMAIL PROTECTED]> wrote:
> The manual knows all:
>
> http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html
>
> Ch
or 145) showed up and my table lost everything,
no data, no columns.
I really have no any experience on this kind of
situation, please help. Many thanks and much
appreciated.
Monet
__
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other
of
ReviewComments is varchar.
Value in ReviewComments is PSRC.
After update, value in ReviewComments should be
PSRC, WHC
Can I do that by using UPDATE
SET
.
Thanks a lot.
Monet
___
Do you Yahoo!?
Win 1 of 4,000 free domain names from
2F = 1 AND (Q2G IN
> ('', 'NA'));
>
> Note that, as a bonus, doing it this way eliminates
> the need for the IFs in
> the SET clauses, because their conditions are
> guaranteed to be met by rows
> which match the WHERE clauses.
>
> Michael
>
>
Im trying to update multiple columns at once but
cannt do it in an efficient way.
What I am trying to do is:
Update table temp,
When: ( Q1A=1 AND Q1E=1 AND Q1F=1 AND Q1G IN
(,NA) ) THEN SET (Q1E=6,Q1F=5, Q1G=999),
OR When ( (Q2A=1 AND Q2E=1 AND Q2F=1 AND Q2G IN
(,NA) THEN SET (Q2E=6,Q2
15 matches
Mail list logo