search

Shooter7119 / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

source command does not work #1794

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. create an sql file. 
2. store on server at default data directory
3. use "source filename;"  

What is the expected output? it should execute this file as an include file. it 
works in the MySQL terminal .
What do you see instead? error message "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 'source 'my-sql-functions.sql'' at line 1"

NOTE: there should be ability to include files on the local computer as well 
using the "source" command
What version of Sequel Pro are you using? 1.0.2
What version of OS X are you using? 10.6.8
What version of MySQL are you connecting to on the server? 5.5.3

Please provide any additional information below.

Original issue reported on code.google.com by jamilkaz...@gmail.com on 28 Aug 2013 at 2:49

GoogleCodeExporter commented 9 years ago 
I think "source" is a command that's specific to the MySQL command-line client 
- it's not a standard MySQL command.

If you look into LOAD DATA [LOCAL] INFILE, that may do much of what you want.

(I'll close this based on that assumption - will reopen if needs be :)

Original comment by rowanb@gmail.com on 28 Aug 2013 at 3:52