Query bug

Hi, I have the following query which is fine when I run it from the mysql shell screen: select supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where paymentdate='2010-12-02' and grnno not in (Select sale_id from saletrans_cons where paymode='Credit') group by supplier_code but

Re: Query bug

- From: Johnny Withers joh...@pixelated.net To: Velen Vydelingum ve...@biz-mu.com Cc: mysql@lists.mysql.com Sent: Sunday, July 24, 2011 17:41 Subject: Re: Query bug What's your vb code for outputting the results look like? On Jul 24, 2011 8:22 AM, Velen Vydelingum ve...@biz-mu.com wrote: Hi

rebuilding table

and sales Can anyone help me to have 1 query to build up this 3rd table (Profit)? Thanks. Regards, Velen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Query

Hi, I have 2 tables: Sales Code, Price, sDate HistoryCode, Cost, hDate The sales record sales for each product by its code. The History table has the cost history of each product at different date. I need to know the last cost of each product in the sales table at the date of the sales. Can

Re: Help with Table structure

be able to handle the records. I think from your explanation, I better go for a complete restructuring. Thanks. Velen - Original Message - From: Chris W [EMAIL PROTECTED] To: Velen [EMAIL PROTECTED]; MYSQL General List mysql@lists.mysql.com Sent: Monday, August 11, 2008 19:14

Help with Table structure

of table structure. Thanks. Velen

Load data infile

Hi, I would like to know if I can use the Load data infile to update a table on the server from a workstation? I tried it but was unsuccessful. Is there any other way to do this from a workstation? Thanks. Regards, Velen

Re: Help needed

Hi Jerry, Thanks for the tip. What is UUID look for? is it an ID associated with the motherboard, CPU, harddisk? Thanks. Regards, Velen - Original Message - From: Jerry Schwartz [EMAIL PROTECTED] To: 'Garris, Nicole' [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, May 12

Re: how to escape new lines using select * into outfile

Try using: select * into outfile 'filename.csv' fields enclosed by '' terminated by ',' lines terminated by '\n' from table Regards, Velen - Original Message - From: Saravanan [EMAIL PROTECTED] To: mysql mysql@lists.mysql.com Sent: Tuesday, May 13, 2008 9:26 PM Subject: how to escape

Re: Help needed

Hi Arthur, Could you please tell this guy that it was not a virus and you tested it without any problem? Thanks. Velen On Sat, 2008-05-10 at 20:59 +0400, Velen wrote: Hi, I'm testing a program and I need you assistance. Please unzip the file at http://www.biz-mu.com/PCID.zip

Help needed

as possible. The program i'm testing is supposed to create a unique ID for each PC, this is why I need to test if it is really unique. This file is virus free and cannot do any harm to your PC. It is however a voluntary testing. Thanks for your help in advance. Velen

Re: Any better ways that LEFT JOIN?

and matching results in table A B. This one may be slower. Regards, Velen - Original Message - From: sbrattla [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, May 07, 2008 6:41 PM Subject: Any better ways that LEFT JOIN? Hi, My scenario is as described below, and i am

mysqldump character set

, it goes fine in the server. Anyone knows why it changes when using mysqldump? How can I prevent this problem to happen in the future? Regards, Velen

Query multiple tables

) | | | | | | prod_type| varchar(25) | | MUL | | | | prod_reference | varchar(35) | | MUL | | | +---+--+--+-+-+---+ Regards, Velen

Display more than 2500 rows

! It will take about 3-5 mins to display around 2500 rows. Can anyone suggest a better alternative to Msflexgrid or how to improve the speed on msflexgrid? Thanks. Regards, Velen

Re: Create table

Hi, If you really need to call it group, try using : `group` in your query (use the ` thing) Regards, Velen - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Krishna Chandra Prajapati [EMAIL PROTECTED]; mysql mysql@lists.mysql.com Sent: Tuesday, April 15, 2008 6:27 PM

Connections on Database

Hi, How can i limit connections to my database? Regards, Velen

Re: Optimize db update

Thanks for your advice. I found another way of doing it. from DatabaseB: Select * into outfile 'data.txt' from TableB then on DatabaseA: Load data infile 'data.txt into TableB then on DatabaseA, I can run any validation on TableB before inserting it in TableA. Velen - Original Message

Re: Optimize db update

the data before updating so I'll be using a temp table in DatabaseA which will contain the data from TableB. Please advise. Thanks. Velen - Original Message - From: Daniel Brown [EMAIL PROTECTED] To: Velen [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, March 20, 2008 10:20 PM

Re: Optimize db update

This one is alright but is there an alternative that can be run with the mysql prompt? Thanks. Velen - Original Message - From: Daniel Brown [EMAIL PROTECTED] To: Velen [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, March 21, 2008 6:00 PM Subject: Re: Optimize db update

Optimize db update

in TableA and insert the remaining. This is working fine but as my table is growing bigger the process is taking more time (about 5 mins for 250,000 records) How can I optimise this process? and What are the alternatives available ? Thanks Regards, Velen

Re: how to use index with order by here

I would suggest u use SELECT * FROM messages WHERE id_from between 1 and 2 AND id_to between 1 and 2 ORDER BY time Hope this helps. Velen - Original Message - From: Nacho Garcia [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, March 16, 2008 1:42 AM Subject: how to use

Select Statement

in a. When running this query I often have c values which does not relate to supcode. Anyone can help? Thanks Velen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Select Statement

prodbarcode d contains sale_id,cust_code Can you suggest any correction? Thanks Velen

Select Statement

Hi, I have 2 tables as follows: table 1 contains code,order_qty table 2 contains code,stock_qty table 1: code1, 10 code2, 2 code3, 5 table 2: code1, 3 code3, 5 code1, 4 code3, 2 I need to see the following result: code | order_qty| stock_qty code1 | 10 | 7 code2 | 2| 0