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 gto...@ffn.com 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
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
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
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
It
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
[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:
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
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