?
Solved

phpMyAdmin simple sql statement

Posted on 2016-10-21
3
Medium Priority
?
102 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 84

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 1000 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 23

Accepted Solution

by:
Ferruccio Accalai earned 1000 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

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month13 days, 19 hours left to enroll

807 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