First, don't use the word "table" in an insert into statement (e.g. `INSERT
INTO tbl_nm (col_1, col_2, col_3) VALUES ('a', 'b', 3)` where tbl_nm is the
name of a table in the database and col_1, col_2, etc. are names of columns
in the specified table). Second, 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 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]
