Solved

phpMyAdmin simple sql statement

Posted on 2016-10-21
3
72 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 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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PHP Underscores vs. Directory separators 5 27
SQL Syntax 6 41
Delete image(s) associated with record(s) 16 26
Echo values after a query in php 5 24
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

749 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