Install/compile problems

/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr0/src/mysql-4.0.15a' make: *** [all] Error 2 Dermot Paikkos [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 Fax: 0207 286 8668 -- MySQL General Mailing Li

date_add function

current_date or feed the values from one (or 2) fields. Ideally I just want the return the time +7 hours. What would also help out is if someone can explain if there is a general rule for using literal strings and column values? Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Admi

SUMMARY how to retrieve data from two tables?

ork with but once I add "AND t.date = (current_date) I get 0 records returned and I need the users.id an users.surname. Can anyone think of a way round this? ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library P

how to retrieve data from two table?

once I add "AND t.date = (current_date) I get 0 records returned and I need the users.id an users.surname. Can anyone think of a way round this? Thanx. Dp. sql,mysql,query. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286

SUMMARY: how to update time field with current time?

Thanx to all those how answered: hcir walt William Mussatto David Yahoo The answer was now() or update tab_name set fd_name = (now()) where_expr; I had tried this but was missing a pair of brackets (honest..) MYSQL dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo

how to update time field with current time?

Hi Probably a silly question but how can I set a time field to the current time with update in mysql? I have 4 time fields per record. Should I have used set them up as timestamp? Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432