Hi,
I have a list of 17 million sentences in a text file. Each sentence contains at max 200 characters. Each sentence is also accompanied by one or more annotation(s) with it. I have a list of unique annotations and a list of unique words obtained from the 17 million sentences. I have to create a sparse matrix with the rows as the uniqu...
Hi, this is a follow up to a question I got help with on here yesterday, but it's a slightly different issue - i'm trying to check if a mysql timestamp of a db record matches 7 days in the past (ignoring hours and seconds etc), but I'm getting a "Column 'import_date' in where clause is ambiguous", can anyone see the problem?
This is the...
Hi,
I am new to symfony and propel . How can I create the following query using propel ?
"UPDATE tablename SET status = 1 WHERE id IN (1,2,3,4)";
Thanks.
...
I need to make a search query, where a user can search by name or course or year or member, any one of above and also the user cam make a search with all the field or any number of field, e.g.;-as only with name & course.
How it is possible? I don't want to make different query, can it be possible with a single query? now my query is:
...
Hi,
I'm trying to embed mysql queries into excel and I've been mostly successful so far. I'm using the odbc and Import Data External.............From a database query.
Problem is that when I return text columns they show in the query and in the msquery browser but they won't return to the sheet. How do I have text columns return do t...
I need to make a search engine where a user can search by name,year,member,year(text field)
search will be with any one field
or
search will be with all the field
or
search will be with more than one field
-How it is possible by using only one query??
now my code is
$query="select * from fsb_profile where profile_name = '".$_REQUEST['n...
I have this table:
-------
id a b
-------
1 1 1
2 1 5
3 1 1
4 1 1
5 1 6
How do I select this?
-------
id a b
-------
1 1 1
2 1 5
5 1 6
...
Hello.
I have a closed source application which put a 13 character long timestamp in a MySQL database. One value is for example:
1277953190942
Now I have the problem, that I have to write a sql statement which will return me all results of a table which match a special day.
So I have for example 01. July 2010 and I will get all rows...
I have an online shop where users can have little shops with their own products. Each of this products can have questions associated to it and the owner of the shop has the ability to answer those questions. This information is stored in 3 tables a "Questions"(QuestionID,ProductID,...) table, a "Products"(ProductID,ShopID,...) table and ...
I have recently implemented Google and Yahoo's OpenID endpoints into my authentication system on my site so that users can avoid creating an account on my site. Pretty common practice, right?
I have a specific question though, but first a little background information.
When I get through the three-legged authentication I used Attribute...
I need to make a search engine where a user can search by name,course,member,year(text field) from the table fsb_profile fields are profile_name,profile_course,profile_member,profile_year
search will be with any one field
or
search will be with all the field
or
search will be with more than one field
-How it is possible by using only on...
When a user subscribes to my newsletter via their email address, using php, how would I send them an 'Activation Link' via email to confirm it is their email address and not a fake one.
so at the moment I have
PHP:
<?php
$to = "[email protected]";
$subject = "Hi!";
$body = "Hi,\n\nHow are you?";
if (mail($to, $subject, $body)...
In the following query, the error Unknown column 'order.id' in 'on clause' is being thrown by my order.id reference in the INNER JOIN. The id column does indeed exist.
Any ideas why it's not accessible via the sub query?
SELECT
SUM(price+shipping_price) AS total_sales,
COUNT(id) AS total_orders,
AVG(price+shipping_price) A...
Hello to all!
I have a sql statement like this:
select a.id, a.valfrom ...
inner join ...
where ...;
As a result I have this:
id val
---------
3 10
3 10
3 10
9 21
9 21
11 2
11 2
13 30
So you can see, one id has one value.
If I do a group by (a.id), I get:
id val
---------
3 1...
Hi
I have an MS Access 2003 frontend and mySQL backend.
I would like to automatically connect to MySQL when the MDB is opened for the first time, eg when the Main Menu form of Access is displayed.
However I have no idea and I keep getting the "annoying" MySQL "Connector ODBC" pop up box.
This happens when I go into a form in Access whi...
i have 3 tables see the picture
i want the sql statement which produde report like Required Report in pic.
...
I am using mysql and trying to export database through below command
mysqldump -uroot -p -d database_name > file.sql
It ran successfully.
However it did not export the data, it only export the schema of database.
anyone know why is this happening?
Thanks in advance.
...
I have a legacy table with about 100 columns (90% nullable). In those 90 columns I want to remove all empty strings and set them to null. I know I can:
update table set column = NULL where column = '';
update table set column2 = NULL where column2 = '';
But that is tedious and error prone. There has to be a way to do this on the whole...
I'm trying to join multiple myqsl tables and then process resulting arrays using PHP but I'm having problems manipulating my data to get the groupings I'd like.
table.users
+--------------- uidname
table.profile_values
+----------------------- fiduidcategory_value
table.profile_fields
+--------------------- fid catego...
I'm playing with timezones in MySQL.
I need to assign people to timezones, and so I looked in mysql.time_zone_data.
Australia seems to have 5 independent timezones [1], so why does mysql.time_zone_data have 23 options?
Australia/ACT
Australia/Adelaide
Australia/Brisbane
Australia/Broken_Hill
Australia/Canberra
Australia/Currie
Austral...