Hello.
No, you can't. But you can make some workarounds. For example
you may use triggers in 5.0.2 version (but it is still not
production ready) or use a separate field for storing the
value of the week.
Hany Nagaty [EMAIL PROTECTED] wrote:
Hi all,
I'm a bit new to MySQL, it's
Hi all,
I'm a bit new to MySQL, it's my first email to the list.
Well, my question is: Can I have a key on a function of the column.
I have some table with a date column in it. I wish to have a key on
yearweek(datecolumn). I don't want to allow having duplicate weeks in
the table.
Thanks for
Hi,
Thanks to the reply from Sergei, I understand why
MySQL requires SAME block size on all indexes when
load index into cache
However, this feature basically useless for the table
that has any fulltext index. Based on what I've seen,
fulltext indexes use 2048 block size, whereas others
use
Martin Thoma wrote:
Hello !
I'm a database-newbee. What I need is a column that makes the record
unique. The content should be generated autoamtically and it should be
able to get a lot of records (BIGINT would be nice). But I don't know if
I should use PRIMERY KEY, KEY, INDEX or UNIQUE.