Creating Libnames from MYSQL

[sas_Forum]

HI

query(1)i am having different schemas in a data base (Database name is Mainsd)in mysql the schemas are like sd1,sd2,sd3,sd4 i want to use the tables in
sas,my first question is i should create different libnames to each schemas how should i create the libnames

[sas_Forum]

HI

query(1)i am having different schemas in a data base (Database name is Mainsd)in mysql the schemas are like sd1,sd2,sd3,sd4 i want to use the tables in
sas,my first question is i should create different libnames to each schemas how should i create the libnames

2) I want to connect to another database the name of database is Tempsd and this does not have the schemas how can i connect to it by libname

[Doc_Duke]

To, question 1, you can create separate libnames for each schema.  The syntax is in the manual.  You could also use a passthru query to put the processing burden on the mysql server.  Ditto for syntax.  (I don't use mysql, so you can look up the syntax as easily as I can.)

I often find it easier to use an interactive tool to connect to the database and get the shells together (I like advanced query tool, but there are lots) and then copy the final product into my SAS passthru.

Doc Muhlbaier

Duke