Ooh. I can from cmd-line not set any variable not listed there.
That explains it all.
Yes, I will put the command in the script-file instead then.
Thanks alot.
/Mattias
sheeri kritzer wrote:
I don't know what version you're running, but a
mysql -?
will show you the variables you can set.
Hi,
I need to upgrade a server from Solaris 8 to Solaris 10. There is one
MySQL server running on it, (the binary
mysql-standard-4.1.15-sun-solaris2.8-sparc from mysql.com), do I need
to upgrade MySQL as well ? (to
mysql-standard-4.1.x-sun-solaris2.10-sparc ?)
--
MySQL General Mailing List
For
Hi,
Just yesterday I have finished doing something very similar
( Apache+PHP+MySQL+Database+PHP-Application ) installer
for a demo site. The setup installs the Apache service, the MySQL
service and database and start the services. On unistall it removes
the services, leaving all clean. The idea
Hello,
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zeros. I've tried
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zeros. I've tried all
Hi,
If you are installing in windows only thing you run the setup.exe ,after
the installation
is completed it will prompt for you a default user password that is root
(password).
and also to create anonymous user.
Jim wrote:
Hi All,
Does anybody have some advise on automating the
On Tuesday 16 May 2006 02:16 am, Philippe Poelvoorde wrote:
Hi,
I need to upgrade a server from Solaris 8 to Solaris 10. There is one
MySQL server running on it, (the binary
mysql-standard-4.1.15-sun-solaris2.8-sparc from mysql.com), do I need
to upgrade MySQL as well ? (to
Hello,
MySQL 4.1.12
trying to figure out why I keep getting this error with the following query:
SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS mins
FROM account a LEFT JOIN calls c ON c.account_id = a.id
WHERE c.calldate = DATE_SUB(NOW(),INTERVAL 14 DAY) AND c.agent_id =
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 1:29 PM
Subject: Baffled by error
Hello,
MySQL 4.1.12
trying to figure out why I keep getting this error with the following
query:
SELECT
At 12:29 -0500 16/5/06, Mike Blezien wrote:
trying to figure out why I keep getting this error with the following query:
SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS
mins FROM account a LEFT JOIN calls c ON c.account_id = a.id WHERE
c.calldate = DATE_SUB(NOW(),INTERVAL 14
Is because in your select you have c.accound_id and in your group by clause
you have a.accound_id
Try this:
SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS mins
FROM account a LEFT JOIN calls c ON c.account_id = a.id
WHERE c.calldate = DATE_SUB(NOW(),INTERVAL 14 DAY) AND
Tried that, still same error. If I remove the 'AND
SUM(c.agent_product_time) = '500'
then it works, but I need this in the query.
Mike
- Original Message -
From: Ing. Edwin Cruz [EMAIL PROTECTED]
To: 'Mike Blezien' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Tuesday,
corrected it and still the same error.
Mike
- Original Message -
From: Chris Sansom [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]; MySQL List
mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 12:56 PM
Subject: Re: Baffled by error
At 12:29 -0500 16/5/06, Mike Blezien wrote:
Mike Blezien wrote:
Hello,
MySQL 4.1.12
trying to figure out why I keep getting this error with the following
query:
SELECT c.account_id,a.name,a.company,SUM(c.agent_product_time) AS mins
FROM account a LEFT JOIN calls c ON c.account_id = a.id WHERE
c.calldate = DATE_SUB(NOW(),INTERVAL 14
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]; MySQL List
mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 1:56 PM
Subject: Re: Baffled by error
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
To: MySQL List
Peter,
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 1:07 PM
Subject: Re: Baffled by error
Mike Blezien wrote:
Hello,
MySQL 4.1.12
trying to figure out why I keep
Mike,
How would this query be constructed with the HAVING clause,
not real fimilar with this type of clause.
SELECT
a.id,
a.name,
a.company,
SUM(c.agent_product_time) AS mins
FROM account a
LEFT JOIN calls c ON c.account_id = a.id
WHERE c.calldate = DATE_SUB(NOW(),INTERVAL 14 DAY)
AND
I'm fairly new to all this and duing everything step by step...
I made my first (test) php site - and it works... then, i have this script
where i'm supposed to find out if MySQL and PHP talk with each other. and
there i get the answer
Error 2002: Can't connect to local MySQL server through
Peter,
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Mike Blezien [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 1:25 PM
Subject: Re: Baffled by error
Mike,
How would this query be constructed with the HAVING clause,
not real
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zeros. I've
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zeros.
Jonathan Mangin wrote:
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Jonathan Mangin [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 3:08 PM
Subject: Re: Converting varchar field into primary key
Jonathan Mangin wrote:
I'm creating a new MySQL database from an
I've got a backup that is scheduled by MySQL Administrator, which appears to be
happening without a problem. However, I just tried to restore that backup on
my machine, and the data doesn't appear to be restoring properly. The original
database was on our web server, where the backup occurs
What does your script look like? Code?
Ed
On May 13, 2006, at 5:46 PM, Steve wrote:
I'm fairly new to all this and duing everything step by step...
I made my first (test) php site - and it works... then, i have this
script
where i'm supposed to find out if MySQL and PHP talk with each
Try this
SELECT c.account_id,
a.name,a.company,
SUM(c.agent_product_time) AS mins
FROM account a
LEFT JOIN calls c
ON c.account_id = a.id
WHERE c.calldate = DATE_SUB(NOW(),INTERVAL 14 DAY)
AND c.agent_id = 9
GROUP BY a.account_id
HAVING
Hi.
call this function, phpinfo(); in a *.php file.
That should return alot of usesfull info.
Make sure the mysql extension is being loaded.
If so check the value of the following php config var:
; Default socket name for local MySQL connects. If empty,
; uses the built-in ; MySQL defaults.
Gordon,
thank you, works prefectly now.
Mike
- Original Message -
From: Gordon [EMAIL PROTECTED]
To: 'Mike Blezien' [EMAIL PROTECTED]; 'MySQL List'
mysql@lists.mysql.com
Sent: Tuesday, May 16, 2006 3:17 PM
Subject: RE: Baffled by error
Try this
SELECT c.account_id,
28 matches
Mail list logo