You could install version 3.23 under a different username (like mysql323)
than the 4.0 version (like username mysql40).
Then put each .my.cnf in the ~ directory.
Regards,
Peter Sap
- Original Message -
From: "Arnoldus Th.J. Koeleman" <[EMAIL PROTECTED]>
To: <[EMA
When you do a mysqld -? it will say:
Default options are read from the following files in the given order:
/etc/my.cnf /var/lib/mysql/my.cnf~/.my.cnf
So that's the reason you can not start it anymore. (I'm using 4.1.0-alpha.)
Hope this helps.
Peter Sap.
- Origin
Hi Chris,
Please tell me why a group by with a having shouldn't work in this case.
I tested it with a small table and it works fine, at least in this case.
Peter Sap.
- Oorspronkelijk bericht -
> Van: "Chris" <[EMAIL PROTECTED]>
> Aan: "List: MySQL&
, try switching to InnoDB (row locks in stead
of page locks) and take another look at the tranactions themselve like the
sequence of insert/delete/update/select.
Hope this helps.
Peter Sap.
- Original Message -
From: "Mike Gollub" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi Yves,
You can use a having clause to work with groups:
select grp, max(id) as maxid
from tbl
group by grp
having maxid = max(id)
Regards,
Peter Sap
- Original Message -
From: "Yves Goergen" <[EMAIL PROTECTED]>
To: "List: MySQL" <[EMAIL PROTECTED]>
S
an
extra condition to the where clause.
Please check the use of < and >, I didn't pay much attention to that.
Hope this helps
--
Peter Sap
- Original Message -
From: "Olaf van Zandwijk" <[EMAIL PROTECTED]>
To: "Peter Sap" <[EMAIL PROTECTED]>; <[EMA
handling this.
--
Peter Sap
- Original Message -
From: "Nathan Jones" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 4:16 AM
Subject: Merging duplicate rows
> How do you merge duplicate rows? All rows involved contain identi
Hi Olaf,
try something like this:
AND gebdatum between now() and date_add(now(),interval 7 day)
However, I have no idea if this can be done with 3.23.49a.
--
Peter Sap.
- Original Message -
From: "Olaf van Zandwijk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sen
You start a transaction but you insert into a non-transactional table
(probably MyISAM).
Change your table type into InnoDB or DBD and it will work.
Peter Sap
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Frida
You could try to use MERGE tables to get around this problem.
Put all your data in several MyISAM tables and create a merge table on top
of them.
Peter Sap.
- Original Message -
From: "Niran Angkawattanawit" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL
As far as I know no locking will be done, unless you use the --lock-tables
flag: the tables in a database are locked before the dump starts.
When using InnoDb, use the flag --single-transaction to get a consistent
snapshot of your database.
Peter Sap
- Original Message -
From: "Paul
Try something like this:
select Screen_Name,count(*)
from MBoard
where Message_Date>='2003-11-00'
group by Screen_Name
order by 2 desc
limit 5;
Peter Sap
- Original Message -
From: "Daniel Harik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
Sybase sites and everybody says that the query
performance is very good. You can run into problems when loading data: only
one session at a time can update a single table (many readers but only one
writer)
Peter Sap
- Original Message -
From: "Chris Nolan" <[EMAIL PROTECTED]
13 matches
Mail list logo
