• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 139
  • Last Modified:

phpMyAdmin simple sql statement

what is wrong with my sql sentence?
I use phpMyAdmin simple sql statement

UPDATE bayibilgileriiki SET verginumarasi='9070045' WHERE uid='9070045';
the error message is :

 #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 'UPDATEÂ bayibilgileriiki SETÂ verginumarasi='9070045' WHEREÂ uid='9070045'' at line 1
0
BR
Asked:
BR
2 Solutions
 
Dave BaldwinFixer of ProblemsCommented:
It looks like you have some extra but invisible characters in your UPDATE statement as shown by 'UPDATEÂ'.  Maybe some UTF-8 version of a blank space where a plain space is expected.
0
 
Ferruccio AccalaiSenior developer, analyst and customer assistance Commented:
Seems you've copied the sql from any external editor. If so past it just as text or write it directly into the phpmyadmin sql editor. As Dave said there're additional chars (Â) in the sql
0
 
BRMarketingAuthor Commented:
thank you both
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now