Still thanks,I will remember how to avoide this if the feature!
Weitao,
On Sun, May 31, 2009 at 10:13 AM, Weitao Liu wrote:
> I had deleted some important data from my mysql server,who can tell how can
> I recover my data,I do not open the bin log,is there some other method?
If you are using InnoDB you may be able to recovery the data from the
pages if you d
Uma,
On Mon, Jun 1, 2009 at 8:41 AM, Uma Bhat wrote:
> Hi All,
>
> I have read many blogs suggesting some examples for this.
> But suggestions from you guys who have ACTUALLY worked on such a scenario
> would help me out the best.
>
>
> Current Database has:
> DEFAULT CHARACTER SET - latin1
> DEF
It's often said that NOT NULL column is preferable in terms of index
performance.
I was wondering exactly why and how this is so specifically to InnoDB.
It would be great if someone can shed light on this matter in some detail.
Kyong
--
MySQL General Mailing List
For list archives: http://lists.m
A LEFT OUTER JOIN in that query in not necessary. An inner join should be used.
-Original Message-
From: Shiv [mailto:shiv...@gmail.com]
Sent: Saturday, May 30, 2009 10:18 PM
To: bharani kumar
Cc: mysql
Subject: Re: Left join query
Hi,
Along with tables, you should also provide detail
Hi all,
I'm using MySQL 5.0 on Windows 2003.
Problem background: We use the same server for different applications.
All the applications share the same server as the database server. Each
application uses their own database. In MSSQL we put each database in
the corresponding application folder so
