Oracle imports into MySQL

Good day all I am hoping that someone has got some more answers for me on the topic as most of the websites which have not been very useful. All websites I have found thus far reffers to software that either needs to be bought or otherwise need to be run manually. One of our client

Re: select data from two tables and SUM qty of the same ID

I tried this and succeeded. Thank you SELECT product_id, isbn, name, author, harga, discount, sum(qty) as totalqty FROM " . $prefix . "_sales_report b INNER JOIN " . $prefix . "_product p ON (p.product_id = b.bid) GROUP BY b.bid ORDER BY totalqty DESC haidarpesebe - Original Message - Fr

Re: select data from two tables and SUM qty of the same ID

e ISBN QTY 1. product B 45624 2. product A 12314 I'm using PHP. Thanks a lot for information. __ Information from ESET Smart Security, version of virus signature database 5608 (20101110) __ T

MySQL replication SSL

Dear All, I'm trying to get SSL connections for all mysql slave and masters. I have one box that will not use SSL for some reason. When I start this slave it can not connect because it's not using SSL. show slave status\G *** 1. row ***

MySQL Community Server 5.5.7-rc has been released

Dear MySQL users, MySQL Server 5.5.7-rc, a new version of the popular Open Source Database Management System, has been released. The "-rc" suffix indicates this is a "release candidate". When there is sufficient positive feedback, there will be a "GA" (production quality) version of 5.5. From t

Re: Slave using SSL?

To me it really looks you are SSL replicating. In my experience If you are replicating in SSL either it works or not, I dont remember what should be there at "Master SSL Cipher", but I remember I had clear problems when SSL replication was not working. Claudio 2010/11/10 Paul Nowosielski > He

Slave using SSL?

Hey can anyone tell me is my slave is utilizing SSL? I am unsure why the Master SSL Cipher is not listed under show slave status. Here's some info: mysql> show slave status\G *** 1. row *** Slave_IO_State: Waiting for master to send eve

Re: MySQL clustering and licensing

Hi! Machiel Richards wrote: > Good day > >thank you all for the responses thus far. > > Just to add onto the requirements. > >The client's business is based around a website that does all > business related tasks and are exremely utilized. > > The idea is to provide f

RE: question about restoring...

I must have missed something way back in the beginning. I thought the original poster had a dump of his database. I have no idea if you can attach the innodb files to another database. I stand corrected. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave.

select data from two tables and SUM qty of the same ID

please help us look for the data select from two tables with the following details: Primary table: product ID | ProductName | ISBN | --- 1 | Product A | 123 | 2 | Product B | 456 | 3 | product C | 444 | --- second table: salesreport

Re: select data from two tables and SUM qty of the same ID

SELECT product.ID, product.ProductName, product.ISBN, SUM(salesreport.QTY) as Total_Quantity FROM salesreport, product WHERE product.ID = salesreport.ID GROUP BY salesreport.ID ORDER BY Total_Quantity DESC; On Nov 10, 2010, at 3:53 PM, HaidarPesebe wrote: > please help us look for the data se

Re: select data from two tables and SUM qty of the same ID

Thanks a lot. We will try and inform you. --Original Message-- From: Aveek Misra To: Albahar Uya Cc: MySQL Lists Subject: Re: select data from two tables and SUM qty of the same ID Sent: Nov 10, 2010 17:38 SELECT product.ID, product.ProductName, product.ISBN, SUM(salesreport.QTY) as Tota