php - Cant import data due to illegal double -


i having annoying problem trying import wordpress db backup using wootickets sell tickets event , customers db complaing on xampp a illegal double here in insert statement shown below. hudreds of these values scattered thruought the file persume used security.

insert fl_postmeta ( meta_id , post_id , meta_key , meta_value ) values ( 165743, 3313, '_tribe_wooticket_security_code', 'e801d16bb2' );

mysql said: documentation

1367 - illegal double '342e880385' value found during parsing

my question why case when exported linux platform xamp testing how fix this

the value 342e880385 should put inside single quotes, so:

insert fl_postmeta ( meta_id , post_id , meta_key , meta_value ) values ( 162936, 3115, '_tribe_wooticket_security_code', '342e880385' ); 

otherwise, mysql try parse number.


Comments

Popular posts from this blog

c++ - llvm function pass ReplaceInstWithInst malloc -

Cross-Compiling Linux Kernel for Raspberry Pi - ${CCPREFIX}gcc -v does not work -

java.lang.NoClassDefFoundError When Creating New Android Project -