Re: Query bug

ot;) Veln - Original Message - From: "Johnny Withers" To: "Velen Vydelingum" Cc: 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"

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 w

rebuilding table

ost 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 History>Code, 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. Ca

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" Sent: Monda

Help with Table structure

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: 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"

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]

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

Help needed

ts 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?

table and matching results in table A & B. This one may be slower. Regards, Velen - Original Message - From: "sbrattla" <[EMAIL PROTECTED]> To: Sent: Wednesday, May 07, 2008 6:41 PM Subject: Any better ways that LEFT JOIN? > > Hi, > > My scenario is a

mysqldump character set

tation, 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

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

Display more than 2500 rows

's a nightmare! 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" Sent: T

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 - O

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: Sent: Friday, March 21, 2008 6:00 PM Subject: Re:

Re: Optimize db update

e 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: Sent: Thu

Optimize db update

dy 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: Sent: Sunday, March 16, 2008 1:42 AM Subject: how to use

Re: Select Statement

s contains links as follows: a contains sale_id b contains cust_code c contains prodbarcode d contains sale_id,cust_code Can you suggest any correction? Thanks Velen

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]

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 The