Im sorry if this classified as OOT
One example of the confussion
C Header File declaration of statement handler (taken from the 4.1.3)
typedef struct st_mysql_stmt
{
MEM_ROOT mem_root; /* root allocations */
LIST list; /* list to keep track of all
Hi All,
I am hoping to implement a simple MySQL client on a PIC18 microcontroller. Basically
the client will need to connect to a server
upload some data and then disconnect. My current stumbling block is the handshaking
involved in establishing a connection. I would
like to find an RFC or
I'm maintaining 2 instances of MySQL running as slave/master on the same
machine. I was asked to install MaxDB on the slave server for testing...
The purpose of this post is for clarification... is MaxDB it's own db
instance or does it need MySQL running already running...
Depending on that
Scott Haneda wrote:
I often find I am using a field called 'status' and almost always store
boolean 1 or 0 in it, sometimes I may need a 2 or 3, but never greater than
9 for sure
For storing status codes, I would suggest using an enum type. You can
give it understable status codes and can even
Scott,
The bottom line is that LAST_INSERT_ID() isn't guaranteed to be unchanged by
an INSERT IGNORE that doesn't insert anything, so you have to do something
else.
You need to test that a row was, in fact, inserted by the first INSERT
IGNORE and, if not, do not execute the second INSERT.
If
Hi
When building my server I came across a similar situation. The .10 and
.14 are builds of the same library but are complied using a different C
library when building the kernel. If your kernel was built and needs .14
you should be able to find builds for your kernel. In the end, I tried
Hello,
MySQL version 4.0.20
I'm trying to figure out, if it's possible to do, with one query to update a
single table.
Query #1
select m.memid from members m left join active a
on a.memid = m.memid where a.acct_days 0 and m.account = 1;
Query # 2
update members set account = 2 where memid in
Hello,
I'm quite new to mysql so I apologize if my question seems stupid. I hope it
is the right mailing list for that question.
I'm using the mysql embedded library (libmysqld) with a small c++ program.
This program created a new database in its directory and I would like to use
this
Hi, I managed to install MySQL on Linux but now I can't find mysql.sock either on my
machine or on the CD. how do I create or find mysql.sock?
First, I think the LEFT JOIN is unnecessary. Rows in members without a
corresponding row in active will not have acct_days0 (it'll be NULL), so,
by using LEFT JOIN you are (possibly) creating rows only to discard them. I
think a simple join will do.
You want a multi-table update:
UPDATE
Kevin's approach is much cleaner. If you have so many OR statements in a query then
Kevin's approach saves lots of string to be parsed by MySQL's query processor.
Thanks,
Hardik
Kevin Ward [EMAIL PROTECTED] wrote:
Paul,
You can do the following:
SELECT * FROM tablename WHERE columname IN
Michael Stassen wrote:
First, I think the LEFT JOIN is unnecessary. Rows in members without a
corresponding row in active will not have acct_days0 (it'll be NULL),
so, by using LEFT JOIN you are (possibly) creating rows only to discard
them. I think a simple join will do.
You want a
Original Message
Subject: Re: mysql.sock
From:Jonathan Villa [EMAIL PROTECTED]
Date:Sat, July 24, 2004 1:42 pm
To: Levi Campbell [EMAIL PROTECTED]
--
Levi
it's not in /tmp, /var/lib/mysql or anywhere on my system. could someone please e-mail
the file to me?
- Original Message -
From: Jonathan Villamailto:[EMAIL PROTECTED]
To: Levi Campbellmailto:[EMAIL PROTECTED]
Sent: Saturday, July 24, 2004 12:42 PM
Subject: Re: mysql.sock
mysql.sock is created when mysqld starts and exists only while it runs.
B.
-Oorspronkelijk bericht-
Van: Levi Campbell [mailto:[EMAIL PROTECTED]
Verzonden: zaterdag 24 juli 2004 20:53
Aan: [EMAIL PROTECTED]; mysql
Onderwerp: Re: mysql.sock
it's not in /tmp, /var/lib/mysql or
I tried running the create index again using --verbose but this is all I
got:
ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STLd39Et'
(Errcode: 27)
--
CREATE INDEX timeindex ON internet_usage (uid,time)
--
Bye
Can anyone tell me the specifics of what happens
If I search on:
BT-1034.06
I get returned:
BT-1034.02
BT-1034.03
BT-1034.05
...
BT-1034.11
If I put in ie. BT-1034.06
I only get BT-1034.06 returned.
The BT- part seems irrelevant.
But I don't understand the results.
Why so many returned? Seems like 1034.06
w/out the is unique enough. Is '.' a
Adrien Saladin wrote:
Hello,
I'm quite new to mysql so I apologize if my question seems stupid. I hope it
is the right mailing list for that question.
I'm using the mysql embedded library (libmysqld) with a small c++ program.
This program created a new database in its directory and I would
From the manual http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html:
MySQL uses a very simple parser to split text into words. A word is any
sequence of characters consisting of letters, digits, ', or _. Some
words are ignored in full-text searches:
Any word that is too short is ignored...
.
I'd like to ask some questions regarding a work-around
for
bug #861, a configure problem preventing installation
on mac os x.
Status on bug is currently Need Feedback. Any
suggestions on
how to route questions to bug author and/or the
developer?
Thanks.
Ron
[EMAIL PROTECTED] said:
From the manual
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html:
MySQL uses a very simple parser to split text into words. A word is any
sequence of characters consisting of letters, digits, ', or _. Some
words are ignored in full-text searches:
Any
You could select the Add Comment tab on the bug report to add feedback, if
you wish, but that bug report is a year old, and it's for version 4.0.13. I
cannot be 100% certain, but I'd bet that it was the same bug I reported on
this list for 4.0.15, which was fixed in 4.0.16. You can read the
leegold wrote:
[EMAIL PROTECTED] said:
From the manual
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html:
MySQL uses a very simple parser to split text into words. A word is any
sequence of characters consisting of letters, digits, ', or _. Some
words are ignored in full-text searches:
Any
23 matches
Mail list logo