guys,
strange things happen when using COUNT() in subqueries. even the use of
HAVING in a SELECT statement turns up a weired result, as it should work
on the result set and should be filtered while rows are returned to the
client.
(you can find the selects and stuff in a more readable way on
For a long time, we've been recording changes to MySQL software in the
Change History section of the MySQL Reference Manual. People familiar
with the MySQL server will probably enjoy looking at the first change
history section from July 1999,
trying to revive an old thread for fun...
I inherited a system in which the code was writing the string NULL
into
a
CHAR field.
This is what happens when one of the most innovative concepts of SQL
gets overlooked
or understressed which it seems to be in most modern SQL books.
The thing is
I am running mysql version 5.0.24 and am seeing this error when running
mysqldump.
From what I can find on the web, this message is generated by an error in the
mysql code.
Please correct me if I am wrong.
Is this fixed in mysql 5.0.27 ?
Thanks,
Connie Logg, Network Analyst
Stanford Linear
The result of all but two expressions will be NULL (not 0 or 1) if either
side is NULL. The two exceptions are the operators IS NULL and IS NOT NULL.
SELECT NULL = NULL; /* result is NULL */
SELECT NULL IS NULL; /* result is 1, or TRUE */
SELECT NULL IS NOT NULL; /* result is 0, or FALSE */
I have a table like so:
enrollments
-
ID - INT
Name - VARCHAR(45)
DateOfBirth - DateTime
The DateOfBirth field should be optional and allow NULLs if there is
nothing present.
How do I do this in my INSERT?
I've tried:
INSERT INTO
This always happens to me. I end up solving my own problem a second
after I hit the send button to the mailing list.
The answer was that I needed single quotes around my first parameter
'{date_of_birth}' like this:
INSERT INTO enrollments (Name, DateOfBirth)
VALUES ('Joe', (SELECT
I think this question has been asked, but I have not yet found an answer
to the problem.
I'm running MySQL 5.0.22 on Gentoo Linux AMD 64. Its blazingly fast,
mostly. I'm running a package called dbmail on it.
http://www.dbmail.org. All mail is stored in the database. After running
a
It's normal for space to not be reclaimed from the InnoDB file, yes.
You could change your setup to use the 'innodb_file_per_table' option
to change the behavior; with that in effect, deletes/dropped tables
etc will lead to reclaimed space after optimizing.
However, you'd also have to either
All,
Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe
and nothing seems to happen.
I have intalled
1) webserver-Apache2
2) MySql-41.1
I want to use PHP as sever side scripting.
Cheers,
Renish.
--
MySQL General Mailing List
For list archives:
On Wednesday 15 November 2006 18:14, Renish wrote:
Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
php.exe and nothing seems to happen.
I have intalled
1) webserver-Apache2
2) MySql-41.1
Please read the documentation before asking questions such as these. Thanks.
Try http://www.php.net/manual/en/install.windows.php
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
I have a database with roughly the following structure:
album
--
albumid INT
title VARCHAR(255)
artist
--
artistidINT
nameVARCHAR(255)
albumartist
--
albumid INT
artistidINT
From the above,
Ocourse i read the manual . I was unable to do so..ie the reason I asked...I
also knew this location mysql@lists.mysql.com
- Original Message -
From: Joshua J. Kugler [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: Renish [EMAIL PROTECTED]
Sent: Thursday, November 16, 2006 11:20 AM
Hi Renish,
Perhaps these might be a more appropriate forum and also get you the
result you need. This being a database list (I'm sure there are php
experts on here) is probably not quite the right place to be asking. One
of the php lists may produce a more relevant response.
This showed up in 'show processlist' and it had had an active time of about 4
days. Numerous other inquiries were hung behind it, although the other
inquiries completed eventually...but they were so slow as to backup the data
base entry code and extraditions for the analysis by several hours.
Thank you very much..excellent support
- Original Message -
From: Logan, David (SST - Adelaide) [EMAIL PROTECTED]
To: Renish [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com; Joshua J. Kugler [EMAIL PROTECTED]
Sent: Thursday, November 16, 2006 12:16 PM
Subject: RE: Urgent please..
Hi
I am getting this error when installing a db:
An error occurred while trying to build your MySQL
database tables. The errors were: 'Invalid default
value for 'AttachmentID'
Invalid default value for 'MapID'
Invalid default value for 'ServerSendID''. Click on
the Try Again button below to try
John wrote:
I am getting this error when installing a db:
An error occurred while trying to build your MySQL
database tables. The errors were: 'Invalid default
value for 'AttachmentID'
Invalid default value for 'MapID'
Invalid default value for 'ServerSendID''. Click on
the Try Again button
19 matches
Mail list logo