Solved

String delimeter mysql on centos linux

Posted on 2007-11-18
3
366 Views
Last Modified: 2013-12-16
Hello

I have a centos linux installation I think I am having trouble with the os or mysql and the string delimeter, when I can't seem to execute a query that has a string parameter in it, maybe it is a syntax issue

I have tried the following
Select * from users where surname = 'jones'
and
Select * from users where surname = "jones"

I am getting a 1054 error from MySQL unknown column in field list

I can execute a sql query without the where clause successfully and if I put a none string datatype in the where clause seems to execute fine as well.

I have noticed something weird about my centos install anyway in that I need to press the ' key twice fro the character to appear, also " has the same odd behaviour, do I have my system on the wrong encoding.

I am going to try a different keyboard see if it makes a difference

Thanks

Jake
0
Comment
Question by:elschott
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
nizsmo earned 500 total points
ID: 20309760
is your column 'surname' defined in your table users? are they the right case?
0
 

Author Comment

by:elschott
ID: 20309790
for future reference

I changed keyboard made no difference

my keyboard was set to english International that is why when I press the string delimeter I had to press it twice to get the desired effect

when I changed this to english us my keyboard worked as one would expect and now my sql works as one would expect so I think problem solved you may as well have the points nizsmo as I don't know how to close this thread if I worked it out myself

Thanks

Jake
0
 
LVL 21

Expert Comment

by:nizsmo
ID: 20309798
ah some useful information there thank you for sharing. normally your above error is caused by referencing to an undefined column(field) name in your sql statement, but in your case it is otherwise. thanks for sharing.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Fine Tune your automatic Updates for Ubuntu / Debian
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

895 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now