The reporting of two rows thing is to do with how MySQL handles
INSERT ... ON DUPLICATE KEY UPDATE ... statements; it will report 1 row
if it inserts, and 2 rows if it finds a duplicate key and has to update
as well.
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
Just after the f
Michael Dykman wrote:
It
worked fine as you wrote it on my v5.0.45, although it reported 2 rows
affected on each subsequent run of the insert statement. I thought
this odd as I only ran the same statement repeatedly leaving me with
one row ever, but the value updated just fine.
I noticed
You might try explicitly formatting your date as the string-type you
are expecting, but it looks to me like it should wokr exactly as you
have it. I would agree with your suspicion about your v5.0.37. It
worked fine as you wrote it on my v5.0.45, although it reported 2 rows
affected on each subseq
I think you are missing the data type for spdate_updated.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
Your missing your data type for the spdate_updated attribute
CREATE TABLE tbl_spdate(
spdate_ID int NOT NULL PRIMARY KEY AUTO_INCREMENT , spdate_date date NOT
NULL , spdate_notes varchar( 100 ) , spdate_created timestamp default 0,
spdate_updated timestamp default CURRENT_TIMESTAMP ON UPDATE
CURRE
> mysql> create table ABC (col1 varchar(10));
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> show tables;
> +--+
> | Tables_in_userdb |
> +--+
> | abc |
> +--+
> 1 row in set (0.00 sec)
>
> mysql>
>
> NOTE THE FACT THAT THE TABLE IS
Hello.
>queries will likely be spaced out by hours or days (idle disconnect?)
How long does it take to establish a new connection? If the time
is large enough, may be you should make a temporary connection and
close it after timeout. If you deside to use a persistent connection,
don't for
Hi,
Try to use the same version of php in Solaris as in Windows.
Li
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Monday, January 17, 2005 3:24 AM
To: mysql@lists.mysql.com
Subject: Re: repost w/code : can mysql work in Windows but not Solaris?
Hello
Hello.
Can you succesfully execute your query in mysql client program on your
solaris server?
"leegold" <[EMAIL PROTECTED]> wrote:
> Is there any reason you can see why the fulltext php/mysql code below
> works OK on my win2k php4.3.6. mysql 4.1.3 pc but does *not* work when
> put on
At 8:02 -0500 3/6/04, David Jackson wrote:
I'm reposting this question, the online manual doesn't address that quetion:
http://www.mysql.com/doc/en/DROP_TABLE.html
Yet, it's a question asked by 3 different comments posted on the manaul
page listed above. Also please post a solutons to the manual pa
OK. I've made some progress. It looks like just doing --with-openssl
doesn't work. You have to specify both the includes and the libs as
well. So, this is what I'm using now:
./configure --with-openssl
--with-openssl-includes=/usr/local/ssl/include
--with-openssl-libs=/usr/local/ssl/lib --
Mark Matthews wrote:
According to 4.4.10.2 Requirements, have_openssl must be YES prior to
setting up certificates. Is this in error?
Sorry, I missed that small fact.
What does the file include/my_config.h say about #define HAVE_OPENSSL
(it's generated by 'configure').
/* OpenSSL */
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg G wrote:
>
>
> Mark Matthews wrote:
>
>> Greg G wrote:
>>
>>
>>> I'm still having trouble figuring this out. Please help!
>>>
>>> I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
>>> variables with mysqladmin, "has_openssl
Mark Matthews wrote:
Greg G wrote:
I'm still having trouble figuring this out. Please help!
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, "has_openssl" is set to "NO". I've got
OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg G wrote:
>
> I'm still having trouble figuring this out. Please help!
>
> I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
> variables with mysqladmin, "has_openssl" is set to "NO". I've got
> OpenSSL 0.9.7c installed. I'm
I'm still having trouble figuring this out. Please help!
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, "has_openssl" is set to "NO". I've got
OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian
hosts. I'm not seeing any erro
You have the first inequality backwards. You want:
SELECT percentage FROM table_name
WHERE min <= 500.00 AND max >= 500.00
Michael
Mike Blezien wrote:
Sorry..
The query should be:
select percentage from table_name where
min >= 500.00 and 500.00 <= max;
database.
Original Message
Hi!
On Jun 13, H M Kunzmann wrote:
> The answer is that a fulltext index can only be built on
> a TEXT field. Even though the mysql documentation describes
> MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
> they can not be used.
No, this is wrong.
Any xxxTEXT field can be
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
On Thu, 2003-06-05 at 09:59, H M Kunzmann wrote:
> Hello All.
>
> I am using Redhat
> > When mysql is indexing You can check your data file direcory and You
> > ca see that one file (the index) is growing in size.
> I see it grow up to 8M and it stays there.
Watching this, it grows very slowly. After 5 minutes of indexing, the
file size has barely hit 2MB.
> > The command I use
> I think your index is corrupted because I expect a 1.5 GB index and not 8M!
> You can see word list wit a utility (sorry I don't remember te name ft_dump).
I agree with this :-)
> I suggest You to drop fulltext index, duplicate database and remove
> some rrecords.
> Then create index index aga
create fulltext index Name on Table(field) i didnt get this
i usually do add fulltext field (field) i think , is that wrong ??
-Original Message-
From: Santino [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 6:14 PM
To: [EMAIL PROTECTED]
Subject: Re: REPOST: FULLTEXT searching
I think your index is corrupted because I expect a 1.5 GB index and not 8M!
You can see word list wit a utility (sorry I don't remember te name ft_dump).
I suggest You to drop fulltext index, duplicate database and remove
some rrecords.
Then create index index again.
Some questions:
Do You have d
On Tue, 2003-03-11 at 07:33, Richard Taubo wrote:
>
> When using the Union statement in MySQL, is it possible to retrieve the
> corresponding table name for a given row? The reason I need to know
> this is that I present info from different tables in their own way. I
> know I can create a colum
Hi Benjamin,
I hope you have a nice day.
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Jason Maskell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 1:14 PM
Subject: Re: REPOST: MySQL 3.23.54 is a
On Mon 2003-02-17 at 12:14:12 +0100, [EMAIL PROTECTED] wrote:
[...]
Please disregard this mail. It was not supposed to go to the list.
(forgot to remove the CC that my mailer is set up to automatically
append for mails going to my -mysql address).
My apologies about that, Jason.
Bye,
B
son Maskell" <[EMAIL PROTECTED]>
> Sent: Monday, February 17, 2003 3:35 AM
> Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.
>
>
> > On Mon 2003-02-17 at 02:40:57 -0600, [EMAIL PROTECTED] wrote:
> >
quot;Zak Greant" <[EMAIL PROTECTED]>
To: "Jason Maskell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 2:10 AM
Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.
> On Mon, Feb 17, 2003 at 01:37:59AM -0600, Jason Mask
On Mon, Feb 17, 2003 at 01:37:59AM -0600, Jason Maskell wrote:
> Perhaps the subject will get someone to actually read this and offer even
> one reply with a suggestion?
I admit that the topic got my attention - perhaps not in the best way
though.
I can offer a few suggestions:
Provide m
Is there a master.info file somewhere?
What's your my.cnf look like?
If you want, you can email me the file and I'll be happy to try and
help.
--
sh
On Thu, 2002-03-28 at 10:40, Jonathan Wilzig wrote:
> Sorry to repost. I got one answer and stumped the guy trying to help (thanks
> again btw).
Hi,
On 13 Feb 2002, at 12:44, Henning Sprang wrote:
> Was something wrong with this post or is it really such a weird
> problem that there is neither a solution nor anything i could do to
> solve it, nor anything i could do to find out more about it?
Well. Replication is somewhat weird. ;-)
> Sl
At Sun, 06 Jan 2002 14:55:53 +0200, [EMAIL PROTECTED] wrote...
:
: Hi!
:
: > "fil" == fil krohnengold <[EMAIL PROTECTED]> writes:
:
: fil> [gcc version 2.95.2; mysql 3.23.47]
:
:
: fil> ctype.lo dbug.lo -lz -lcrypt -lgen -lsocket -lnsl -lm
: fil> rm -fr .libs/libmysqlclient.la .libs/lib
TECTED]]
> Sent: 02 October 2001 19:08
> To: Colin Faber
> Cc: Robin Keech; [EMAIL PROTECTED]
> Subject: Re: repost: Too many open files
>
> Colin Faber wrote:
>
> > it sounds like you've run out of file descriptors, I suggest
> > rebuilding your kernel
Colin Faber wrote:
> it sounds like you've run out of file descriptors, I suggest
> rebuilding your kernel to handle more.
>
> In a bsd kernel you can do this simply by upping the maximum number of
> users allowed to access the machine at any given time.
Or in Linux (in my rc.local):
echo "Set
it sounds like you've run out of file descriptors, I suggest
rebuilding your kernel to handle more.
In a bsd kernel you can do this simply by upping the maximum number of
users allowed to access the machine at any given time.
Robin Keech wrote:
>
> Hi,
>
> Any help would be greatly appreciat
I am not sure it that would provide everything you want to know, but I was
looking for the same thing last week and I setup this replication database
and it work great and make it very easy.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Replication
"Thalis A. Kalfigopoulos" wrote:
> Check you don't have empty strings as empty remarks, but that you have NULLs.
> Even with empty strings as remarks though you can bypass them with an extra WHERE
>condition :-)
That was it. I was storing empty strings, instead of NULLs. Thanks!
AMK4
On Thu, 5 Apr 2001, Ashley M. Kirchner wrote:
> "Thalis A. Kalfigopoulos" wrote:
>
> > > +--++--+-+
> > > | task | comment |remarks | history |
> > > +--++--+-+
> > > | task_1 | cmt_1
"Thalis A. Kalfigopoulos" wrote:
> > +--++--+-+
> > | task | comment |remarks | history |
> > +--++--+-+
> > | task_1 | cmt_1| rmk_1| |
> > | task_1 | cmt_2
On Wed, 4 Apr 2001, Ashley M. Kirchner wrote:
>
> Db -> table1, table2 and table3
>
> SELECT table1.task, table2.comment, table2.remarks, table3.history
> FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
> LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
>
> Resul
40 matches
Mail list logo
