The Ultimate Guide to High Availability with MariaDB

Comments - How to add/remove users to a table

3 years, 6 months ago Lon Hammonds
Re: How to add/remove users to a table

Add users:

INSERT INTO `temptoolsdb`.`users` VALUES (1,'jon.doe','password1'),(2,'jane.doe','password2'),(3,'jim.doe','password3');

Delete user by ID number:

DELETE FROM `temptoolsdb`.`users` WHERE id = 1;

Delete user by name:

DELETE FROM `temptoolsdb`.`users` WHERE username = 'jon.doe';
 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.