Home>

An error occurred when trying to add a record to Mysql.
It looks like a syntax error.

It seems that an error appears at {}, but I want to put {}
Can {} be added to the record without error?

Thank you

mysql>show columns from personal_logs;
+ ------------- + ------------- + ------ + ----- + -------- -+ ---------------- +
| Field | Type | Null | Key |
+ ------------- + ------------- + ------ + ----- + -------- -+ ---------------- +
id | int (11) | NO | PRI | NULL | auto_increment |
logid | varchar (32) | NO | MUL | NULL |
macaddr | varchar (20) | NO | MUL | NULL |
| aid | varchar (20) | YES | MUL | NULL |
| auth_policy | varchar (20) | YES | | NULL |
| provider | varchar (20) | YES | | NULL |
| data | text | YES | | NULL |
cdate | datetime | YES | | NULL |
| udate | datetime | YES | | NULL |
+ ------------- + ------------- + ------ + ----- + -------- -+ ---------------- +
mysql>insert into personal_logs values ​​("aaabbbcccdddeeefffggg", "AA: BB: CC: DD: EE: FF", "A00200200", "mail",
       "Facebook", "{" uid "=>" 111222333 "," email "=>" [email protected] "}");
ERROR 1064 (42000): You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near 'uid "=>" 111222333 "," email "=>" apple @ gmail.com "}") 'at line 1