items quantity

Hi ALL! Please help I have 2 tables... header -- id type_ DATA: --- id type_ 11 21 32 items -- header_id item_id quantity DATA: header_iditem_idquant 1110 1220 21100 22200 31

Re: create "serial number" by select

select On Thu, 25 Aug 2005, Pooly wrote: Why not adding an auto_increment column to your data ? 2005/8/25, Gyurasits Zoltán <[EMAIL PROTECTED]>: I can't build "serial number" in table1!

create "serial number" by select

Hello All! I have a little problem. I can't do "serial number" in result of select. Example: TABLE1 value -- res1 res2 res3 SELECT (??), value FROM table1 ... 1res1 2res2 3 ... . . I can't build "serial number" in table1! Thans! Best Regards! Zoli

mysql v5.0

Hello All! I have a question. I'm using the mysql 4.0 but I want change 5.0 because I would like to use some features. (Subselect etc) Was 5.0 ever used in bigger system? Is 5.0 more realible than 4.0? Where can I find information about critical bugs and errors of 5.0? Thanx! Zoli -- M

Re: Hour counts

Working!!! Thank you!!! - Original Message - From: <[EMAIL PROTECTED]> To: "Gyurasits Zoltán" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, July 27, 2005 7:09 PM Subject: Re: Hour counts Gyurasits Zoltán <[EMAIL PROTECTED]> wrote on 07/27/2005 12:57:42 PM:

Re: Hour counts

TIMESTAMP() is available as of MySQL 4.1.1. I can't use this version because replication working :( I use version 4.0.22 - Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: "Gyurasits Zoltán" <[EMAIL PROTECTED]>; Sent: Wednesd

Hour counts

Hello All! I would like to calculate the hour counts from 2 'datetime'. Example: 2005-07-27 18:00 and 2005-07-27 19:30 => 1,5 hour I try this but not good! R1 : munkaido_end-munkaido_start /simple substract/ R2 : ROUND(ROUND((end-start)/1)+ (((end-start)/1000-(ROUND((end-start)/10

Re: Optimises LEFT JOIN

Message - From: "Jigal van Hemert" <[EMAIL PROTECTED]> To: "Gyurasits Zoltán" <[EMAIL PROTECTED]>; Sent: Monday, June 13, 2005 10:01 AM Subject: Re: Optimises LEFT JOIN From: "Gyurasits Zoltán" I have a speed problem with LEFT JOIN condition. (...)

Optimises LEFT JOIN

Hello All! I have a speed problem with LEFT JOIN condition. SELECT * FROM t1 INNER JOIN t2 ON t2.c_ID=t1.ID WHERE The table2 row count is high. (100 000 records) This is correct and FAST (1-2 sec), but not good for me. Because I need all record from table1. I use this... SELECT * FROM