Columns that are UNIQUE or indexed *MUST* be defined as NOT NULL
(e.g.: 'nombre INT NOT NULL')
Michael
On Fri, 3 May 2002, Shows Lycos wrote:
>
> Description:
> error =
> Column 'nombre' is used with UNIQUE or INDEX but is not defined as NOT NULL
>
> My server=
> mysql Ver 9.38 Distrib
Technically speaking, TCP/IP communication *is* a form of IPC.
IPC isn't restricted to semaphores or message queues, etc.
I think that's what he meant (i.e.: mysql client on one box communicating
via TCP/IP to a MySQL server on another box).
Michael
On Wed, 1 May 2002, Gelu wrote:
> Hi,
> A
Hmm. How about:
SELECT *
FROM tablename
WHERE LENGTH(somecolumn) > 0 AND ISNULL(othercolumn) != 1
Michael
On Mon, 29 Apr 2002, Andrew Kuebler wrote:
> I want to query records that do not contain empty strings and null
> values through a SELECT statement.
>
> IS NOT NULL works for the
To my knowledge, nothing would happen to the existing data,
since you would be performing a "widening conversion."
Michael
On Sun, 28 Apr 2002, Anthony Rodriguez wrote:
> I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field.
>
> What would happen to the existing data in MySQ
> For example, have you called mysql_thread_init() before calling
> mysql_real_connect() in all your threads ?
However, to my understanding, mysql_thread_init() is not needed if
only one database connection is used, and that database connection
is established when the program starts, before any
> I am not sure if the include statement is design to add mysql BINARIES or
> SOURCE CODE ??
Neither. It's eventually going to link the final php binary with
the mysql shared libraries (probably libmysqlclient).
I'm not too familiar with PHP, so I don't know if '--with-mysql=' wants
the location
Hi all,
Does anyone know where I could get all of the source
code to build the MySQL software? I wanted to make
edits to the SQL language that is embedded in the
MySQL software. Is there a way to do that? If not,
does anyone have any suggestions on how to do
something like that. I want to use