Bug? Update on 3 tables crashes in InnoDB

2003-02-17 Thread Martin Thoma
Update over 3 tables crashes in InnoDB Submitter-Id: ???? Originator: martin thoma Organization: MySQL support: [none] Severity: [serious] Priority: [medium] Category: [mysqld] Class: [sw-bug] Release:4.0.10-gamma Exectutable: [mysqld-nt] En

Datetime-functions

2001-01-14 Thread Martin Thoma
Are there some functions to compare two datetimes-fields (like if one if „greater“ the the other or a function which says, who many seconds are between two datetimes) ? Martin - Before posting, please check: http://www.mys

Big tables...

2001-01-14 Thread Martin Thoma
Hi there, sorry, I'm a newbee and I didn't found what to do in the manual. I heard in the maillinglist something about big tables. I want to make a database with about 2-3 GB. What do I have to do / set / pay attention to BEFORE I start ? Thanks in advance ! Martin ---

Index ? Key ?

2001-01-12 Thread Martin Thoma
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. Perhaps some could tell me t

Locking records

2001-01-12 Thread Martin Thoma
Hello ! I want to make something like: There is one server and seval clients, which all access the same database. The problem: If one user changes a record, no other user should be able to change it. Whats the general way to do it with MySQL ? Regards Martin