imported table shows id column but none there
Posted by:
Fran Lee
Date: January 14, 2018 06:03PM
I just imported a CSV file into my small MySQL database.
The CSV file had two comma seperated values per line... username and password.
It seemed to have imported OK but when I look at the new tables columns with MySQL Workbench I see 3-columns...
id, username, password
BUT when I query the table...
SELECT id, usernamme, password FROM mydb.users;
Workbench tells me there is no id field.
And I see no id column with this query
SELECT * FROM mydb.users.
Question 1: Did I import the data correctly?
Question 2: Why does Workbench show me an id column when apparently there isn't one?
Question 3: Should I do it over differently?
Thanks for any help.
Subject
Views
Written By
Posted
imported table shows id column but none there
637
January 14, 2018 06:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.