MySQL Table Fields Change on Table Creation
When I run the following in the MySQL Query:
CREATE TABLE IF NOT EXISTS users (
username VARCHAR(255),
pw VARCHAR(255)
);
The table generated has columns from other tables. Something seems to be happening on the backend that has a bug. The table is created but the structure and data within it is completely off and seems to pull from another table.6 Replies
Project ID:
N/AN/A
where are you running that query?
I also connected in with DBeaver
Which displayed the users table correctly. It looks like its a display thing, not an actual database issue
correct, just a display bug, I would highly recommend you stay away from the data and query tabs, dbeaver is going to work perfectly