You could write them in a PHP file and have it run at a time (more or less, it could depend on when the next person accesses your website) you specify.kramsman wrote:Is there a way to write macros or scripts in phpMyAdmin? I want to run a few different queries on multiple tables from time to time. Is there a way to save them in a program that can be run?
Code: Select all
INSERT INTO phpbb_config (config_name, config_value) VALUES ('new_post_colour', 'd82929');Code: Select all
DELETE FROM testBB_config (config_name, config_value) VALUES ('new_post_colour', 'd82929');Thank You.SQL query:
MySQL said: DocumentationCode: Select all
DELETE FROM testBB_config( config_name, config_value ) VALUES ( 'new_post_colour', 'd82929' )
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(config_name, config_value) VALUES ('new_post_colour', 'd82929')' at line 1
Code: Select all
DELETE FROM phpBB_config WHERE config_name = 'new_post_colour';Thanksbattye wrote:Code: Select all
DELETE FROM phpBB_config WHERE config_name = 'new_post_colour';
You're welcomeGreen Light wrote:Thanksbattye wrote:Code: Select all
DELETE FROM phpBB_config WHERE config_name = 'new_post_colour';
and below a line of these:CREATE TABLE phpbb_anti_bot_quest_config (
config_name VARCHAR(255) NOT NULL,
config_value VARCHAR(255) NOT NULL,
PRIMARY KEY (config_name)
);
and then again some of these:INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('abq_register', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('abq_guest', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('abq_variable_name', 'abq_0001');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('IndiQuests_CaseSensitive', '1');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('IndiQuests_ImagePHP', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Individuel_Questions', '1');
...and then more longer onesCREATE TABLE phpbb_anti_bot_quest_confirm (
confirm_id CHAR(32) NOT NULL,
session_id CHAR(32) NOT NULL,
answer VARCHAR(255) NOT NULL,
line1 VARCHAR(255) NOT NULL,
line2 VARCHAR(255) NOT NULL,
line3 VARCHAR(255) NOT NULL,
line4 VARCHAR(255) NOT NULL,
color CHAR(1) NOT NULL,
whichform CHAR(1) NOT NULL,
start_time INT(11) NOT NULL,
PRIMARY KEY (confirm_id)
);
CREATE TABLE phpbb_anti_bot_quest_regconfirm (
confirm_id CHAR(32) NOT NULL,
session_id CHAR(32) NOT NULL,
start_time INT(11) NOT NULL,
PRIMARY KEY (session_id)
);