How do I access my MySQL DB through command line?

Question

So I'm working on this Django project, with MySQL as DB engine.
I made some sort of mistake, and now I have to drop a table I accidentally created. So I'm trying to access the DB through command line, but cannot figure out how.

Could anyone help? Or is there a better way of dropping a table in MySQL DB?
Thanks in advance.

EsmaeelE · Accepted Answer · 2024-02-06 18:09:04Z

0

Use the dbshell command

python manage.py dbshell

then while in the shell, depending on what database you are using, you type the command to show tables to identify the table you want to drop.

still in the shell, you can use SQL command to drop the table

DROP TABLE shop_brand;

source => How can i delete database table in django?

edited Feb 6, 2024 at 18:09

EsmaeelE

2,7557 gold badges28 silver badges36 bronze badges

answered Apr 19, 2021 at 14:50

M.S_A

264 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kawegh74 · Accepted Answer · 2021-04-19 14:27:22Z

0

You can use python manage.py dbshell.

answered Apr 19, 2021 at 14:27

Kawegh74

8216 silver badges11 bronze badges

Collectives™ on Stack Overflow

How do I access my MySQL DB through command line?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related