0

I accidentally added the following line to my SQL database twice:

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_birthdays_ahead', '7');

How do I remove one of them?

4
Contributors
7
Replies
8
Views
7 Years
Discussion Span
Last Post by ZootAllures
0

use delete query

Delete from phpbb_config where config_name = 'allow_birthdays_ahead' it will delete that two data..

And insert it again..

0

use delete query

Delete from phpbb_config where config_name = 'allow_birthdays_ahead' it will delete that two data..

And insert it again..

Rather than delete both and then reinsert, just add LIMIT 1 to the end of the delete, and it'll only delete one of them.

0

Rather than delete both and then reinsert, just add LIMIT 1 to the end of the delete, and it'll only delete one of them.

yes.....as you said select data using limit 1,and then dalete. it's simple

0

So use the following?

Delete from phpbb_config where config_name = 'allow_birthdays_ahead' LIMIT 1
0

So use the following?

Delete from phpbb_config where config_name = 'allow_birthdays_ahead' LIMIT 1

Exactly!:)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.