Scott Klarenbach <[EMAIL PROTECTED]> writes:
> I'm using Mysql 5.0.7 and I've noticed the following very strange
> functionality, perhaps someone can shed some light on it for me.
Try using the "EXPLAIN" statement to get some insight into what MySQL
is thinking.
Scott.
--
MySQL General Mai
I have MySQL 4.1.12 that came on the Mandriva Linux 2006 RC1 CDs. I think
it is probably the Standard rather than the Max version. How can I tell
for sure?
The reason I am asking is because I have the MySQL Tutorial book, published
by MySQL Press and it says that I need the Max version to do
On Oct 7, 2005, at 11:46 PM, Jasper Bryant-Greene wrote:
Walt Weaver wrote:
Well, forgive me for being a bit skeptical and cynical but this
sounds like
spin to me.
As a 17-year Oracle DBA I have never seen Oracle do anything that can
remotely be called benevolent. Larry Ellison buys companie
Walt Weaver wrote:
Well, forgive me for being a bit skeptical and cynical but this sounds like
spin to me.
As a 17-year Oracle DBA I have never seen Oracle do anything that can
remotely be called benevolent. Larry Ellison buys companies, guts them,
chews them up and spits them in the gutter. I d
Well, forgive me for being a bit skeptical and cynical but this sounds like
spin to me.
As a 17-year Oracle DBA I have never seen Oracle do anything that can
remotely be called benevolent. Larry Ellison buys companies, guts them,
chews them up and spits them in the gutter. I doubt he'll ever buy a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Al Caponi wrote:
> Hi again,
> The query cache finally works after I've reverted to
> mm.mysql-2.0.12-bin.jar.
>
> The problem was that the query cache somehow wouldn't work within
> transactions with mysql-connector-java-3.1.10-bin.jar. Anyone care
Hi Hassan,
On Sat, 2005-10-08 at 08:25, Hassan Schroeder wrote:
> FYI, from the Silicon Valley Business Journal:
See Kaj's response in the announce list
(http://lists.mysql.com/announce/322) and the official MySQL AB response
(http://www.mysql.com/news-and-events/news/article_968.html).
Other re
I'm using Mysql 5.0.7 and I've noticed the following very strange
functionality, perhaps someone can shed some light on it for me.
2 Tables (Request and Inventory)
Request
id (int),
partNumber varchar(60)
Inventory
id(int),
MPN varchar(60),
MPNClean varchar(60)
I have about 1500 reque
Interesting
On 10/7/05, Hassan Schroeder <[EMAIL PROTECTED]> wrote:
> FYI, from the Silicon Valley Business Journal:
>
>
> Oracle buys Finnish open source company
>
> Oracle Corp. said Friday it has bought Innobase OY, a software company
> based in Finland, for an undisclosed price.
>
> Innobase m
FYI, from the Silicon Valley Business Journal:
Oracle buys Finnish open source company
Oracle Corp. said Friday it has bought Innobase OY, a software company
based in Finland, for an undisclosed price.
Innobase makes open source database software. Its product, InnoDB, runs
on the MySQL database
"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 10/07/2005 03:47:48
PM:
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Jonathan Mangin" <[EMAIL PROTECTED]>
> Cc:
> Sent: Friday, October 07, 2005 2:09 PM
> Subject: Re: Joining tables, duplicating none
>
>
> > "Jonathan Man
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, October 07, 2005 2:09 PM
Subject: Re: Joining tables, duplicating none
"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 10/07/2005 02:57:28
PM:
I have two tables with date and
Heikki Tuuri wrote:
Deva,
it is probably this insert operation that is stuck, and is holding an
S-latch of an index tree in emails_history_30_30:
---TRANSACTION 0 1856588555, ACTIVE 858 sec, process no 1792, OS thread
id 2445845440 inserting, thread declared inside InnoDB 318
mysql tables in
Jonathan,
>I have two tables with date and uid cols. in common.
>Table 1 has one row per date, Table 2 has a maximum
>of 7 rows per date.
>select t1.date, t1.val, t2.val from t1
>right join t2 on t1.date = t2.date
>where t1.date between '2005-08-01' and '2005-08-14'
>and t1.uid = 'me';
A right
"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 10/07/2005 02:57:28
PM:
> I have two tables with date and uid cols. in common.
> Table 1 has one row per date, Table 2 has a maximum
> of 7 rows per date.
>
> select t1.date, t1.val, t2.val from t1
> right join t2 on t1.date = t2.date
> where t1.dat
Lefteris Tsintjelis <[EMAIL PROTECTED]> wrote on 10/07/2005 03:00:29 PM:
> John McCaskey wrote:
> >
> > void *mysql_thread(void *arg) {
> >
> >mysql_thread_init();
> >
>
>pthread_setcancelstate(PTHREAD_CANCEL_DISABLE,&cancelstate);
>
> >
> >//regular mysql code and whatever else
John McCaskey wrote:
void *mysql_thread(void *arg) {
>
mysql_thread_init();
pthread_setcancelstate(PTHREAD_CANCEL_DISABLE,&cancelstate);
//regular mysql code and whatever else here
//use mysql_real_connect and mysql_real_query
//and whatever w
I have two tables with date and uid cols. in common.
Table 1 has one row per date, Table 2 has a maximum
of 7 rows per date.
select t1.date, t1.val, t2.val from t1
right join t2 on t1.date = t2.date
where t1.date between '2005-08-01' and '2005-08-14'
and t1.uid = 'me';
+-
John, You have just made sense of nearly everything. :-D
I will work with this and let you know if anything else pops up!
Hey documentarians! the functions mysql_thread_safe(),
mysql_thread_init(), and mysql_thread_end() are not listed on either one
of the C-API function overview pages but t
Sean,
First let me thank you for all the great posts and info I've seen you
put on this list for others.
I've been working in C with MySQL in a very multithreaded environment
for several years and think I can explain the thread safety issues
clearly. Rather than try to respond point by point to
You tried to respond to just one small part of my post. Thank you kindly
for the effort.
However, I am not using a *NIX environment or complier so those directions
are unintelligible to me (I explained that, too). I visited the page you
sent me and that was exactly the kind of information that
Greetings,
mySQL is thread safe, more or less.
Make sure you compile against libmysqlclient_r (or simply
ignore/handle SIGPIPE ).
Further info can be found at:
http://dev.mysql.com/doc/mysql/en/myodbc-unix-thread-safe.html
http://dev.mysql.com/doc/mysql/en/myodbc-unix-thread-safe.html
MarkP
On
Rob,
>How do I generate an error condition within a Trigger?
>This might sound a strange request to some but I'm trying to do input
>validation on an insert/update query using a trigger. If the
validation fails
>I need to set an error condition such that MySQL will not
Insert/Ammend the
>data
(please excuse the double post but I wanted to reach the two audiences I
thought could help the best)
This is a question about the interpreting the documentation in the manual
for the C API.
I searched the list archives (all lists) going back 365 days for the terms
(unquoted): "mysql_real_conne
How do I generate an error condition within a Trigger?
This might sound a strange request to some but I'm trying to do input
validation on an insert/update query using a trigger. If the validation fails
I need to set an error condition such that MySQL will not Insert/Ammend the
data. Whilst I
Is there anyway that I can get Query Browser to reinitialise it's connection
to the database without restarting?
I've been playing with MySQL 5.0.13 and everytime I crash the server I have to
restart Query Browser before I can continue which is annoying to say the
least. At least the CLI client
Tatjana Cukic <[EMAIL PROTECTED]> wrote on 10/07/2005 06:07:07 AM:
> Hi,
>
> does anybody knows how i can add a new column to
> Table1, where new column is made by substracting Col1
> from table Table1 and Col2 from Table2. Here is the
> synthax:
>
> mysql> alter table Table1 add select(x.Col1-y
Terence <[EMAIL PROTECTED]> wrote on 10/07/2005 03:49:46 AM:
> Hi All,
>
> I get a duplicate column error on 5.0.13 when creating a view. Am I
> doing something wrong here or do I submit a bug report? This should be
> allowed as the col names
> are not duplicated.
>
> Reproduce:
>
> create ta
On 07/10/2005, Erfan Shirazi wrote:
> It works fine, no errors and it seems to get correct data but the
> mysql manual and some other books doesn't mention anything about
> BETWEEN being used like this and therefor I'm not completely sure,
> anybody with any experience with my example?
I regularl
Hi,
does anybody knows how i can add a new column to
Table1, where new column is made by substracting Col1
from table Table1 and Col2 from Table2. Here is the
synthax:
mysql> alter table Table1 add select(x.Col1-y.Col2) as
differentika from Table1 x,Table2 y where
x.Col3=y.Col3;
Col3 is a primar
Hi,
I had that error for quiet a long time, and I usually restart the
transaction, but sometimes I have to do it 2 or 3 times, and I don't
really understand how it can happen.
I've strip down an example, that does basically :
BEGIN;
SELECT id FROM ttt WHERE id=7 FOR UPDATE;
INSERT INTO ttt(id) VA
Hello.
>Looks to me like a bug in the cursor handling but I'd like someone >to
confirm this.
See:
http://bugs.mysql.com/bug.php?id=13771
Rob Hall wrote:
> On Wednesday 05 Oct 2005 15:29, Jeff Smelser wrote:
>
>>On Wednesday 05 October 2005 04:05 am, Rob Hall wrote:
>>
>>>Hav
Hello.
Have you tried 'SHOW CREATE TABLE'? See:
http://dev.mysql.com/doc/mysql/en/show-create-table.html
>HI everybody
>
>I'm tryng to find a way to know if a field is a foreign key, by example
>if I run this
>
>describe ;
>
>in the "Key" colum I got "PRI" for the primary key f
Hello.
There is no Trash or something similar, but you may want to read
texts from Docs folder which is shipped with development source tree
about the internal structure of the storage engine of your table.
If you remember the keys which can identify if data presents in the
data file of the
Hello.
Among other things you'll probably do, make a bug report at
bugs.mysql.com if the problem so easy to repeat. See:
http://dev.mysql.com/doc/mysql/en/bug-reports.html
Jonathan Stockley wrote:
> Thanks for the help. I finally got to the bottom of the problem.
>
> It seems that on
Hello.
Thank you for your bug report. See:
http://bugs.mysql.com/bug.php?id=13521
This issue has been committed to our source repository of that product
and will be incorporated into the next release.
If necessary, you can access the source repository and build the latest
available ve
Hello.
Very often PREPARED STATEMENTS are helpful in similar situations. For a pity,
they are disabled in the current release. See:
http://dev.mysql.com/doc/mysql/en/sqlps.html
Leonardo Javier Belén wrote:
> Hi all,
> I am wondering if I can construct a query string inside a stored
Hello.
Rolling back a transaction might take a long time. It depends on the
size of log files. See:
http://dev.mysql.com/doc/mysql/en/innodb-tuning.html
James C Knotts wrote:
> We are having slowness issues with MySQL on Mac OS X 10.4. Here is what
> has been done...
>
> 1) Tiger's
Hello.
Perhaps master mysqld process was unable to start. If it leaves
an error log find it and check for the clues. You may want to
edit test scripts to find out the place where master mysqld is invoked
and add --log-error=[file] to it's options.
Manish Marathe wrote:
> Hello all,
Hello.
Support guys verified this bug. Thank you. See:
http://bugs.mysql.com/bug.php?id=13815
Juri Shimon wrote:
> Hello All!
>
> left(),right(),mid(),etc functions
> +
> with fixed point return value for function (or out parameter for sp)
> ---
> result has been
Hi Terence,
I guess I was a bit unclear on my comment on the
SELECT *. Anyway you did what I meant, i.e. changed
one of your category_id's so that the set
of columnnames ( as implied by the SELECT * ) becomes
unique. What happens is that your SELECT * becomes
SELECT ticket_id,category_id,category_
> > I think your problem lies in your SELECT *
> > If you look at the columnheaders below you get category_id twice.
> > I guess you have to specify your columns with aliases.
> >
> > /Johan
> >
>
> Hi Johan,
>
> Nope, if I change the column name to category_id1 then it's okay. See
> this: (apolog
Johan Höök wrote:
Hi Terence,
I think your problem lies in your SELECT *
If you look at the columnheaders below you get category_id twice.
I guess you have to specify your columns with aliases.
/Johan
Hi Johan,
Nope, if I change the column name to category_id1 then it's okay. See
this: (ap
It works fine, no errors and it seems to get correct data but the mysql
manual and some other books doesn't mention anything about BETWEEN being
used like this and therefor I'm not completely sure, anybody with any
experience with my example?
Erfan Shirazi
Application Developer, Information Te
Hi Terence,
I think your problem lies in your SELECT *
If you look at the columnheaders below you get category_id twice.
I guess you have to specify your columns with aliases.
/Johan
SELECT * FROM ticket_master tm, category_master cm
WHERE tm.category_id = cm.category_id;
+---+
On 07/10/2005, Erfan Shirazi wrote:
> I have a question about BETWEEN.
> Could it be used to look up fields which have a date between to date
> fields?
>
> Ex: '2005-10-07' BETWEEN tEffectivedate AND tExpirationdate
>
> tEffectivedate and tExpirationdate are DATE types.
What happened when you t
Deva,
it is probably this insert operation that is stuck, and is holding an
S-latch of an index tree in emails_history_30_30:
---TRANSACTION 0 1856588555, ACTIVE 858 sec, process no 1792, OS thread
id 2445845440 inserting, thread declared inside InnoDB 318
mysql tables in use 1, locked 1
1 lo
Hi all
I have a question about BETWEEN.
Could it be used to look up fields which have a date between to date fields?
Ex: '2005-10-07' BETWEEN tEffectivedate AND tExpirationdate
tEffectivedate and tExpirationdate are DATE types.
Best Regards,
--
Erfan Shirazi
Application Developer, Information
Hi All,
I get a duplicate column error on 5.0.13 when creating a view. Am I
doing something wrong here or do I submit a bug report? This should be
allowed as the col names
are not duplicated.
Reproduce:
create table `ticket_master` (
`ticket_id` int (5) NOT NULL AUTO_INCREMENT ,
`category_id
Hi all
I have a question about BETWEEN.
Could it be used to look up fields which have a date between to date fields?
Ex: '2005-10-07' BETWEEN tEffectivedate AND tExpirationdate
tEffectivedate and tExpirationdate are DATE types.
Best Regards,
--
Erfan Shirazi
Application Developer, Information
50 matches
Mail list logo
