Solved

SOURCE statement not working in mySQL front-end

Posted on 2014-01-14
2
236 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
Comment Utility
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
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 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

11 Experts available now in Live!

Get 1:1 Help Now