Solved

String delimeter mysql on centos linux

Posted on 2007-11-18
3
367 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
wifi not working on Raspberry Pi 3? 2 56
Need BIOS update Linux for MSI X99A motherboard. 4 41
change database name 2 30
Insert values are dynamic 11 41
Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

773 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