Creating a table

Question

While creating at table dont we refer to database in which it should be created? In the video lecture sales table was created without pointing to database ? As there is only single database sales we did not mention it?

Answer 1

Hi Sai! Thanks for reaching out. Following the lectures to that point, we have created the 'sales' database, yes. Not only that, but we have set it as a default database in our session (in other words - basically, in our connection at the moment of working in Workbench). Provided that we have a default database to work on, the tables we create will be part of that database. Hope this helps.
Best,
Martin

Creating a table

Submit an answer