I think your INSERT syntax is wrong. There is no "TABLE" in the syntax.
It has to be INSERT INTO admin VALUES .
- Shanta
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: ENCRYPT Synt
, ensure the number of columns your inserting
match the schema of the table - if not explicitly specify the columns.
Regards,
Adam
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 3:03 PM
To: [EMAIL PROTECTED]
Subject: ENCRYPT Syntax problem
Dear list:
I`m trying to insert some values into my table but I received a error
message when I type::
INSERT INTO TABLE admin VALUES ('admin',ENCRYPT('system'),15,0);
The error said:
Error 1064: You have an error in SQL syntax.
Could someone help me to clarify the correct syntax for ENCRYPT