Re: lug-bg: MySQL query

[gf@xxxxxxxxxxx (Georgi Chorbadzhiyski)]

krasimir wrote:
> öèòèðàì  Teodor Penev <tpenev@xxxxxx>:
> 
>> zdrasti lug-bg,
>> 
>> imam slednoto pitane:
>> MySQL tablica s razlichni poleta -
>> 
>> +--------+----------+
>> | id      | name    |
>> +---------+---------+
>> | 1       | joe     |
>> +---------+---------+
>> | 2       | jane    |
>> +---------+---------+
>> | n       | bill    |
>> +---------+---------+
>> 
>> 
>> celta e da vzema stoinostta na nai-goliamato 'id' (n)
>> (ili poslednoto) i da go vkaram v php code.
>> neshto kato SELECT id FROM table ORDER BY id WHERE id = '...'
>> ...
>> posle da uvelicha biggest id + 1 za nov zapis i t.n.
>> predpolagam che moje da se vikat stoinosttie na id (vsichkite)
>> v php i posle da se vzema nai-goliamato, no ne moga da go izmislia
>> v momenta...
>> 
>> any ideas? 10x
> 
> 
> 
> 
>  $result=mysql_query(sprintf("SELECT (MAX(tablename.id)+1) from 
> table.name;") , $link);
>  if($row = mysql_fetch_array($result))  {
>         if ($row[0]=='') $id=1; else
>         $id=$row[0];
>  } else {
>     exit();
>  }
>     mysql_query("insert into tablename values (".$id." , ...........)");
> 
> ako oshte ne si promenil poleto na auto increment moje da polzvash tozi 
> kod
> krasimir

I ako paralelno tozi kod se izpalniava 50-60 pyti v sekunda, kakvo shte stane ?
Osven tova e mnogo losha ideia da pravish selects, updates i inserts ednovremenno
v edna tablica na mysql.

============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================