Hi everyone,
I am currently working on an application where I have a very large
table called intervals ( atm its 80 000 000 records and growing ), and
a smaller table ( token ) which join with it.
interval is just an id, start, end, word
token is id, interval_id, type, processed_by
There is a ma
Why are you using special characters!? You're just asking for trouble.
Just use letters, numbers, underscores for database names, table names and
column names.
In fact, you should probably use lowercase as well.
http://www.learn-mysql-tutorial.com/Identifiers.cfm
http://dev.mysql.com/doc/refman/
> [snip]
> Is there a simple function or method to compare a value in a column to
> one or more items in a comma separated list?
> [/snip]
Take a look at SUBSTRING_INDEX and related string functions.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
hi all,
i'm trying to set ft_min_word_len to 2 in my.cnf of a debian box.
i found it does not pick up the new value but the default value 3. i
just upgraded the mysql version to 5.1.
setting the value to a higher value (12) works, tried rebuilding the
indexes and dropping and adding the fulltext
>
> That is correct. There is as far as I know no way in a MySQL trigger to
> neither to do operations on the table the trigger belongs to (obviously
> except the row that the trigger is operating on through the NEW variables)
> nor reject an insert, update, or delete.
>
thanks jesper.
~viraj
Hi All,
When I am creating a symlink with a special character in database name
it appears in mysql as somthing like this
#mysql50#dbname.
For Ex:- I have created a symlink in mysql data directory named
"User.Name" which appeared to me in mysql command line client as
"#mysql50#User.Name
Can
Hi Johan,
Some time back you have solved my problem of creating symlink as
database was fixed. But now When I am putting special characters in
symlinks like "." it is not readable as database. If I am creating
database with special characters from mysql command line I can create
it but an sy
what is the value u see when you execute
select max(b) from y;
On Thu, Feb 18, 2010 at 1:33 PM, Gavin Towey wrote:
> Reproduced in 5.1.43. Could not reproduce it in 5.0.66
>
>
> -Original Message-
> From: Yang Zhang [mailto:yanghates...@gmail.com]
> Sent: Wednesday, February 17, 2010 6: