Is this what you are looking for:
SELECT clone_ids, COUNT(DISTINCT(gene_ids)) as count_genes
FROM table_name
GROUP BY clone_ids
or
SELECT clone_ids, COUNT(gene_ids) as count_genes
FROM table_name
GROUP BY clone_ids
Hope this helps,
Alvaro
- Original Message -
From: "Xiaobo Chen" <[EMAI
Hi guys. I don't want my job done by anybody else, but I have found no solution
for several days to this problem.
I am developing a micro-finance system to farmer communities. The problem I
have got is in the database description.
I have three principal tables: (see SQL at the end).
1. Loan
>
>Can anyone tell me what advantages there are in keeping dates and times in
a MySQL DateTime field, as opposed to storing its >string equivalent in a
Varchar field ?
Decent sorting, validity checking, being able to use the DATE and TIME
functions etc etc...
With regards,
Martijn Tonies
Databa
Hello,
Can anyone tell me what advantages there are in keeping dates and times in a
MySQL DateTime field, as opposed to storing its string equivalent in a Varchar
field ?
Regards,
Danny
Sunil,
in InnoDB, the maximum indexed column length is 767 bytes.
Osku is improving the error message:
http://bugs.mysql.com/bug.php?id=13315
Regards,
Heikki
Oracle/Innobase
- Original Message -
From: ""Sunil Vishwas"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tu
Hi,
I have such a situation:
There is a table with gene_ids and clone_ids. Each gene only resides on a
single clone and each clone may contain multiple genes. How do would I
find how many genes are on each and every clone?
Thanks in advance.
X.Chen
--
MySQL General Mailing List
For list arch
[posted only]
On Oct 24, 2005, at 8:14 PM, Claire McLister wrote:
if you go to the web page, http://www.zeesource.net/maps/help.do,
then in the paragraph under the heading "Automatic Maps" the last
sentence should give you the location of your IP.
Hmm. That located me perfectly, but on th
(I am using mysql-5.0.15-win32)
Why I am getting this error and is there any way I can fix it, or is it
a bug?
Between I don't get this error if I change the field size to 767 or
below:
drop table Address;
CREATE TABLE `Address`
(
`RecId` CHAR(32) NOT NULL,
`WebAddress` VARCHAR(1000),
CONS
Description:
[EMAIL PROTECTED] mysql-standard-5.0.15-linux-i686]# Starting mysqld
daemon with databases from /usr/local/mysql-standard-5.0.15-linux-i686/data
STOPPING server from pid file
/usr/local/mysql-standard-5.0.15-linux-i686/data/tomsEmachine.pid
051024 19:52:09 mysqld ended
[EMAIL PROT
I don't think I remember a time when MySQL only had stable production
releases available for download (at least not off the website) since
v3. Any idea if the next alpha is on the way?
Thanks, 5.0 looks great, I've been using it for over a year with very
few problems.
Josh
--
MySQL General Mai
Description:
[EMAIL PROTECTED] mysql-standard-5.0.15-linux-i686]# Starting mysqld
daemon with databases from /usr/local/mysql-standard-5.0.15-linux-i686/data
STOPPING server from pid file
/usr/local/mysql-standard-5.0.15-linux-i686/data/tomsEmachine.pid
051024 19:52:09 mysqld ended
Submit
Logs?
-
Sent from my NYPL BlackBerry Handheld.
- Original Message -
From: tom wible [EMAIL PROTECTED]
Sent: 10/24/2005 06:58 PM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: demon quits immediately...
>Description:
[EMAIL PROTECTED] mysql-standard-5.0.15-linu
This shows me as being in Washington, DC. My ISP has a point-of-presence
somewhere in the city. My physical location is Greenbelt, Maryland, USA.
Bob Cochran
Claire McLister wrote:
Peter,
We try to take care of the situation where people are coming from an
ISP account.
Let me know if yo
>Description:
[EMAIL PROTECTED] mysql-standard-5.0.15-linux-i686-glibc23]# Starting
mysqld daemon with databases from
/usr/local/mysql-standard-5.0.15-linux-i686-glibc23/data
STOPPING server from pid file
/usr/local/mysql-standard-5.0.15-linux-i686-glibc23/data/tomsEmachine.pid
051024 18:36:32
Peter,
We try to take care of the situation where people are coming from an
ISP account.
Let me know if you think there is a specific case that is not right on
our map. I searched for AOL in the map, and did not find a single entry
from AOL.
We do not use whois databases. As you correct
We do allow manual modifications to maps, through separate passwords
for group moderators, members, and viewers.
In our case, I have set the group password to 'mysqlmap'. Please feel
free to add your entries to the map. This password will only allow you
to add entries, or to modify existing en
This is particularly troublesome when it come to isp accounts. I.E., all aol
users showing Reston as their base.
I tried something like this using whois databases and had the same issues. I
canned the idea for now.
P
-
Sent from my NYPL BlackBerry Handheld.
- Original Mes
Thank you for your email.
It seems as though you are getting rave reviews from the list. I am sure
that if you want to make this really neat, try creating a simple web login
that allows for you to create an account using the email address, then
update your location so that it can be a little more
On Mon, 2005-10-24 at 14:19 -0700, Claire McLister wrote:
> We've developed an automatic email mapping capability from Google Maps
> API.
>
> To try it out, we mapped origins of emails to this group from October
> 3 through October 14th.
>
> The result of this map is at:
> http://www.zees
I got it figured out.. of all things it was a line return. DOH!
Dustin
On 24-Oct-05, at 12:14 PM, Dustin Krysak wrote:
Sorry - but to add to this, the command is actually in a bash
script. I suspect it is the single quotes and or the "()"
characters
Dustin
On 24-Oct-05, at 11:57 AM
I just joined this list so I am hoping that this question is relevant to
this group.
I am running Linux AS4 Enterprise Server.
I am running Mysql Ver 14.7 Distrib 4.1.12, for pc-linux-gnu (i686)
using readline 4.3
With Client version 3.23.49.
When I go and do a ps -ax I see 18 mysqld processes
Hi Claire,
I thought Daniel Kasak was in Sydney? It is about 2000kms from Alice Springs
8-) Apart from that, very good.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
That's awesome! I love it. Even though it didn't include me... :(
How are you doing the geotargeting?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Hi and Welcome to -
LASSO TIPS FOR NEWBIES: 3.3
I'm your host, M i l e s.
First and foremost, a good place for you to start with Lasso is the
following 5 things:
The FIRST LASSO TIPS FOR NEWBIES
-> http://www.listsearc
This is awesome! You missed me by 3 days. It looks like you can see the
exact street and house that an email originated from. I like the mapping
capability very much.
Bob Cochran
Claire McLister wrote:
Hi,
We've developed an automatic email mapping capability from Google
Maps API.
To
Hi!
I need help on implementing a query that performs a search for items under
nested categories. An example is on ebay search where you can restrict your
search by selecting a subcategory and you only get items under that
category/subcategories.
Do I have to first get a list of all subcategories
George,
can you please post a few typical
SHOW INNODB STATUS\G
outputs during the stress test.
Best regards,
Heikki
Oracle/Innobase
- Original Message -
From: "yang george" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, October 24, 2005 1:50 PM
Subject: How C
tSql = "SELECT DISTINCT(p.ship_status)
FROM products AS p
INNER JOIN cart AS i
ON i.product_id = p.id
WHERE i.session_id = " & prepSQL(tConn, tSessionID);
p.ship_status is either a "1" or a "0", which is just how the database was
set up ages, ago. I am moving thes
Is the DATE field a timestamp column?
What's your schema? What's your primary key?
I ask this because the real question is, "is it safe to assume that
new entries are for the current day it is inserted?"
If the answer to that question is yes, you can use an id field (or an
existing one) to find
OK.
I need help with the following query:
SELECT * FROM PRODUCT WHERE DATE > ? ORDER BY PRICE;
Basically find products created since a given date and order by prices.
I could put an index of DATE, PRICE but it will have to resort to a
filesort since DATE isn't a constant value.
I was thin
Hi,
We've developed an automatic email mapping capability from Google Maps
API.
To try it out, we mapped origins of emails to this group from October
3 through October 14th.
The result of this map is at:
http://www.zeesource.net/maps/map.do?group=460
Would like to hear what you think
Hi Dustin,
If this is the actual syntax as you currently have it, the single quotes
around the second occurrence of $DBPASS (in the function OLD_PASSWORD)
will be causing lots of grief to bash. You are passing literally
'$DBPASS' to the function rather than the value of the variable. Try
using dou
Dustin Krysak <[EMAIL PROTECTED]> wrote on 10/24/2005
03:14:02 PM:
> Sorry - but to add to this, the command is actually in a bash script.
> I suspect it is the single quotes and or the "()" characters
>
> Dustin
>
>
> On 24-Oct-05, at 11:57 AM, Dustin Krysak wrote:
>
> > Hi there - I am
Sorry - but to add to this, the command is actually in a bash script.
I suspect it is the single quotes and or the "()" characters
Dustin
On 24-Oct-05, at 11:57 AM, Dustin Krysak wrote:
Hi there - I am trying to issue the following command in a terminal
window... I know my syntax is sl
Hi there - I am trying to issue the following command in a terminal
window... I know my syntax is slightly off, however I can not see
what... it seems to be due to the OLD_PASSWORD function... any pointers?
mysql -u${DB_NAME} -p${DB_PASSWORD} -e"GRANT select, update, insert,
delete ON $DB
Brian Dunning <[EMAIL PROTECTED]> wrote on 10/24/2005 01:32:43 PM:
> I got it to work - turns out it was a stupid typo on my part (hate it
> when that happens - and hate wasting the list's time even more!). How
> long does this temporary table persist for - just the execution of
> the one page,
I got it to work - turns out it was a stupid typo on my part (hate it
when that happens - and hate wasting the list's time even more!). How
long does this temporary table persist for - just the execution of
the one page, or will it live on the server (using resources) until I
explicitly mak
> If you just need to select a database, you can do it while connecting to
> mysql:
>
> mysql -u${DB_USER} -p${DB_PASSWORD} ${DATABASE} -e 'update foo set bar=0'
>
> Although the other suggestions, of using semicolons or scripts, work
> as well. If it's just a one-liner, though, the above will wo
On Mon, 24 Oct 2005 [EMAIL PROTECTED] wrote:
> "Martijn Tonies" <[EMAIL PROTECTED]> wrote on 10/24/2005 10:16:21 AM:
>
> >
> >
> > > Michael Stassen wrote:
> > >
> > > > Second, no, it won't overflow:
> > > >
> > > > mysql> SELECT SEC_TO_TIME(60*60*24*5);
> > > > +-
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 10/24/2005 10:16:21 AM:
>
>
> > Michael Stassen wrote:
> >
> > > Second, no, it won't overflow:
> > >
> > > mysql> SELECT SEC_TO_TIME(60*60*24*5);
> > > +-+
> > > | SEC_TO_TIME(60*60*24*5) |
> > > +---
We are pleased to announce the release of the new DBTools Manager
Professional. This version is a bug fix with small new features, see below:
- Fixed: Dialog Box Preferences for Data Options
- Fixed: 'Invalid DateTime' on datetime columns with NULL values in
Microsoft Access
- Fixed: SetFieldNull
> Michael Stassen wrote:
>
> > Second, no, it won't overflow:
> >
> > mysql> SELECT SEC_TO_TIME(60*60*24*5);
> > +-+
> > | SEC_TO_TIME(60*60*24*5) |
> > +-+
> > | 120:00:00 |
> > +-+
> > 1 row in
> >>This translated to SQL as:
> >>
> >>select SEC_to_time(SUM(unix_timestamp(TTendTime)) -
> >>SUM(unix_timestamp(TTstartTime)))
> >>as endtime
> >>FROM TimeTracking
> >>WHERE TTperson = 1
> >>and date(TTstartTime) = '2005-10-19'
> >
> > Won't this fail if it overflows 24 hours?
> >
> > Given
Michael Stassen wrote:
Second, no, it won't overflow:
mysql> SELECT SEC_TO_TIME(60*60*24*5);
+-+
| SEC_TO_TIME(60*60*24*5) |
+-+
| 120:00:00 |
+-+
1 row in set (0.00 sec)
mysql> SELECT SEC_TO_
Hi ,
More column type problem ...The MySql Text fields arrived as General (not
readable) field in VFP via ODBC...
By: Zoltan
- Original Message -
From: Szmutku Zoltán
To: mysql@lists.mysql.com
Sent: Monday, October 24, 2005 10:36 AM
Subject: column type problem
Hi ,
I using My
mem bob wrote:
| id | model | service_id |
||---||
| 1 | 500 | 1 |
| 2 | 500 | 3 |
| 3 | 500 | 10 |
| 4 | 600 | 1 |
From this table i want to extract all distinct models which have
service_id=1 *AND* service_id=3
The JOIN-construction is something like:
SELECT `model` FR
mem bob <[EMAIL PROTECTED]> wrote on 10/24/2005 09:45:30 AM:
> Hi all,
>
> Can anyone throw some suggestions at me for this problem?
>
> | id | model | service_id |
> ||---||
> | 1 | 500 | 1 |
> | 2 | 500 | 3 |
> | 3 | 500 | 10 |
> | 4 | 600 | 1 |
>
>
> From this table i wa
Martijn Tonies wrote:
I have a table doing time tracking. I don't use timestamps, I use
datetime fields to record punch in times and punch out times. I
have this query that computes the amount of time between a punch in
and punch out:
select SEC_to_time(unix_timestamp(TTendTime) -
unix_times
Hi,
MySQL 5.0.15, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/ and mirror sites.
Note that not all mi
Hi all,
Can anyone throw some suggestions at me for this problem?
| id | model | service_id |
||---||
| 1 | 500 | 1 |
| 2 | 500 | 3 |
| 3 | 500 | 10 |
| 4 | 600 | 1 |
>From this table i want to extract all distinct models which have
service_id=1 *AND* service_id=3
What's th
> > I have a table doing time tracking. I don't use timestamps, I use
> > datetime fields to record punch in times and punch out times. I
> > have this query that computes the amount of time between a punch in
> > and punch out:
> >
> > select SEC_to_time(unix_timestamp(TTendTime) -
> unix_times
<[EMAIL PROTECTED]> wrote on 10/24/2005 12:48:32 AM:
>
> I have a table doing time tracking. I don't use timestamps, I use
> datetime fields to record punch in times and punch out times. I
> have this query that computes the amount of time between a punch in
> and punch out:
>
> select SEC_
I think there should be no problem to use the SUM() function - did you tried
it like this
select SEC_to_time(SUM(unix_timestamp(TTendTime) -
unix_timestamp(TTstartTime))) as endtime
FROM TimeTracking
WHERE TTperson = 1 and date(TTstartTime) = '2005-10-19'
HTH
--
Dobromir Velev
[EMAIL PROTECT
On 10/24/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
> On Mon, 2005-10-24 at 06:09 +0200, Dotan Cohen wrote:
> > How do I use a not operator in the WHERE clause? The obvious != and
> > NOT didn't work for me. Something along the lines of:
> > $query = "SELECT album, year FROM albums WHERE y
On Monday 24 October 2005 12:00, Bruce Martin wrote:
> Can you force it to keep the space by escaping the space?
> Something like:
>
> mysql> insert into test_strings set foo_1=' test\ ',foo_2=' test\
> ',foo_3=' test\
> ',foo_4=' test\ ';
no...doesn't work...guess i will have to use text :|
Kin
dear sir:
we develop a TPC-C test progrom,this program use mysql ODBC3.51 to
connect mysql server, and use microsoft sqlserver odbc to connect
sqlserver2000.
we suppose you are know well the TPC-C.
we use InnoDB as mysql's store engine.
follow is the os and hardware information:
os : Wind
Hi Stever, all!
Stever wrote:
Is there any reason why there isn't a source rpm for mysql 4.1.15?
A tool problem we have not yet fixed - no intention.
I am not sure whether I can look into this today.
I
need to compile my own version since (annoyingly), there doesn't seem to
be a binary rpm
Can you force it to keep the space by escaping the space?
Something like:
mysql> insert into test_strings set foo_1=' test\ ',foo_2=' test\
',foo_3=' test\
',foo_4=' test\ ';
On Oct 24, 2005, at 5:34 AM, Andreas Steichardt wrote:
Hi!
I just hit something really strange which is either a bu
Andreas Steichardt <[EMAIL PROTECTED]> wrote on 24/10/2005 10:34:08:
> Hi!
>
> I just hit something really strange which is either a bug in MySQL or a
> dumbness bug of me.
>
> I am trying to insert a string ending with a simple space and i really
want
> this space at the end of my string ;).
unscubcribe
-
Scanned for virus and spam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
I just hit something really strange which is either a bug in MySQL or a
dumbness bug of me.
I am trying to insert a string ending with a simple space and i really want
this space at the end of my string ;). Unfortunately MySQL kills this
whitespace when inserting into normal (var)char colu
Hi ,
I using MySql from Visual Foxpro cross over ODBC 3.51 .
When I run a SELECT statement then the DECIMAL 15,0 MySql field arrived to
Foxpro as Currency type with 4 digits decimals!
The data not lost (15 digits long) but ,the decimals set to 4 and column type
is Currency .
I must always
62 matches
Mail list logo
