Page 1 of 1

Remove code in SQL

Posted: Sun Dec 07, 2008 4:04 pm
by Meados
Hello, I had ran this code in sql:

Code: Select all

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('seo_ext', 'html', 0);
And I would like delete what it did. Somebody can help me? Thanks.

Re: Remove code in SQL

Posted: Sun Dec 07, 2008 4:19 pm
by HGN

Code: Select all

DELETE FROM phpbb_config WHERE CONVERT(config_name USING utf8) =  'seo_ext' LIMIT 1

Re: Remove code in SQL

Posted: Sun Dec 07, 2008 4:19 pm
by Erik Frèrejean
Run this query:

Code: Select all

DELETE FROM phpbb_config
   WHERE config_name = 'seo_ext';
[edit]
Beaten to that one :P

Re: Remove code in SQL

Posted: Sun Dec 07, 2008 4:40 pm
by Meados
Erik Frèrejean wrote:Run this query:

Code: Select all

DELETE FROM phpbb_config
   WHERE config_name = 'seo_ext';
[edit]
Beaten to that one :P
I used that thanks. Ins't necessary excute this code too? (sorry I am a noob at commands in mysql)

DELETE FROM phpbb_config
WHERE config_name = 'html';

Thank you.

Re: Remove code in SQL

Posted: Sun Dec 07, 2008 5:30 pm
by Lumpy Burgertushie
yes, or you could simply use your sql manager ( phpmyadmin or whatever) and delete that row from the config table.


robert

Re: Remove code in SQL

Posted: Sun Dec 07, 2008 5:41 pm
by Erik Frèrejean
Meados wrote:
Erik Frèrejean wrote:Run this query:

Code: Select all

DELETE FROM phpbb_config
   WHERE config_name = 'seo_ext';
[edit]
Beaten to that one :P
I used that thanks. Ins't necessary excute this code too? (sorry I am a noob at commands in mysql)

DELETE FROM phpbb_config
WHERE config_name = 'html';

Thank you.
No you don't have to run that. This SQL query will remove the whole row you added with your query.

Re: Remove code in SQL

Posted: Sun Dec 07, 2008 5:57 pm
by Meados
Erik Frèrejean wrote:
Meados wrote:
Erik Frèrejean wrote:Run this query:

Code: Select all

DELETE FROM phpbb_config
   WHERE config_name = 'seo_ext';
[edit]
Beaten to that one :P
I used that thanks. Ins't necessary excute this code too? (sorry I am a noob at commands in mysql)

DELETE FROM phpbb_config
WHERE config_name = 'html';

Thank you.
No you don't have to run that. This SQL query will remove the whole row you added with your query.
Ok thanks. :P