Solved

phpMyAdmin simple sql statement

Posted on 2016-10-21
3
58 Views
Last Modified: 2016-10-21
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
Comment
Question by:Braveheartli
3 Comments
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 250 total points
ID: 41853336
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
 
LVL 22

Accepted Solution

by:
Ferruccio Accalai earned 250 total points
ID: 41853340
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
 
LVL 1

Author Closing Comment

by:Braveheartli
ID: 41853423
thank you both
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question