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

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

ViSolve DB Team. - Original Message - From: VenuGopal Papasani [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: bharath kumar [EMAIL PROTECTED] Sent: Saturday, January 06, 2007 2:07 PM Subject: How to access an array variables in a single query Dear all, I have got an array variable say

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

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

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

Query to convert a varchar into int

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

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

Re: query needed

', 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 follows code period

query needed

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

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 20051 c2

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

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

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 DATABASE type=String drivercom.mysql.jdbc.Driver\driver database

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 DATABASE type=String drivercom.mysql.jdbc.Driver\driver database

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

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 i have query for this

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

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