representing a sequence of events in a database

events. How do I calculate the 'correct', normalizable sequenceID. One way would be a string concatenation of the event keys. to define as the primary key. Any hints Thanks Alex -- Dr. rer. nat. Alexander Hannemann (Diplom-Chemiker) MPI f. Festkörperforschung Stuttgart Heisenbergst

MEM_ROOT mysql.h

Hi, I am trying to learn the MySQL C-Api and use PDuBois book. Trying to compile the simple 'client1.h' code leads to an error once the include 'mysql.h' statement' is reached: SUSE Linux 8.2 Error message: Intel Compiler 7.0 /usr/include/mysql/mysql.h(127): error: identifier "MEM_ROOT" is undefine

Hidden data after select

Thanks for the help Typing errors occured Sorry for the inconvenience A.Hannemann - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

Hiding data after select

Hi there, suppose I have table table1 with columns col1,col2,col3,col4 I would like to set up a query that omits eg. col1 from the output even though col1 must satisfy some condition: SELECT col2,col3,col4 from table where col1=condition Any suggestions ? Thanks in advance A.Hannemann -