Try to enumerate the different fields changing that * (the star)
select *,MAX(a.teaching_date) as max, MIN(a.teaching_date) as min from
teaching a, topic_cat b where a.teaching_topic = b.topic_id or
a.teaching_topic = 999 group by a.teaching_topic order by a.teaching_date
DESC
2007/11/8,
Marten,
Yeah, my experience has been that InnoDB is great when it's working
but a complete nightmare when it stops working. I have scripts to deal
with this which I'm actually hoping to release to the public in the
near future. Essentially, what you need to do is edit your my.cnf to
bring MySQL
Ken,
You should probably be specifying the socket for both the startup
commands and the connect commands just to be sure. Without seeing your
config files, it's hard to say much else.
Rich(ard)
On Nov 6, 2007 9:37 PM, tech user [EMAIL PROTECTED] wrote:
Hello members,
I have two mysqld run on
Hey all,
So I decided to start fresh on a test machine just to see if I could get
french characters working.
These are my steps:
Freshly Installed Mysql 5.0.45
Configure the MySql Server now
Detailed Configuration
Developer Machine
Multifunctional Database
Online Transaction Processing
Enable
Hi all,
I've inherited a PHP app that uses a MySQL database. The following query
is extremely slow and I've been battling for a couple of days on an off
to try and get a combination of indexes to optimise it. Any help would
be greatly appreciated.
select household_d.id,
what are the performance implications of different settings for
innodb_data_file_path?
if i only have one partition or filesystem, does it ever make sense to
define more than one table file?
iirc, there's some way to have a single file per table - when is this
advisable?
i've had
Yes, the trigger code is works. Many thanks !!
Now I understand the use of delimiter command. Thanks again... =)
My next question is, do we able to view the triggers that has been created ?
And how ?
David Schneider-Joseph [EMAIL PROTECTED] wrote: My apologies, try this:
DELIMITER ;;
CREATE
--- mysqlman [EMAIL PROTECTED] wrote:
I am attempting to get a simple query working:
select *,MAX(a.teaching_date) as max,
MIN(a.teaching_date) as min from
teaching a, topic_cat b where a.teaching_topic =
b.topic_id or
a.teaching_topic = 999 group by a.teaching_topic
order by
Hi James,
set these and try again
set session collation_database=latin1_swedish_ci;
set session character_set_database=latin1;
regards
anandkl
On 11/9/07, James Sherwood [EMAIL PROTECTED] wrote:
Hey all,
So I decided to start fresh on a test machine just to see if I could get
french