creating an index is necessary for fulltext search.
and when i say
create fulltext index search_index on sometable(column1,column2) i
get an error messg like
Error: The used table type doesn't support FULLTEXT indexes
Why doesn't InnoDb support FullText indexes?
Is there a physical
li
Connection();
stmt = con.createStatement();
rs = stmt.executeQuery(sqlQuery);
}
- Original Message -
From: Venu Anuganti <[EMAIL PROTECTED]>
To: Asha Ramaiah <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 11:55 AM
Subject: Re: Info needed!
> If Connection.isClosed()
I need to run a query from a java program to :
1) get the list of tables in a particular db]
2) get the desc of each table in the list I get
Can I use the show tables; and desc tablename as a query to get the desired RESULTSET
in java(sql package) ??
Plz do respond at hte earliest!
Thanks and re
lowing:
#2 query : " select * from Table B where tId not in (tString);
All I want is the same result , but using joins, Iff it is possible!
I certainly hope u get my problem this time!!:(..
Thanks for your time
Rgds,
Ash
- Original Message -
From: Don Read <[
Hey! guys!
I wanted a little help on the following : ..
Scenario:
I have 2 tables : one task and the other tasksequence
desc task : (primary key taskId, varchar taskdesc)
desc tasksequence (primary key (taskId,milestoneId))
Now the query I want to form should give me a list of all taskIds in
