Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: odbc load
From
[email protected] (Kevin Crow, StataCorp LP)
To
"[email protected]" <[email protected]>
Subject
Re: st: odbc load
Date
Fri, 27 Apr 2012 13:42:37 -0500
Jen Zhen <[email protected]> wrote:
>I am trying to load a dataset (or, for size reasons, parts of it) from
>SQL into Stata.
>I got as far as typing
> local db "DRIVER={MySQL ODBC 5.1
>Driver};SERVER=my_server;DATABASE=my_database;UID=jenzhen;PWD=jenzhenspassword;"
> local sql "SHOW tables"
> odbc load, exec("`sql'") conn("`db'") clear
> br
>which shows me a list of all tables in the database "my_database":
>Tables_in_my_database", "table1" and "table2".
>
>However, I don't manage to open one of these tables. I typed
> odbc load, table(table1) conn("`db'") clear
>which I thought should load table1 into memory, but Stata then just tells me:
>
>
> The ODBC driver reported the following diagnostics
> [MySQL][ODBC 5.1 Driver][mysqld-5.1.30]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 'table1' at line 1
> SQLSTATE=42000
>
>Might anyone be able to tell me what I'm getting wrong here?
>
>Thanks so much and best regards,
>JZ
Jen needs to use the -noquote- option of -odbc load-. Unlike other ODBC
drivers, the MySQL ODBC driver does not like quoted table names in the SQL
statement, which -odbc load- does by default.
-Kevin Crow
[email protected]
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/