INSERT Acting Oddly

[AlanNP]

Hello,

MySQL Control Center runs the following sort of stuff without complications:

Code:

INSERT INTO `Page_Modification_Times` VALUES ('ShowCookies.php', 1092338412);
INSERT INTO `Page_Modification_Times` VALUES ('Strychnine.php', 1092338413);
INSERT INTO `Page_Modification_Times` VALUES ('Tick.php', 1092338413);
INSERT INTO `Page_Modification_Times` VALUES ('Violence.php', 1092338414);
INSERT INTO `Page_Modification_Times` VALUES ('Visitors.php', 1092338415);
INSERT INTO `Page_Modification_Times` VALUES ('Volunteer.php', 1092338416);
INSERT INTO `Page_Modification_Times` VALUES ('Wadi.php', 1092338416);

When I try to run it from SQLYog 3.71 by pushing the F5 button, it only inserts one line per run. What am I missing?

Alan.

[peterlaursen]

F5 means “execute current query”. Queries in Sqlyog terminologi are divided by “;”. Therefore, You'll need to “execute all queries”. The easiest way is to click on the 'double green arrow' on the icon bar (no. 2 from the left). I don't think there is a standard keyboard shortcut for that. Accoding to the help menu, these are the shortcuts below. But it could be an idea to assign for instance F4 for “execute all queries” in future versions …. However I never use keyboard shortcut's so I don't mind 🙂

F5 Execute Current Query

F8 Execute For Update

F1 Help

F3 Keyboard Shortcuts Window

F6 Alter Table Structure

F7 Manage Index Window

F9 Refresh Object Browser

F10 Manage Foreign Relationships

F11 Insert Update Dialog

Ctrl+1 Show/Hide Object Browser

Ctrl+2 Show/Hide Result Pane

Ctrl+3 Show/Hide Query Window

Ctrl+B Set Focus On Object Browser

Ctrl+D Create Database

Ctrl+E Set Focus On SQL Window

Ctrl+F Find

Ctrl+L Toggle Result In Text/Grid Mode

[peterlaursen]

I'm sorry – I missed more then half of the shortcuts

thes are hat you need

Ctrl+F5 Execute Selected Query(s)

Shift+F5 Execute All Query(s)

[Ritesh]

Execute All Query(s)… (Shift+F5) is the option you are looking for.

[AlanNP]

Thanks, gang. I'd worked out that the semicolons had something to do with it, then gone off on a tangent deleting them.

Alan.

[Shadow]

Hope, you put those semicolons back before executing a mass INSERT…

[Author]

Posts