where should I attach the code I executed for assignments
I tried to execute the code and it did worked but I don't understand where should I attach my file to send it back for your feedback.
Thanks for reaching out.
Can you please be more specific - what type of file are you trying to attach? Do you mean an *.sql file containing code that you'd like us to see?
In general, if you have any questions related to the lectures or exercises, there's no need to send us any files. It would suffice to let us know which section/minute of a lecture you are referring to and provide the code you've executed/tried to execute, as well as a screenshot containing the output/error. We'd be happy to assist by providing an explanation to your query.
Otherwise, please consider that we provide a solution to all course exercises, so you can check your work yourself. If this doesn't help, then please don't hesitate to reply to this thread or open up another one. Thank you!
Hope this helps but please feel free to get back to us should you need further assistance. Thank you.
Thanks for your reply. Yes I'm rereferring to the *.sql file containing code that you'd like to see. I Installed MySQL on my system and tried to execute the query and saved it as *.sql file but I really didn't understood where I should attach this, please help.
Thanks for your reply.
There's no MySQL code (stored in an *.sql file) that we need to see. Nevertheless, should you wish to send us some MySQL code that we can check for you, please copy and paste it as a reply to this message or feel free to send an email to email@example.com.
Looking forward to your reply.
I have a small doubt here. In this lesson we created the database as 'Sales' and the table name also as sales so when I'm trying to do this assignment to select all the records from sales table I have written query in the following way:
SELECT * FROM Sales;
But if I have to mention the database name and the database object name what should I mention as both the database name and table name are same here "Sales".
Appreciate your help!!
There's no need to doubt here. Yes, you can refer to a database name. In your case, you can do that in the following way:
SELECT * FROM sales.sales;
In fact, it is considered good practice to name the database after the, say, most important among the tables from the relational schema. This helps users logically solidify the idea of having and using a particular database (i.e. we can have a sales database about the sales of a company, which can lead to having other tables such as customers, purchases etc.; or we can have an employees database about the employees of a company, associated to data stored in other tables such as salaries, departments etc., containing the relevant information, and so on).
Hope this helps.