python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - mysql-workbench

Table is shown only when querying using databasename.tablename

Using mysql workbench. the database is called accountdb. I just imported a table called "keys" (should've used a better name). The table is there when I query this: show tables; When query...
test-img

johnz

mysql

mysql-workbench

Votes: 0

Answers: 0

Finding Max of Max mysql

I am using a table called covid_vaccinations. To briefly explain about the table, it tracks down all the countries' vaccination completion by every single day from Feb xx, 2020 to Jan XX, 2022. The n...
test-img

nivek

mysql

sql

mysql-workbench

Votes: 0

Answers: 1

Latest Answer

You might be able to get away with just using a LIMIT query. A slight modification of your first query: SELECT continent, location, MAX(people_fully_vaccinated) FROM covid_vaccinations WHERE continen...
test-img

Tim Biegeleisen

Is it possible to automatically update datetime for modify_on for any changes in table except few columns

ALTER TABLE app_user add column modifyon datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP It works but for all columns and I want to exclude few column such as lastlogin, InvalidTryCount...
test-img

Vivek

mysql

sql

mysql-workbench

Votes: 0

Answers: 0

Trying to load data into mysql databse but keep getting error message

DatabaseError: (mysql.connector.errors.DatabaseError) 2005 (HY000): Unknown MySQL server host '@127.0.0.1' (11003) (Background on this error at: https://sqlalche.me/e/14/4xp6) engine = create_engine('...
test-img

mcq7

python

mysql-workbench

etl

mysql-python

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs