Execute Question

[gaspower]

Hello,

I was instructed to use SQLYog instead of phpmyadmin, so sorry very new to this program. I have instructions for phpmyadmin, and wondering if I am going the correct route in executing. In phpmyadim I am told to import the following into my database:

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Send HTML or Text Invoices to Customers', 'EMAIL_INVOICE', 'true', 'If this is enabled, order invoices will be sent to the customer in HTML format.

Enabled = true
Disabled = false

To use this, you must have HTML E-mails enabled.

', '12', '0', NULL , NOW( ) , '', “tep_cfg_select_option(array('true', 'false'),”);

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Default E-Mailed HTML Invoice Template', 'EMAIL_TEMPLATE_FILE', 'html_invoice.php', 'Template file you will be using for HTML invoices to the customer

invoice.php – Stock osC look
html_invoice.php – HTML version
box_invoice.php – HTML version

', 12, 0, NULL, NOW(), '', '');

So if I am to the same with SQYyog, and my understanding paste the above into Query, and of coarse choose my database from the dopdown box, and click green arrow to execute current querry? Is this correct.

Thanks For The Help

JR

Sorry, another question, because I did the above on a sample database and I did receive in the message window:

(1 row(s)affected)

(0 ms taken)

(1 row(s)affected)

(0 ms taken)

Is this correct response?

Thanks JR

[peterlaursen]

Quote:

click green arrow to execute current querry? Is this correct.

Basically yes!

You have 2 SQL-statements here. They are divided by semicolon. Every statement generates a Server Response when executed.

To execute ALL statements you click the 'double green arrow' . To execute a single statement you position the cursor inside that statement and click the 'single green arrow'. Keyboard shourtcuts are F5 and shift+F5 respectively.

[Author]

Posts