Hi Anand,Please find below my configuration
file of both the masters:ON MASTER 1:[mysqld]datadir=/var/lib/mysql/socket=/var/lib/mysql/mysql.sockold_passwords=1log-bin=/usr/local/mysql/bin.log#binlog-do-db= # input the database which should be
replicatedbinlog-ignore-db=mysql
# input
Dear all,
I have a problem in migrating a GUI app(displays multi lingual data like
Arabic) which currently uses oracle as backend db to mysql (5.1). Currenly in
oracle I am using NVARCHAR datatype to store the Arabic chars. How do I
incorporate the same functionality in mysql ? I have tried a s
thanks for reply, problem fixed,
On Mon, Jan 18, 2010 at 6:06 AM, Dan Nelson wrote:
> In the last episode (Jan 17), bharani kumar said:
> > SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE
> > cCurstatus!='completed' AND cMmrcashworker = '2' AND
> > (cHospital = '1234'
In the last episode (Jan 17), bharani kumar said:
> SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE
> cCurstatus!='completed' AND cMmrcashworker = '2' AND
> (cHospital = '1234' OR cHospital1 = '1234' OR cHospital2 ='1234') AND
> updateDate between '2010-01-01' and '2010-01-
Ted, all,
Ted Yu wrote:
> Hi,
> We currently use SQL statements embedded in Java code. I believe stored
> procedures would give us better performance.
In general, this is likely, because you would (at least) save on the
number of statements and the amount of data communicated between your
applic
SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE
cCurstatus!='completed' AND cMmrcashworker = '2' AND
(cHospital = '1234' OR cHospital1 = '1234' OR cHospital2 ='1234') AND
updateDate between '2010-01-01' and '2010-01-28' order by id desc
I have one patient entry,and his up