RE: Running SQL Scripts

2002-01-22 Thread Achim, Caterina
Hi J, I think you shoud type of command prompt: mysql database < file.sql and this will create the database Cheers, Caterina -Original Message- From: Jarlath . Hennelly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 2:19 PM To: MySQL (E-mail) Subject: Running SQL Scripts

RE: How can I delete from table element exist in other one

2002-01-22 Thread Achim, Caterina
Hi, I think is better to make a join between the tables: delete from news inner join news2 on news.* = news2.* Hope it helps, Caterina -Original Message- From: Sofiane Sakhri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:00 PM To: [EMAIL PROTECTED] Subject: How can I dele

RE: mysql: ft_min_wod_length

2002-01-21 Thread Achim, Caterina
, Caterina; [EMAIL PROTECTED] Subject: RE: mysql: ft_min_wod_length But that variable isn't there in the first place :-) Should I just add it then? (under the [mysqld] section?) > -Original Message- > From: Achim, Caterina [mailto:[EMAIL PROTECTED]] > Sent: maandag 21 januari 2

RE: How to get BDB or InnoDB

2002-01-21 Thread Achim, Caterina
Hi Erv, Hi Erv, You can check www.innodb.com. Caterina -Original Message- From: Erv Young [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 4:44 PM To: [EMAIL PROTECTED] Subject: How to get BDB or InnoDB In the manual at http://www.mysql.com/doc/N/e/News-3.23.x.html, immedia

RE: mysql: ft_min_wod_length

2002-01-21 Thread Achim, Caterina
I think it would be better to copy all the content and uncomment the variable you need. -Original Message- From: Frederic Hecq [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 4:42 PM To: Achim, Caterina; [EMAIL PROTECTED] Subject: RE: mysql: ft_min_wod_length One more

FW: mysql: ft_min_wod_length

2002-01-21 Thread Achim, Caterina
I forgot to cc the lists... -Original Message- From: Achim, Caterina Sent: Monday, January 21, 2002 4:21 PM To: 'Frederic Hecq' Subject: RE: mysql: ft_min_wod_length As far as I know, mysql will look for this file first in /etc and then in /usr/local/mysql/var (or wher

RE: mysql: ft_min_wod_length

2002-01-21 Thread Achim, Caterina
Frederic, you should have 3 files (my-small.cnf, my-medium.cnf, my-large.cnf) - depends what OS you use. You can copy one of this files and uncomment there what configuration you'd like to have. Caterina -Original Message- From: Frederic Hecq [mailto:[EMAIL PROTECTED]] Sent: Monday, Jan

RE: Porting from MS SQL to MySQL

2002-01-18 Thread Achim, Caterina
I can't say that I am a database specialist, but I still think that there will be some problems porting a MSSQL to mysql, and this because it seems that MSSQL is very linked to the operating systems it runs on, i.e. Windows (only think to the security for MSSQL). -Original Message- From:

RE: find double

2002-01-18 Thread Achim, Caterina
you should make a self-join to find the duplicates in one table. -Original Message- From: Jean Fabrice Leoni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 2:00 PM To: [EMAIL PROTECTED] Subject: find double hi, i have a mysql table with 10 millions rows. Response time is pe

Question innodb

2002-01-14 Thread Achim, Caterina
Hi, I have a question about setting up the innodb part of mysql server. I run mysql version 8.21, distribution 3.23.40 for pc-linux-gnu on i686 (installed the binary distribution). I tried to turn on innodb, so I stopped the server, copied my-medium.cnf under /etc/my.cnf, uncomment the lines c