Rplication & charactersets bug?

2002-01-28 Thread Lyubomir Simich
Hi I have a two servers: 1. MSATER mySQL 3.23.47 under Windows 2000 character_set: koi8_ru character_sets: latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungar

SUB-SELECT

2001-11-15 Thread Lyubomir Simich
Hello Can I make a query in mySQL like this? DELETE FROM table1 WHERE id NOT EXIST IN (SELECT id FROM table2) -- WBR Lyubomir mailto:[EMAIL PROTECTED] - Before posting, please check:

Re: Fwd: Re: FULLTEXT exact match queries?

2001-10-01 Thread Lyubomir Simich
Hello Nate, Monday, 24 September, 2001, 19:56:47, you wrote: NF> I built my database and then used the command: NF> ALTER TABLE disc ADD FULLTEXT (title,recentdata,specialsound,uniqueid) NF> But if I try to search with this command: NF> SELECT title, recentdata, specialsound,uniqueid FROM disc W

need query

2001-09-18 Thread Lyubomir Simich
Hello, May I use a query like this? DELETE FROM b WHERE id NOT IN (SELECT id FROM a) What can I do for make it? -- Best regards, Lyubomir mailto:[EMAIL PROTECTED] - Before posting, please check: