Would this work for you?
SELECT msgdata
FROM sent_sms
WHERE momt = 'MT'
AND binfo IN (SELECT
binfo
FROM sent_sms
WHERE momt = 'DLR')
David
On 5/21/08 10:30 PM, "sangprabv" <[EMAIL PROTECTED]> wrote:
> Hi,
> I tried to look for records from a table with this query:
Hello all,
I think I saw this on an earlier post but I can't find it now.
What I need to do:
1 - update data nightly into Dev Server
2 - only copy Data do not overwrite structure
3 - only update specific tables
Any advice is greatly appreciated.
David
--
MySQL General Mailing List
For list a
ull path, i.e.
> c:\Program Files\...\mysql\bin to the variable.
>
> -----Original Message-
> From: David Lazo [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 25, 2006 2:54 PM
> To: mysql@lists.mysql.com
> Subject: Installing MySQL on Windows Server 2003 Standard x64 Edition
c:\windows\system32
> or the similar folder of your system?
>
> "David Lazo" <[EMAIL PROTECTED]> escreveu na mensagem
> news:[EMAIL PROTECTED]
>> I'm having problems with MySQLInstanceConfig.exe - Unable To Locate
>> Component
>>
>> This app
I'm having problems with MySQLInstanceConfig.exe - Unable To Locate
Component
This application has failed to start because LIBMYSQL.dll was not found.
Re-installing the application may fix this problem
I have tried to re-install, but I get the same message.
I read the following related thread
Thanx again.
For the time being, we will keep 4 drives with Dan's suggestion. OS and
MySQL running from there.
On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PROTECTED]> wrote:
> James, with just 4 drives, you can set up one big RAID 10 disk
> (usually called a "logical disk", with Dell PERCs I
d in choosing abnd setting up your hardware.
>
> (Third time today I've plugged that book - I don't own stock or
> anything, really)
>
> Dan
>
>
> On 8/22/06, JamesDR <[EMAIL PROTECTED]> wrote:
>> David Lazo wrote:
>>> We want to get:
>>
We want to get:
Windows Server 2003 R2, Standard x64 Edition
2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB
8GB 533MHz (8x1GB), Dual Ranked DIMMs
3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives
What would be the recommended RAID configuration settings for a dedicated
MySQL db runnin