Stefan,
On Sun, Mar 8, 2009 at 1:50 PM, Stefan Onken wrote:
> Hello,
>
> I am bit puzzled about combining mysql fulltext search into our
> current search:
>
> I am not able to combine a fulltext search with other selections,
> please see http://pastebin.com/m23622c39 for full details. The
> momen
On Sun, Mar 8, 2009 at 3:31 PM, Steve Edberg wrote:
> If you want to keep the enum column, you can set the strict SQL mode:
>
> mysql> show variables like 'SQL_MODE';
> +---+---+
> | Variable_name | Value |
> +---+---+
> | sql_mode | |
> +---
If you want to keep the enum column, you can set the strict SQL mode:
mysql> show variables like 'SQL_MODE';
+---+---+
| Variable_name | Value |
+---+---+
| sql_mode | |
+---+---+
1 row in set (0.00 sec)
mysql> create table test2 (test e
Hello,
I wanted to know how mysql behaves when accessing to its tables.
I have check the file descriptors and I could see different MYI and MYD
opened.
mysqld 17638 mysql 125u REG8,4124928
83197 /usr/var/lib/mysql/xx.MYI
mysqld 17638 mysql 126u REG8,4 1186784
83
Hello,
I am bit puzzled about combining mysql fulltext search into our
current search:
I am not able to combine a fulltext search with other selections,
please see http://pastebin.com/m23622c39 for full details. The
moment I am using "...where a=2 OR match (bla) AGAINST ('foo') mysql
is not u