Solved

SOURCE statement not working in mySQL front-end

Posted on 2014-01-14
2
237 Views
Last Modified: 2014-01-14
I am using SQLyog in Windows.  The statement
SOURCE 'X:\myscripts\testscript.sql'  
reports a SQL syntax error.  I tried the variations without quotes, with the other slash, with double slash... I think it is the command SOURCE that is not accepted (it doesn't change to a different color in the editor).
0
Comment
Question by:FKoutchouk
2 Comments
 
LVL 12

Accepted Solution

by:
mkishline earned 500 total points
ID: 39779759
I believe you're correct that SQLyog does not support the "SOURCE" command but if it's possible given the structure of your application, you could make your testscript.sql into a stored procedure and then invoke it with "CALL".

Hope this helps.
0
 
LVL 1

Author Closing Comment

by:FKoutchouk
ID: 39779878
Thank you.  Unfortunately testscript.sql changes frequently and needs to be applied to a multitude of databases.  I will ask the folks at mySQL.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PHP connection to remote AWS MySQL RDS 4 68
MSSQL 2008 with mySQL webservers 7 41
Create a Select Query and Populate a Table 3 44
xampp tool 12 25
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now