- Original Message -
From: "Wileynet" <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 6:52 PM
Subject: NEWBIE to mysql
> Can anyone tell me why I keep getting an ERROR 1064 with this command ?
> mysql> CREATE TABLE info
> -> (
> -> name varchar(50)
> -> message varchar(2
+
| name | pass |
+---+--+
| bruce | 61ce8de3029ff1ab |
+---+--+
1 row in set (0.14 sec)
See also http://www.mysql.com/doc/en/Miscellaneous_functions.html for a
discussion of other encryption techniques, including MD5 and SHA1.
- Original Message -
From: "David & Angela Ehmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 04, 2003 11:00 PM
Subject: mysqldump ERROR 1064
> Hi
>
> I am having problems generating the mysqldump file. I have tried a range
of
> options and carefully studied sever
"Michael T. Babcock" <[EMAIL PROTECTED]> wrote,
> But MySQL doesn't guarantee correctness in time values in the first
> place. You can still insert "2002-02-31" as a date if you like
If you store a date in the database as a unix_timestamp in an unsigned int
column, and retrieve the value using t
be stored. If the date cannot be converted
| to any reasonable value, a 0 is stored in the DATE field.
| This is mainly a speed issue and we think it is up to the
| application to check the dates, and not the server.
Bruce MacDonald
Minnesota
Neal,
> I need to build a cache mechanism for a website and I thought I'd use
MySQL
> for persistance. The problem is that I need it to schedule a cleanup task
> every 24 hours - to remove old cache records. MS SQL Server provides a
> trigger for scheduling such tasks - I am looking for the func
such
problem with illegal date values.
There must be an explanation but scouring the books and manual I could not
find one.
Bruce MacDonald
Minnesota Public Radio
- Original Message -
From: "John Griffin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, D
1 row affected (0.05 sec)
mysql> select DATE_ADD(dt, INTERVAL 21 DAY) from member;
+---+
| DATE_ADD(dt, INTERVAL 21 DAY) |
+---+
| 1991-07-13 14:00:00 |
+---+
1 row in set (0.00 sec)
Bruce MacD
