Issue

I'm using SQL tab in phpmyadmin to play with sql queries.

When I execute SELECT token FROM users WHERE id = 25 it gives me result:

eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjI1In0.TFVltm3hcb9TnVGbgdJuY5VfZwdsEXO5zvbZJOYlTrI

When I try to delete this like so:

DELETE token FROM users WHERE id = 25

I got error

1109 - Unknown table 'token' in MULTI DELETE

I'm confused. What's going on?

Solution

If you're trying to delete just the token:

UPDATE users set token='' WHERE id = 25

If you're trying to delete the whole record:

DELETE FROM users WHERE id = 25

Answered By - jun drie