?
Solved

phpMyAdmin simple sql statement

Posted on 2016-10-21
3
Medium Priority
?
90 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 83

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

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
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 Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

800 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