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 Syntax problem Importance: High 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 function, please? Thank you. EDWIN LIMACHI N. DATACOM - Instalaciones TSE - INFONET BOLIVIA Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]