> Could something have gone wrong with the upgrade or am I missing something
> obvious about the subquery support in 4.1.1?
>
> Thanks for any pointers you can provide.
>
> Michael
>
> Michael Greis
> [EMAIL PROTECTED]
> Office: (781) 449-8017
> Home: (781) 449-8007
m
else with any other table?
>
> Thanks,
> Wouter
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
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]
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]
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
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
> legac
Hi
I am not sure how this "limit" works , but in oracle
if you use a rownum<100 (guess it is some of the same),
the sorting are done After the limitation so...
if u say rownum<100 , it gives u 100 lines abitrary order and then it
sorts that 100 lines
HTH
Kim G. Pedersen
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 unsubscrib
d your 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,cpost
hould not effect ur result.
Hope Someone can give me clue
using Mysql 4.1.0
regards
Kim G. Pedersen
macaos/elprint Development
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
*
Using 4.1.0-alfa-log
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/[EMAIL PROTECTED]
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. Peder
> "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 &
"Truncate operations drop and re-create the table, 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 Mail
u insert records )
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
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 nee
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
16 matches
Mail list logo