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
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.