No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
I have two tables tb1 and tb2. I would like to sum up field values from two tables. How to do this using a SQL statement. tb1 Name Salary Bob 1000 Tom 2000 John 3000 Winson 4000 tb2 Name Bonus Bob 100 Tom 200 I would like to get the …
|
|
|
Hi ALL THere is a data table from a flower shop which looks like [CODE] CustomerID Flower John peony John lily John Lotus Mary peony Mary lily Mary chrysanthemum Lisa chrysanthemum Lisa peony Lisa kapok [/CODE] I would like to find those customers' ID who buy the same n flowers. … 
|
|
|
Hello ALL, I have a vector vector<CLUSTER> ClustList; where [Code] struct CLUSTER{ string DocID_DocName; } [/code] some members of CLUSTER have been ignored for simplicityInitially, I put 3 elements into ClusterList by using push_back() the content in DocID_DocName is shown below. [Code] ClusterList[0].DocID_DocName = "0"; ClusterList[1].DocID_DocName = "1"; ClusterList[2].DocID_DocName = … 
|
|
|
Hello ALL, I have a table contains words extracted from documents which are belonging to a number of categories. Each category contains a number of documents. For each category, I want to find out those words which occur at least in N documents belonging to this category. [Code] Category DocID … |
|
|
Hello ALL, I have a table contains words extracted from a few documents. [Code] DocID Word Tag 1 Book noun 1 Pen noun 1 Pencil noun 2 There prep 2 Hand noun 2 Have verb 3 Oil noun 3 Thorough adv 3 Drive verb 4 Red adj 4 Blue adj …
|
|
|
Hello ALL The project we're working on is a document retrieval system I have 3 tables as follows. Table 1 contains words from a example doc. Table 2 contains words from documents in a database. Table3 contain only one column ‘DocID’. I would like to search the database to find …
|
|
|
Hi all, THere is no intersect statement in MySQL. I figure out a workaround as shown below. However, I am not sure if it is correct or not. Please help. [code] SELECT * FROM ( SELECT DISTINCT col1 FROM t1 WHERE... UNION ALL SELECT DISTINCT col1 FROM t1 WHERE... ) …
|
|
|
Hello ALL, I did the following query. the EXPLAIN result showed 'NULL' in the 'key' colume, meaning that NONE of indexes have been used. However, indexes have been created on Name fields for both tb1 and tb2. I wonder why MySQL does not use the indexes to speed up the …
|
|
|
Hi ALL, The project we're working on is a document retrieval system. Two kinds of Features for each document in a repository are extracted as described in table-1 and table-2. Table1 DocID Word LocationName PersonName Freq 1 Book N N 9 1 Study N N 3 2 Work N N … |
|
|
Hello ALL, I am new to MySQl. I am using MySQL ver 5.1.28 I have got two questions. (1) Can I make a user-defined function return a tabular result.(say, a list of person name) (2) Can I call the function in a select statement, like [CODE] SELECT * FROM Employee_List … |
|
|
Hi ALL, The project we're working on is a document retrieval system. Two kinds of Features for each document in a repository are extracted as described in table-1 and table-2. Table1 DocID Word Freq 1 Book 9 1 Study 3 2 Work 4 2 Run 5 2 User 2 3 … |
|
|
Hello ALL, In my program, I first receive data from another machine, then processing the data. Data receiveing is fast, but data processing is relatively time consuming. Hence, I put the code for data processing in a POSIX thread (i am using Red Hat enterpriese linux AS 4). In the …
|