Re: Strange behavior by MySQL Stored Procedure

Stored procedures are not executed like a query.  They are executed thru a Call { procedure} method. Please check the same or let us know how you are executing the Query/Calling the Procedure. Regards, VR Venugopal Rao --- On Fri, 28/5/10, Manasi Save wrote: From: Manasi Save Subject

How to Get Running Totals.

I am trying ot use backend query for getting the results. response with examples will be more helpful. With regards, VR Venugopal Rao   --- On Wed, 28/4/10, Jay Blanchard wrote: From: Jay Blanchard Subject: RE: Pivot Query in To: "VR Venugopal Rao" , "MySQL" Date: Wedn

Pivot Query in MySQL

Thanks Jay, I got the solution. Thanks for all the members responding. With warm regards, VR Venugopal Rao -Original Message- From: Jay Blanchard [mailto:jblanch...@pocket.com] Sent: 28 April 2010 16:58 To: VR Venugopal Rao; MySQL Subject: RE: Pivot Query in [snip] Date, ProjectCode

Pivot Query in

get the Count. -- With regards, VR Venugopal Rao 91-90526-07186 __ DISCLAIMER The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you

Hey Mysql@lists.mysql.com ;)

http://www.hi5.com/register/kVpo2?inviteId=A_7e7f21c_NcJWKAPvLSm0 VenuGopal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to access an array variables in a single query

7;i2','i3'); Thanks ViSolve DB Team. - Original Message - From: "VenuGopal Papasani" <[EMAIL PROTECTED]> To: Cc: "bharath kumar" <[EMAIL PROTECTED]> Sent: Saturday, January 06, 2007 2:07 PM Subject: How to access an array variables in a single qu

How to access an array variables in a single query

Dear all, I have got an array variable say a[]={"i1","i2",i3""} now i need to get the values from the database that matches i1,i2,i3 for example select * from tablename where i1=a[1] and simillaryly to a[2] and a[3] but my list is too big one more option i can write it

Error:1067 could not start mysql server

Dear all, I am getting the following error when i m trying to start mysql server Error:1067:process terminated unexpectedly. I have tried stopping many services and start mysql but not successful.But i need to get my data backup.Is there any alternative to mysqldump command where i can

mysqldump problem

hi all, I have got a problem with mysql and i want to uninstall it and then re-install it but the problem is how to recover my data.My mysqldump command is not working.Can i have any other procedure to recover my data like copying the folder of my database from the data folder and then making a b

what this error was

Hi, I was trying to import some of the data into the 'datavalue' table of my database i was getting th following error Error Code : 1452 Cannot add or update a child row: a foreign key constraint fails (`gtest1/datavalue`, CONSTRAINT `FKEB92DC077A7A2FFA` FOREIGN KEY (`dataElement`) REFERENCES `da

Query needed to convert varchar to int ....sorry previous posting was incomplete

Dear all, I have a table with the following structure. ield Type CollationNullKey Default Extra Privileges Comment --- -- -- --- --

Query to convert a varchar into int

Dear all, I have a table with the following structure. ield Type CollationNullKey Default Extra Privileges Comment --- -- -- --- --

Re: query needed

de, 0))) - SUM(IF(code='c4', code, IF(code='c5', code, 0))) FROM datavalue; -Original Message- From: VenuGopal Papasani [mailto:[EMAIL PROTECTED] Sent: Monday, August 14, 2006 11:26 AM To: mysql@lists.mysql.com Subject: query needed Hi, i got a table datavalue as

Re: query needed

Finally the result is (c1+c2) - (c4-c5) = 25 - 20 = 5 On 8/14/06, Chris <[EMAIL PROTECTED]> wrote: VenuGopal Papasani wrote: > Hi, > i got a table datavalue as follows > code period value > > c1

query needed

Hi, i got a table datavalue as follows code period value c1 20051 c2 20052 c32006 3 c4

need one query

Hi all, I Have a table with followin structure where i have orgunit and parent and value orgunitparent value 12 10 x 1512 y 16

How to share data between servers

Hi all, I have got two servers.Let it be server1 and server2 now i have an application one on server1 which gets the data everymonth and stores in the database and now the problem is the application in server2 also need the data to be accessed but data is entered only once in server1 applicati

Error while displaying Multilanguages

Hi all, I am having a problem with JSP while trying to read the data from mysql database and displaying it on the screen.It has been diplayed as ?? rather the actual data.May i know whether the problem is with JSP or MYSQL.Where the changes to be made in order get it work correctly.I a

error in JDBC Connection(Sorry there was TYPO ERROR in my previous mail)

Hi all, I have got a problem with the jdbc connection while connecting to Mysql.I have written an XML file.The following is the code for giving the database connection com.mysql.jdbc.Driver<\driver> jdbc:mysql:\\localhost\test<\location> root<\us

Problem with JDBC Connection

Hi all, I have got a problem with the jdbc connection while connecting to Mysql.I have written an XML file.The following is the code for giving the database connection com.mysql.jdbc.Driver<\driver> jdbc:mysql:\\localhost\\test<\location> root<\u

Hello how to connect MySQL with Visual Foxpro

Hi all, I have got a database in mysql and i need to use the gis and that was in VFOXPRO.I need to display my data which is mysql on the map which database is in VFoXPRO.Is there any way to have communication betweeen these two DBs. Thanks and regards, venu.

hi how to merge data of various sql files

hi all, I have got a problem.I have data entered in different machines in a database now i have got all the data in different .sql files.Now i was importing the same files in order to merge them in a same database.Herethere was a problem in merging, There were some tables which does´not change th

Can i have query for this

VenugOpal VENU papasani papasni pvenu venu--k venu-t Now i need to get all the records which consists of the string venu(case should not be considered either case should be).i.e i should get 1,2,3,4,5,8 records but i should not get 9 and 10th records which is also consists of venu. I

Help regarding a simple query

Hi, I am searching for a query where i can have pattern matching without considering the cases.You can consider the following example for detailed description of what i want exactly. Let my table X consists of following data Name --- venu venup venugopla VenugOpal VENU

can we convert shape files

Hi all, Is there any possibility to convert and store a shape file into the mysql database like postgis feature in postgres.If there any please give me the steps how to convert or the link that consists of this documentation. Thanks in advance, Regards, venu.

help regarding writing a query

HI all, This is venugopal.Being a silent member of this group.I am having a doubt regarding writing a query.I can explain it with an example Consider i have a table called GetParents The table consists of two fieds called num as Integer ParentNum

Link between tables.

corresponding key_no1 present in table_no1. OR I need to enforce referential integrity. All suggestions are welcome. regards venu = Venugopal Allavatam Ph: (res.): 949-361-6604 1100 Calle Del Cerro, (mobile

File privileges?!

welcome. I must solve this problem. regards venu = ==== Venugopal Allavatam Ph: (res.): 949-361-6604 1100 Calle Del Cerro, (mobile): 949-842-1767 Apt.# 123-J, San Clemente, CA-9267

File permissions

13) i get the following error, can anyone explain it! regards venu = ==== Venugopal Allavatam Ph: (res.): 949-361-6604 1100 Calle Del Cerro, (mobile): 949-842-1767 Apt.# 123-J, San Clement

load_file problem

cannot be stored as I set it that way in the table creation statement. It also means that the load_file function is returning a null. I am using the 3.23.36 of mysql. I need suggestions. Thank you Venu = ==== Venugopal Allavatam

load_file problem

lue. please help. thanks! venu = ==== Venugopal Allavatam Ph: (res.): 949-361-6604 1100 Calle Del Cerro, (mobile): 949-842-1767 Apt.# 123-J, San Clemente, CA-92672 E-mail:

load_file problem

t that the load_file function was returning a NULL. I have checked out the parameter 'max_allowed_packet' and other messages but to no avail. Any suggestion?! Regards Venu = ==== Venugopal Allavatam Ph: (res.