{mysql} | R# Documentation

# mysql

`require(graphQL);
#' MySQL (/ˌmaɪˌɛsˌkjuːˈɛl/) is an open-source relational database management system (RDBMS).
imports "mysql" from "graphR";`

MySQL (/ˌmaɪˌɛsˌkjuːˈɛl/) is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

.NET clr type export

.NET clr function exports
close_ssh | Close the ssh proxy connection
open | open a mysql connection, construct a database model
dump_inserts | dump the inserts transaction mysql file
create_filedump |
write_dumps |
table | Create a table reference
group_by |
left_join | mysql left join
on | on join condition test for left join operation
get_last_sql | get the last mysql query that execute
add | make insert into of a new record into database
save | make update of the database record
count |
where |
order_by |
project | make project of a single column
check | check of the target record is existsed inside the database or not?
find |
exec | exec sql and fetch result data as dataframe
select | make data pull from database
limit |
performance_counter | run the mysql performance counter in a given timespan perioid.

[Document Index]