MySQL: join with special character in column name -


i have column name special character "truck_#". 2 tables "shipment" , other "truck". both have "truck_#" column in common. want perform join on column "truck_#"

i have written query

select * shipment right join truck on shipment.truck_#=truck.truck_#

it gives me error saying

unknown column name 'shipment.truck_' near on

i think not taking special character. can tell me how correct it. thanx in advance.

select * shipment right join truck on `shipment`.`truck_#`=`truck`.`truck_#`

Comments

Post a Comment

Popular posts from this blog

css - I want to align grid in center -

as see code grid_2 has float left. added center class fix in center div block floating left. want place grid_2 div in center. can 1 me fix this? html code: <div class="center"><div class="grid_2">content goes here </div> </div> css: .grid_0 { width: 100%; margin-bottom: 15px; display: block; } .grid_1, .grid_2, .grid_3, .grid_3c, .grid_4, .grid_4c { margin-left : 1.00%; margin-right : 1.00%; margin-bottom : 15px; float : left; display : block; -webkit-box-sizing: border-box; /* safari/chrome, other webkit */ -moz-box-sizing: border-box; /* firefox, other gecko */ box-sizing: border-box; /* opera/ie 8+ */ } .center{ display: block; text-align: center; margin: 0 auto !important; } .grid_1 { width: 98%; } .grid_2 { width: 48%; } please find link below http://jsfiddle.net/kiranm/aqbs6/5/ ok, here problem lies in width of grid_2. as width of grid_2 = 48% of...
Read more

Contact Form PHP Email Script -

Image
hello having problem email script on site. i used files https://jonbake.com/blog/bootstrap-3-contact-form-with-captcha/ but add fields. sending email i'm not receiving data inputted on fields. here html form <form role="form" id="feedbackform"> <div class="form-group"> <input type="text" class="form-control" id="first_name" name="first_name" placeholder="first name"> <span class="help-block" style="display: none;">please enter name.</span> </div> <div class="form-group"> <input type="text" class="form-control" id="last_name" name="last_name" placeholder="last name"> <span class="help-block" style="display: none;">please enter name.</span> </di...
Read more

python - SWIG function not printing output -

i'm having prblem in executing function i've written in c. i've made , interface file given below: %module cnode %{ #include "cnode.h" %} %include "cnode.h" and here c program : #include <stdio.h> #include "cnode.h" void kill(void) { printf("method executed\n"); } the header file: void kill(void); when i'm trying execute in python interpreter, don't output. there problem declarations or bug? figured out, kill() predefined function won't work. changing name of function works fine.
Read more