.
--
Grzegorz Paszka
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
table, mysqldump and insert it again, but
problem still exists.
I read that such error occurs when I insert no unique value to column with unique
property.
But as you can see I haven't UNIQUE key anywhere.
I need help becouse I don't know what to do.
Regards.
--
Grzegorz Paszka
--
MySQL
Hi.
I wonder if optimize table results are equal to dump such table and insert it back ?
Regards.
--
Grzegorz Paszka
sql,mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, Feb 27, 2003 at 09:27:41AM -0500, Brent Baisley wrote:
Maybe you should rethink your whole database structure. In your
simplified example, you really only have two pieces of data, the text
and a qualifier (a, b, c, d, e, ...). So instead of separating your
text into different
Hi.
I know that for fulltext index are some limitations as:
All parameters to the MATCH() function must be columns from the same table that
is part of the same FULLTEXT index, unless the MATCH() is IN BOOLEAN MODE.
But A boolean full-text search can also work even without a FULLTEXT index,
On Tue, Nov 26, 2002 at 02:30:41PM +0100, Sergei Golubchik wrote:
On Nov 25, Grzegorz Paszka wrote:
Hi.
Could You explain me for what is macro misc_word_char ?
A word must have true_word_char on both ends,
and there should not be two adjacent misc_word_char's
in the word.
E.g
Hi.
I've such problem.
Is ORDER BY works with MATCH AGAINST ?
i.e.
create table test (
id_test int11,
message text
);
SELECT id_test, message FROM test WHERE WHERE MATCH (message) AGAINST
('example' IN BOOLEAN MODE) ORDER BY id_test
For me in mysql 4.0.3beta this select doesn't work as I want.
I've compiled mysql 4.0.2-alpha from source.
I've created table:
create table test (
id_test int4,
body text);
Next:
create fulltext index test_body on test (body);
insert into test (id_test,body) values (1,'test rpm');
insert into test (id_test,body) values (2,'test rpm');
insert into test
On Mon, Nov 12, 2001 at 07:21:07PM +0200, Sinisa Milivojevic wrote:
Grzegorz Paszka writes:
Yes, I say more, that I created new database and filled it by perl script from
data source and I have the same situation. I think that is the best way of rebuild
index file :)
See in our manual
On Mon, Nov 12, 2001 at 03:22:31PM +0200, Sinisa Milivojevic wrote:
Grzegorz Paszka writes:
Hi.
I've problem with mysql.
I had i386 RH71 (kernel 2.4.13, 1.5GB RAM, single procesor) with mysql 3.23.36
(now I have 3.23.41 and problem still exists).
I run myisamchk on table
10 matches
Mail list logo