Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

radon insert problem #28

Closed
crzqj opened this issue May 16, 2018 · 2 comments
Closed

radon insert problem #28

crzqj opened this issue May 16, 2018 · 2 comments

Comments

@crzqj
Copy link

crzqj commented May 16, 2018

  1. execute this sql on backend mysql-server with no error
    but execute on radon-db-server ,it does not work!
    my english is not so good, did i make myself clear?

mysql> insert into pk_card_enter(cid,id,ltd_code,park_code,mac_code,card_id,type,car_no,acc_time,enter_type,status,action_time,video_no,create_date,door_name,upseason,reader_addr,feeseason,in_car_type,operator,park_name,card_type,in_time,leave_time,is_handset,is_img,phone_in_password,phone_no,file_path,is_hardware,is_csmain,is_subparking,sub_parking,card_car_no,eq_card_no,is_effective,card_sn_id,is_carno_matching,liquidating_code,liquidating_mark,standar_acc_time,up_time) values(111147361,'7bc0087d-0bb5-4cce-81b8-bb9187f9ab19','0001','00010001','000100010001','12816503',2,'粤AS885P','2016-12-01 08:21:30',1,1,'2016-12-01 08:21:30','00010001D0001','2016-12-01 08:21:13','车场入口','2','1','','','刘风连','三寓宾馆停车场','月租卡','2016-12-01 08:21:30',NULL,0,1,NULL,'','20161201/08/2016120108213012816503.jpg',0,1,0,NULL,'粤AS885P',NULL,NULL,'',1,NULL,0,'2016-12-01 08:21:11','2016-12-19 18:36:19');

ERROR 1149 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use, syntax error at position 108 near 'status'
mysql>

@BohuTANG
Copy link
Contributor

Hi,
status is the keyword of the sqlparser.
please use backticks(`) around column names.

@crzqj
Copy link
Author

crzqj commented May 17, 2018

Thanks.
Problem solved.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants