Group by problem

2004-02-16 Thread Pawan Darira
a company. my data should come in following way: compscore ~ 13.71 10.3 10.1 22.5 21.7 30.9 regards Pawan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

problem using MySQL++ API

2003-12-05 Thread Pawan
hello, I am using mysql++ API and it is giving an error - The procedure entry point mysql_connect could not be located in the dynamic link library LIBMYSQL.dll any solutions, Best Regards - Pawan Have A Nice Day

Fulltext search

2002-01-09 Thread Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC
Hello Recently we have installed mysql ver 4.0.1(from binaries).We loaded about 1.6 million records in a table. One of the fields 'ti' is text field. We created fulltext index on this field. on giving following :- 1. select ti from p8387 where match ti against ('computer'); 1701 rows were

how to split database and index

2001-05-10 Thread Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC
Hello We have a database of size 10GB and its index is also almost of the same size. Now we want this database in MYSQL. Please let me know how we can slpit it across 3-4 hard disks.We are using Linux 6.2 Kind Regards Pawan

SQL query

2001-03-15 Thread Pawan Kanda
Hi , i have the following method: public Object getValueAt(int row, int column){ // in here i want to construct a SQL query which gives the object at a certain row and column } Do you know how to do it? Thanks Pawan