Re: [GENERAL] INSERT ON DUPLICATE KEY UPDATE

2004-06-18 Thread Eduardo Pérez Ureta
rdo > -Original Message- > From: Eduardo Pérez Ureta [mailto:[EMAIL PROTECTED] > Sent: Friday, June 18, 2004 9:38 AM > To: [EMAIL PROTECTED] > Subject: [GENERAL] INSERT ON DUPLICATE KEY UPDATE > > > How may I do a INSERT ON DUPLICATE KEY UPDATE like in mysql: > http://dev.mysq

[GENERAL] INSERT ON DUPLICATE KEY UPDATE

2004-06-18 Thread Eduardo Pérez Ureta
How may I do a INSERT ON DUPLICATE KEY UPDATE like in mysql: http://dev.mysql.com/doc/mysql/en/INSERT.html ? Eduardo ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Storing a file hash as primary key

2004-05-07 Thread Eduardo Pérez Ureta
I was wondering what the best way is to store a file hash (MD5 or SHA1) and make it primary key indexed. I have seen some people storing the hexadecimal encoded MD5 in a CHAR(32) but it may be a better idea to use a CHAR(16) without encoding the string, but that may cause some problems. What do yo