Newb SQL Question

[FC Jamison]

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?

[logonchristy]

use delete query

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

And insert it again..

[logonchristy]

it will delete duplicate

delete data
from table_name
where count(data)>1;

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.

[logonchristy]

great yar...

[muralibobby2015]

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

[FC Jamison]

So use the following?

Delete from phpbb_config where config_name = 'allow_birthdays_ahead' LIMIT 1

So use the following?

Delete from phpbb_config where config_name = 'allow_birthdays_ahead' LIMIT 1

Exactly!:)