What can i do to insert file name with a single quotes from excel to mysql?
if I put the name without quotation, like this:
Andi
its working out, but if I put the name without quotation ( ' ), like this:
And'i
it didnt work. Please Help :(
What can i do to insert file name with a single quotes from excel to mysql?
if I put the name without quotation, like this:
Andi
its working out, but if I put the name without quotation ( ' ), like this:
And'i
it didnt work. Please Help :(
you need to escape quotation character with a \ (backslash)
character.
see here: http://dev.mysql.com/doc/refman/5.0/en/string-literals.html
also here for php: http://php.net/manual/en/function.mysql-real-escape-string.php