however will prevent you from
inserting invalid dates in the first place.
Greets
Rocco
|
Mark wrote:
Dear MySQL-ers,
Using MySQL 4.1.20, in the function DAYOFWEEK(), why does MySQL accept a
bogus date like '2006-02-30'? It says the 30th of February (yeah, right)
starts on a the 5th d
+
| condition1 | condition2 |
+++
| B | NULL |
| C | NULL |
+++
2 rows in set (0.00 sec)
Maybe check again the Table definition. There is nothing wrong with with
Queries you have posted in your message.
Greets
Rocco
Evert wrote:
Hi!
I&#
Hello Evert,
i actually do not know and don't have access to a 4.1 Machine. What you
could try is to use the alternative way of testing if a value is NULL:
Maybe the behavior of IS NULL has been changed in 5.0 .
DELETE FROM table1 WHERE condition1='A' AND condition2<=&
table in the database you like to import the
records to. Depending on the delimiters you use to separate fields in
your text file, you have to set appropriate options. The documentation
on what options you have to use for type of data file can be obtained on
mysql.com.
Greets
Rocco
Neil
in the first place?
Greets
Rocco
Evert wrote:
Hi!
I tried your tip, but <=> gives the same result as = when I execute
the query... :-/
Regards,
Evert
Rocco wrote:
Hello Evert,
i actually do not know and don't have access to a 4.1 Machine. What
you could try is to use the a
would
be frequent with the tables I am going to use.
Is there something I am missing with SQL syntax?
Thank you,
Rocco Castino
M.C.S. Computer & Software S.r.l.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
=3306
socket=/tmp/mysql.sock
#server 2 option file
port=3406
socket=/tmp/mysql2.sock
Greets
Rocco
On 10/13/06, Low Kian Seong <[EMAIL PROTECTED]> wrote:
Dear all,
I am trying to run two mysql instances on one server using the
mysqld_multi command. Attached is my configuration file. Th
location
Option 3 is probably what you want to do.
greets
Rocco
On 10/13/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
On Thu, 2006-10-12 at 23:43 -0500, Brian Ivins wrote:
> If the tables are myisam (not innodb), and you're moving them to a
system with the same or newer version
advanced libraries compiled into the distributions other
than the ones your OS might use when compiling
4. In my Opinion it is easier to upgrade a pre-compiled package via your
operating systems upgrade system (e.g. FreeBSD Portmanager)
Greets
Rocco
--
New Identity AG
<http://www.newidentity.de>
