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
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
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]
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 ;).
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
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
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
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
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
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
<[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 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 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
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
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
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
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
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
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_
> >>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
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
"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) |
> > > +---
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);
> > > > +-
> 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
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
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,
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
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
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
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
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
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
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
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
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
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
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 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
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 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
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
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
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
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
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
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
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
>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
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
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
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
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
[EMAIL PROT
(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
[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
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
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
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
>
>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
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
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
62 matches
Mail list logo
