MySQL Forums
Forum List  »  MySQL Workbench

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.

Options: ReplyQuote

Written By
imported table shows id column but none there
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.