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
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
, 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
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
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
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
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
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:
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
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
10 matches
Mail list logo