Re: Support for subqueries in V 4.1.1

for any pointers you can provide. Michael Michael Greis [EMAIL PROTECTED] Office: (781) 449-8017 Home: (781) 449-8007 mvh Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Locks dont lock

pstockx 8128 Query select amount from pstockx where productID=8 2846 TIA Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Locking one table blocks others

] mvh Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[SQL]how to delete record where I reference to other table

Hi Has look alot around , and tried a lot without success how to do this : Delete from pproductMix PM where PM.mixID in (select ID from pmix where mixno=72000) I would like a solution with and without subqueries thanks Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL

Re: Load Data Infile confusion

point is set to something diff than . depending of ur enviroment ? Not much help , only a kind of maybe list :) HTH Kim G. Pedersen This one has had me scratching my head all afternoon. I have a comma delimited text file that I am using to import data from a legacy system into a MyISAM table

Next release of 4.1x , any release plans

Hello Since it quite buggy using 4.1 in combination with subselect it could be nice to know next planned release of 4.1.x regards Kim G. Pedersen macaos/elprint Development -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: ORDER BY DESC order different when using LIMIT

Hi I am not sure how this limit works , but in oracle if you use a rownum100 (guess it is some of the same), the sorting are done After the limitation so... if u say rownum100 , it gives u 100 lines abitrary order and then it sorts that 100 lines HTH Kim G. Pedersen Description: When using

Re: Sql - Problem with Left Join

query worked at all. On Wednesday, November 12, 2003, at 05:20 PM, Kim G. Pedersen wrote: the little Query1 works until I add the left join : Query 1 ) Select A.DepartmentName,A.Address,P.Postcode,P.cityname from caddress A,cpostinfo P there A.ID=10 and A.PostInfoID=P.ID Query 2

[SubQuery] BUG ??

=OPOL.EventtypeID group by OPOL.PositionID,OPOL.ProductID having sum(OET.SignValue*OPOL.LocalPrice) 0 ) T4 POS2.InvoiceAddrID = A.ID join pproduct PRO on POL1.ProductID=PRO.ID wherePOL1.positionID = T4.PositionID ** FULL QUERY END ** Using 4.1.0-alfa-log regards Kim G

from char to Date routine

Hello I looking for a way to convert a datestring to date value example UnknowFunction('23.03.68','dd.mm.yy') - unixtimestamp In oracle we have to_date('23.03.68','dd.mm.yy') I have search the net for hours without luck. Regards Kim G. Pedersen macaos/elprint Development +45 35373808

Re: Truncate do not reset auto increment counter

Kim G. Pedersen [EMAIL PROTECTED] wrote: I once red that using truncate table xx instead of delete from xx should reset autoincrement , but it seem not to happend. but when I try to insert data with insert or load data in it remember the old autoincrement value. from manual : Truncate

Truncate do not reset auto increment counter

, which is much faster than deleting rows one by one. seems not , when I drop table and the create table again it works perfect. Mysql Linux 4.014 regards Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: insert ... select .. order by, problem

) with other words , I u are interest in a specific order when selecting , u MUST use Order By hope this help regards Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Help with SQL Query

Hi Having 2 tables TOrders: ProductID Amount 400810 4008 -5 4110 7 4110 2 4110 -4 4110 1 TStock ProductID Count 4110 3 4110 2 What I want Is a sum of product

How To See Sql Statements send to server ?

Hello How can I see the lastest Sql Commands/statements which has been send to my mySql server ?? Are there Any Logfile or command to use ??? Thanks in advance Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL General Mailing List For list archives: http://lists.mysql.com