首页 \ 问答 \ 使用dsn使用RODBC将R连接到MySQL(connect R to MySQL with RODBC using dsn)

使用dsn使用RODBC将R连接到MySQL(connect R to MySQL with RODBC using dsn)

 简短版本：我试图弄清楚如何在odbcConnect()函数中使用dsn参数来连接MySQL数据库。  
 更长的版本：如果这是一个无知的问题，我会道歉。 我没有在标签下找到SO搜索的答案。 我不是R的新手，虽然我不是世界上最重要的专家。 我是MySQL新手。 我一直在努力学习它。  
 我希望能够在R中创建表格等，并将它们写入MySQL中的数据库，然后能够在以后从中进行选择并将选定的记录读回R进行分析。 我可以在MySQL中创建一个数据库，选择，导出一个文本文件，然后将该文件读入R中，但我宁愿能够从R做所有事情。为此，我安装了RODBC以便能够将R连接到MySQL直。 我知道我需要使用odbcConnect()函数，但是我不明白为dsn参数添加什么来执行此操作，并且无法从wiki或帮助文件中找出它。  
 细节 （如果需要）：  
I did not establish a uid or password when I set up MySQL

Versions used:          Windows XP;     R 2.10.1;     MySQL 5.5
Locations of exe files: C:\Program Files\MySQL\MySQL Server 5.5\bin  
                        C:\Program Files\R\R-2.10.1\bin  
 
 我希望我需要相当基本的建议 - 例如，最好假设我甚至不知道dsn代表什么（即使这不是真的）。 任何帮助表示赞赏。 提前致谢。 

Short version: I'm trying to figure out how to use the dsn argument in the odbcConnect() function to connect to a MySQL database.  
Longer version: I appologize if this is an ignorant question. I didn't find an answer on SO searching under the tags. I'm not new to R, although I'm not the world's foremost expert. I am new to MySQL. I have been trying to learn it on my own.  
I would like to be able to create tables and such in R and write them to a database in MySQL and then be able to select from them later and read the selected records back into R for analysis. I can create a database in MySQL, select, export a text file, & read that file into R now, but I would rather be able to do everything from R. For this purpose, I installed RODBC to be able to connect R to MySQL directly. I understand that I need to use the odbcConnect() function, but I do not understand what to put for the dsn argument to do this, and haven't been able to figure it out from the wiki or the help file.  
Details (if needed):  
I did not establish a uid or password when I set up MySQL

Versions used:          Windows XP;     R 2.10.1;     MySQL 5.5
Locations of exe files: C:\Program Files\MySQL\MySQL Server 5.5\bin  
                        C:\Program Files\R\R-2.10.1\bin  
 
I expect I need fairly basic advice--e.g., it might be best to assume I don't even know what dsn stands for (even though that's not actually true). Any help is appreciated. Thanks in advance.

原文：https://stackoverflow.com/questions/9539544

更新时间：2024-05-05 16:05

最满意答案

 你根本不需要拥有$myID 。 您可以在promise中使用$index ，因为它已经被限制在循环块中。 这是一个工作修改（..with严格）：  
my @result = do for 0 .. 2 -> $index {
    start {
        say "======> $index\n";

        my $rsSocket = IO::Socket::INET.new:
            localhost => 'localhost',
            localport => 1234 + $index,
            listen    => 1;

        while $rsSocket.accept -> $rsConnection {
            say "Promise $index accepted connection";
            while $rsConnection.recv -> $stuff {
                say "promise $index Echoing $stuff";
                $rsConnection.print($stuff);
            }
            $rsConnection.close;
        }
    }
}

await @result;
 
 有了这种照顾，我觉得有一种冲动指出， no strict使用似乎是非常不必要的。 这不仅会让你打开这些奇怪的范围问题，而且在你的例子中你完全没有得到什么。  
 对未修改的代码严格重新启用并修复两个编译错误显示只保存了四个按键 - 代价是无论您在此输入问题的键是多少。 

You don't really need to have a $myID at all. You can just use $index in the promise because it has already been scoped to the loop block. Here's a working modification (..with strict on): 
my @result = do for 0 .. 2 -> $index {
    start {
        say "======> $index\n";

        my $rsSocket = IO::Socket::INET.new:
            localhost => 'localhost',
            localport => 1234 + $index,
            listen    => 1;

        while $rsSocket.accept -> $rsConnection {
            say "Promise $index accepted connection";
            while $rsConnection.recv -> $stuff {
                say "promise $index Echoing $stuff";
                $rsConnection.print($stuff);
            }
            $rsConnection.close;
        }
    }
}

await @result;
 
With that taken care of I feel the urge to point out that using no strict seems very unnecessary. Not only does it leave you open to weird scope issues like these, but you gain basically nothing from doing it in your example.  
Re-enabling strict on your unmodified code and fixing the two compile errors shows have only saved a total of four keystrokes -- at the expense of however many keys you used typing up your question here.

使用dsn使用RODBC将R连接到MySQL(connect R to MySQL with RODBC using dsn)

最满意答案

相关问答

只能'perl6'解析Perl 6吗？(Can only 'perl6' parse Perl 6?)[2022-12-15]

在Perl6中是否有与Go goroutines相同的功能？(Is there an equivalent to Go goroutines in Perl6?)[2022-04-04]

Perl6：NCurses和鼠标事件(Perl6: NCurses and mouse events)[2022-10-14]

什么承诺会回来？(What promises do return?)[2021-12-18]

使用rakudobrew的perl6的多个版本(Multiple versions of perl6 using rakudobrew)[2022-11-17]

perl6如何获得承诺的具体身份？(perl6 how to get specific identity of promises?)[2021-10-27]

perl5库是否可以在perl6中导入？(Are perl5 libraries are importable in perl6?)[2024-03-24]

等待1个承诺，然后使用$ q进行所有承诺(Wait for 1 promise and then all promises using $q)[2023-09-15]

perl6 / rakudo：perl6默认启用“autoflush”吗？(perl6/rakudo: Does perl6 enable “autoflush” by default?)[2023-07-31]

使用1个或更多jQuery承诺(Working with 1 or more jQuery promises)[2023-07-27]

相关文章

最新问答