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 be
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 aga
Thank you very much..excellent support
- Original Message -
From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>
Cc: ; "Joshua J. Kugler" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2006 12:16 PM
Subject: RE: Urgent please..
Hi Renish,
Perhap
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.
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.
http://www.php.net/ma
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:
Cc: "Renish" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2006 11:20 AM
Subject: Re: Urgen
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, y
Try http://www.php.net/manual/en/install.windows.php
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_
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.
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: http://lists.mysql.com
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 drop
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 dbmail-ut
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 IF(LENGTH
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 enrollm
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 */
Regar
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
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 i
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,
http://dev.mysql.com/doc/refman/4.1/en/news-3-23-0.html.
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
http
19 matches
Mail list logo
