mysql - SQL syntax exception -



mysql - SQL syntax exception -

i beginner mysql , want find out why getting sql syntax exception below query:

select a.file_id file_xfer_tracking_detail a, file_xfer_tracking_header b b.transaction_id = a.transaction_id , b.interface_id =? , a.file_name =? , a.status = 'inprocess' , a.update_time > sysdate- 0.003472222222222222 , a.file_id <> ? , b.direction = ?

in mysql workbench, in editor see syntax error @ and b.interface_id=? . beginner , not sure how prepare it,

also, reference bareword sysdate valid syntax oracle, it's invalid mysql.

in mysql, homecoming current datetime, you'd want reference function sysdate(), or function now().

subtracting numeric value date look valid in oracle; it's not valid in mysql.

the particular numeric value specified in query (0.003472222222222222) interpreted oracle fractional part of day, equivalent 5 minutes. ( = 1/24/60 * 5 )

in mysql, equivalent, you'd want like:

now() + interval -5 min

also, ditch old-school comma syntax bring together operation, , utilize join keyword instead, , relocate bring together predicates where clause on clause. (the comma bring together operator still valid syntax, it's outdated , improved syntax has been available long time.)

file_xfer_tracking_detail bring together file_xfer_tracking_header b on b.transaction_id = a.transaction_id ...

mysql sql

Comments

Post a Comment

Popular posts from this blog

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

c# - Create a Notification Object (Email or Page) At Run Time -- Dependency Injection or Factory -

c# - Create a Notification Object (Email or Page) At Run Time -- Dependency Injection or Factory - i have code emails me notification when happens. trying add together page , also remove dependency on email. for reference; have name of notification want send stored string in database. @ runtime have list of people , string representation of want receive. i thought dependency injection ninject, kernel bindings got big , seemed hacking together. then thought simple factory, activator.createinstance(email/page) inotifcation, don't know how handle differing constructor parameters (unless utilize common, complex property, employee, has info need). so far have this: public interface inotification { void sendmessage(); } public class email: inotification { private readonly string _toemailaddress; private string body { { homecoming "email"; } } private static string smtphost { ...
Read more

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more