Skip to main content

AIQ-SQL engine doesn't like '*' in 'select *'?

I have an SQL script that has a 'select * ...' line. It fails in Scenario Editor.

 

 Resolution:
 The user need to use proper SQL syntax (every SQL engine use different syntax specifications), if the user is using MySQL as your engine make sure to use single quotes for table names and schemas, same for all of the other SQL data base engines.


 


 


Last updated: June 26, 2023

If you have any feedback on this topic, please contact us at documentation@appvance.ai