Hi professor, Can we use mysql workbench instead of Sqlite for practicals and for the project in upcoming future?

Hi,

All queries you submit will be tested with a SQLite environment. Most of the core SQLite commands behave according to the SQL standard, although there are some variations. Therefore, using MySQL may cause unexpected errors, which will deduct your marks.

In summary, please use SQLite in this unit for all assessments.

I agree, it will be more beneficial to use SQLite instead of MYSQL, although it would be worth trying both for your own study purposes if you already have MYSQL installed to see the difference, but to use only the code that works in SQLite for use in the labs.

Thanks, Adam.