RE: Does anyone know how mysql works for mutiple kernels of a cpu.

Hi Moon's Father, I thought you meant how mysql works for multiple processors of a cpu. If so, have a look at 'http://www.google.com/search?q=mysql+for+multiple+processors' Regards, Amit Sharma [EMAIL PROTECTED] Amit Sharma E: [EMAIL PROTECTED] M: +91 9971 490 700 W: www.affle.co.uk > -Ori

Does anyone know how mysql works for mutiple kernels of a cpu.

Any reply is appreciated,thanks.

Re: Restoring database with frm myi and myd

The db format is in "innodb" On Dec 17, 2007 5:38 PM, To Glace <[EMAIL PROTECTED]> wrote: > Hello, > > A database which has been deleted need to be restored. > There is no .sql dump file. > All we have is the .frm, .myi and .myd files from > /var/lib/mysql/DATABASENAME. > > Here are the steps I h

Restoring database with frm myi and myd

Hello, A database which has been deleted need to be restored. There is no .sql dump file. All we have is the .frm, .myi and .myd files from /var/lib/mysql/DATABASENAME. Here are the steps I have taken: 1. Created a new empty database - NEWDB 2. individually restored all tables using the restore c

Re: Update but insert if not exist

INSERT ... ON DUPLICATE KEY UPDATE: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html Cheers, Jay J Trahair wrote: This is a question I want to know the answer to, as well! Is there any way of avoiding looking up a specific record in a table to see if it exists, before decidin

Re: Update but insert if not exist

This is a question I want to know the answer to, as well! Is there any way of avoiding looking up a specific record in a table to see if it exists, before deciding whether to INSERT INTO or UPDATE, eg: mstrSQL = "SELECT * FROM Shops WHERE ShopReference = '" & grd1.TextMatrix(numRowNo, 1) &

Re: Update but insert if not exist

On Dec 16, 2007 10:29 AM, Afan Pasalic <[EMAIL PROTECTED]> wrote: > try REPLACE > http://dev.mysql.com/doc/refman/5.1/en/replace.html > > -afan Replace will not do an update. All previous data will be lost. A mysql-centric alternative solution would be to use INSERT ... ON DUPLICATE KEY UPDATE htt

Re: Select mit Subselect Problem

At 7:45a -0500 on 17 Dec 2007, Marcus Füg wrote: > Tabelle Sales (s) mit jede Menge Abverkaufsdaten. > ArtikelNr,Kassenbon,HändlerID,Datum > > Jetzt sollen alle zu einem gekauften Artikel ebenfalls augelistet > werden, d.h. was wurde mit dem Artikel zusätzliche gekauft > > Bisher habe ich das mit

Select mit Subselect Problem

Hallo, folgendes Szenario: Tabelle Sales (s) mit jede Menge Abverkaufsdaten. ArtikelNr,Kassenbon,HändlerID,Datum Jetzt sollen alle zu einem gekauften Artikel ebenfalls augelistet werden, d.h. was wurde mit dem Artikel zusätzliche gekauft Bisher habe ich das mit PHP gemacht, nur macht jetzt