Description Usage Arguments Author(s) References
View source: R/gta_sql_create_table.R
Creates a data table with the name of your dataframe. Uploads the data frame thereafter.
1 2 3 4 | gta_sql_create_table(write.df = NULL, create.primary.key = NULL,
create.primary.auto.incr = F, create.foreign.key = NULL,
create.foreign.key.parent = NULL, create.foreign.key.del.cascade = T,
append.existing = T, db.connection = "pool")
|
write.df |
The name of the data frame (in quotes) you want to add. |
create.primary.key |
Name of the column that is the primary key. Can only be one. GTA or SQL naming is fine. |
create.primary.auto.incr |
Do you want the primary key to be auto incrementing? Default is TRUE. |
create.foreign.key |
Vector with names of columns that are foreign keys. Can use GTA or SQL naming. |
create.foreign.key.parent |
On what table is the foreign key the primary key? |
create.foreign.key.del.cascade |
What happens to the lines of foreign key if a value is deleted from the primary key is deleted. Default is that they are removed as well. |
db.connection |
Specify the database connection you want to use. Default is 'pool'. |
Global Trade Alert
www.globaltradealert.org
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.