GRAPH Computation Engine for MySQL
http://forge.mysql.com/wiki/GRAPH_computation_engine_for_MySQL
This Thursday (November 5th, 10:00 UTC - note the different time for
this session!), Arjen Lentz of Open Query will present the brand new
GRAPH computation engine for MySQL.
From the abstract: Most
Hello,
Could you please post new press-release or news - don't know how to call it
from Devart?
Devart Team is glad to present updated versions of dbForge Fusion for MySQL
and OraDeveloper Tools.
Devart Team is glad to present updated versions of dbForge Fusion for MySQL
and
Darn, it's not working after all.
SELECT
people.*,
COUNT ( DISTINCT cars.car_id ) AS car_count,
COUNT ( DISTINCT pets.pet_id ) AS pet_count,
SUM ( IF ( pets.date_bought NOW() - INTERVAL 7 DAY, 1, 0 ) ) AS
new_pet_count
WHERE...etc
car_count and pet_count are calculating correctly, but
Hi
i request a small help for know if it's possible.
Anyone know if they have a Sql request for
search the best value at one information:
Sample:
i have a table with:
ID int 5
Chaine int 16
and this entry:
1 12345
2 123
3 12
i am search a request in WHERE :
Chaine LIKE
I thought I could find the answer to this by googling, but had no luck.
How do I show a list of customers who:
(a) Have placed no orders within 14 days,
(b) Have been a customer for at least 14 days. (They do not have to
have placed any orders, ever, to be a customer.)
I'm trying to show
Hi,
I have a table of events like this:
Evtuid
Evtname
Startdate
Stopdate
Repeats enum('true', 'false')
Monday enum('true', 'false')
Tuesday enum('true', 'false')
Wednesday enum('true', 'false')
Thursday enum('true', 'false')
Friday enum('true', 'false')
Satday enum('true', 'false')
Sunday
you'll need to write a recursive routine to call the same sql statement
and iterate from the largest value and attenuate that value by 1 each time
# file: test.pl been a few years but this should work
#initialize your variable that you will attenuate
my $global = 9876543210;
#number of rows
Hello All, I desperately need your help.
I migrated from version 5.0.27
To version 5.0.77
Here is the command I used to migrate my databases:
mysqldump -ux -px --all-databases --master-data | mysql -h88.88.89.889
-ur -px
Problem: after the migration, I have been getting
select into outfile was the ticket. Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
More info. If the tables look like this:
customers
--
cust_id
signup_date
orders
--
order_id
cust_id
order_date
Then the SQL needs to accomplish something like this:
select * from customers
left join orders on customers.cust_id = orders.cust_id
where
I have a vb.net app that was running fine on two XP computers using
Mysql 5.0 server. I switched to a new Vista 64 bit computer, and now
it gives me a message that it can not connect to any mysql hosts.In
Navicat, when I try to setup the connection, it gives message 2003 -
Can't
any column used in any group functions such as SUM needs to be requested in
select column e.g.
select foo from table where sum(foo)=1.00
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist
Thanks. I added orders.order_date to the list of fields being
selected, but it still returns invalid use of group function.
On Nov 3, 2009, at 1:09 PM, Martin Gainty wrote:
any column used in any group functions such as SUM needs to be
requested in select column e.g.
select foo from
From: Brown, Charles
Sent: Tuesday, November 03, 2009 2:54 PM
To: Ramsey, Robert L; mysql@lists.mysql.com
Subject: socket '/tmp/mysql.sock' (2)
Hello All, I desperately need your help.
I migrated from version 5.0.27
To version 5.0.77
Here is the
14 matches
Mail list logo