<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ??一站式輕松地調用各大LLM模型接口,支持GPT4、智譜、豆包、星火、月之暗面及文生圖、文生視頻 廣告
                # 讀取資料庫的資料 ### 讀取資料庫的資料 利用 DBI、gWidgets、RMySQL 與 dbConnect 等 package 讀取資料庫資料,以下是讀取 MySQL 資料庫當作範例。 ~~~ > library(DBI) # DBI 是 R Database Interface > library(gWidgets) > library(RMySQL) # MySQL 在 R 的 INterface > library(dbConnect) > con <- dbConnect(MySQL(), dbname = "house_development", username="root", password="123456") # 建立資料庫連線 > > dbSendQuery(con,"SET NAMES utf8") #需設定 UTF-8,不然中文會亂碼。 <MySQLResult:(94576,0,0)> > dbClearResult(dbListResults(con)[[1]]) [1] TRUE > > dbGetQuery(con,"show variables like 'character_set_%'") # 查詢資料庫基本設定 Variable_name Value character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_filesystem binary character_set_results utf8 character_set_server utf8 character_set_system utf8 character_sets_dir /usr/local/Cellar/mysql/5.6.12/share/mysql/charsets/ data = dbGetQuery(con, "select * from raws") # 使用 SQL query 讀取資料。 ~~~ 註:如果資料庫不太熟,卻又想學習基本的語法的話,推薦 [新SQL 基礎講座 <增訂第二版>](http://www.books.com.tw/products/0010396522),此本的好處是記載不同資料庫的語法且淺顯易懂。
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看