YadaTest: Difference between revisions
Yadasampati (talk | contribs) No edit summary  | 
				Yadasampati (talk | contribs)  No edit summary  | 
				||
| Line 9: | Line 9: | ||
{{#get_db_data:  | {{#get_db_data:  | ||
  db= vanisearch  |   db= vanisearch  | ||
  |from= book innner join prop on  |   |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 | 
|---|