My insert query is:
INSERT INTO merchant_cfg ( merchant_id , NAME, VALUE ) VALUES ( 146 , 'detailed_listing_full.enabled' , 'true' ) ;
I am getting the following result:
1 queries executed, 0 success, 1 errors, 0 warnings
Query: insert into merchant_cfg ( merchant_id , name, value ) values ( 146 , 'detailed_listing_full.enabled' , 'true' )
Error Code: 1064
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 '( 146 , 'detailed_listing_full.enabled' , 'true' )' at line 1
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0 sec
Table schema is:
Field Type Null Key Default Extra
----------- ------------ ------ ------ ------- ----------------
id bigint(20) NO PRI (NULL) auto_increment
merchant_id bigint(20) NO MUL (NULL)
name varchar(50) NO (NULL)
value varchar(500) YES (NULL)