YadaTest: Difference between revisions

No edit summary
No edit summary
Line 9: Line 9:
{{#get_db_data:
{{#get_db_data:
  db= vanisearch
  db= vanisearch
  |from= book innner join prop on= book_id=prop_id
  |from= book innner join prop on book_id=prop_id
  |data= bid=book_id,pid=prop_id,name=book_name,desc=prop_desc
  |data= bid=book_id,pid=prop_id,name=book_name,desc=prop_desc
}}
}}

Revision as of 13:31, 13 February 2023

Krsna says 'Me'
Krsna says 'My'
Krsna says 'Mine'

The query SELECT book_id,prop_id,book_name,prop_desc FROM book innner join prop on book_id `prop_id` is invalid (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`prop_id`' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT book_id,prop_id,book_name,prop_desc FROM book innner join prop on book_id `prop_id` ).

Id Desc Text