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
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
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
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
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
Dear all,
I have a table with the following structure.
ield Type CollationNullKey Default
Extra Privileges Comment
--- -- -- ---
--
Dear all,
I have a table with the following structure.
ield Type CollationNullKey Default
Extra Privileges Comment
--- -- -- ---
--
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
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
Hi,
i got a table datavalue as follows
code period value
c1 20051
c2 20052
c32006 3
c4
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
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
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
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
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
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 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
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
VenugOpa
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
pap
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.
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
21 matches
Mail list logo