CODEWITHSUNDEEP
mysqlmysql-error-1054
Yasmin Fakhruddin
Yasmin Fakhruddin

Reputation: 11

what does this mean "Table "total_bikeshare" must be qualified with a dataset (e.g. dataset.table)." in sql

I am trying the combine 12 months datasets into one table, i tried using CREATE TABLE function but i am getting below error-

Table "total_bikeshare" must be qualified with a dataset (e.g. dataset.table). Please help this understand what this means?

Upvotes: -1

Views: 772

Answers (1)

Kervin Soriano
Kervin Soriano

Reputation: 1

I'm doing the same data set and the one that did it for me is to change the format you used for the view as folder_name.data_set.view_name.

Same as this. gothic-victor-368405.trip_data.trip_data_2022

Upvotes: 0

Related Questions