Question

I m trying to follow a mysql tutorial from The New Boston on youtube. However, I have a problem with the sql panel in phpmyadmin interprets text in quotes as columns. In my version of phpMyadmin, (Server version: 5.1.55,Protocol version: 10,MySQL client version: 5.1.55)I did not see a way to turn this off. Please see images from this link http://leobee.com/android/push/phpmyadminerrors.html

In phpMyAdmin columns can have quotes or be without quotes in sql queries: See Image 1 and Image 2

The error 1054 unknown column for the name of a city (which is a string):
See Image 3

I get an error 1064 error in syntax when I escape the string: See Image 4

引用被从城市的字符串周围删除时,我也会得到错误(这是对的) 。

错误日志显示它是一个语法错误, 但它不是。我如何获得应用程序只对字符串使用引号?

Answer 1

PhpMyAdmin, 像 MySQL 一样使用报价和反方向。两者都不同, 不应互换使用。

列或表格使用后向图 :

SELECT * FROM `customers`
-OR-
SELECT `city` FROM `customers`

使用单引号会出错 :

SELECT * FROM  customers 
-OR-
SELECT  city  FROM  customers

字符串应使用单引号。

SELECT * FROM `customers` WHERE `city`= Raleigh 
-OR-
SELECT city FROM customers WHERE city= Lee s Summit

以不正当的方式排除引号将会造成错误:

SELECT * FROM `customers` WHERE `city`= Raleigh 
-OR-
SELECT city FROM customers WHERE city= Lee s Summit

希望有帮助!

友情链接