BioloMICS logo
×
BioloMICS menu

Add new table to a database

 
 
 
Only administrators and super-administrators can add a table to a database.
 
  • Click on File to go to the backstage section, select Database and click Edit tables of current database.
     
     
  • There are three ways to add a table:
     
  • Add a new empty table Click Add button.
     
  • Duplicate selected table Click More button and select Duplicate selected table.
     
  • Add preformatted table Click More button, select Add preformatted tables and choose from the available options.
     
     
  • To delete a table from the list, select it and click Delete.
     
     
  • To show the fields of a table, select the wanted table from the list and click on Edit fields.
     
     
  • Note that a number of tables that are always present in each BioloMICS database can be used to store relevant data: user_list_, files_, orders_, lims_dnaextracts_, lims_microplates_, lims_pcr_, lims_primers_, lims_sequencing_.
     
    These tables are always ending with an underscore (_) meaning that no one can delete or remove structural fields from these tables. Additional fields can, however, be added to structural tables.
     
    A few more tables are also present in any BioloMICS based databases but are not visible or updatable by any end user or administrator: connection_list, field_list, group_list, history, log_list, table_list, webpages, websites.
     
    To remove the structural tables from the list, click More and select Hide BioloMICS structural tables.
     
     
  • To assign no rights on the selected table(s) for any of the groups, click More and select Limit record privileges on selected tables.
     
     
  • To assign full rights on the selected table(s) to all of the groups, click More and select Reset privileges on selected tables.
 
 
NB: Be aware that the following names cannot be used as table name, since they are reserved in MySQL:
 
"accessible", "account", "action", "add", "after", "against", "aggregate", "algorithm", "all", "alter", "always", "analyse", "analyze", "and", "any", "as", "asc", "ascii", "asensitive", "at", "auto_increment",
"autoextend_size", "avg", "avg_row_length", "backup", "before", "begin", "between", "bigint", "binary", "binlog", "bit", "blob", "block", "bool", "boolean", "both", "btree", "by", "byte", "cache", "call", "cascade",
"cascaded", "case", "catalog_name", "chain", "change", "changed", "channel", "char", "character", "charset", "check", "checksum", "cipher", "class_origin", "client", "close", "coalesce", "code", "collate",
"collation", "column", "column_format", "column_name", "columns", "comment", "commit", "committed", "compact", "completion", "compressed", "compression", "concurrent", "condition", "connection",
"consistent", "constraint", "constraint_catalog", "constraint_name", "constraint_schema", "contains", "context", "continue", "convert", "cpu", "create", "cross", "cube", "current", "current_date", "current_time",
"current_timestamp", "current_user", "cursor", "cursor_name", "data", "database", "databases", "datafile", "date", "datetime", "day", "day_hour", "day_microsecond", "day_minute", "day_second", "deallocate",
"dec", "decimal", "declare", "default", "default_auth", "definer", "delay_key_write", "delayed", "delete", "des_key_file", "desc", "describe", "deterministic", "diagnostics", "directory", "disable", "discard", "disk",
"distinct", "distinctrow", "div", "do", "double", "drop", "dual", "dumpfile", "duplicate", "dynamic", "each", "else", "elseif", "enable", "enclosed", "encryption", "end", "ends", "engine", "engines", "enum", "error",
"errors", "escape", "escaped", "event", "events", "every", "exchange", "execute", "exists", "exit", "expansion", "expire", "explain", "export", "extended", "extent_size", "false", "fast", "faults", "fetch", "fields",
"file", "file_block_size", "filter", "first", "fixed", "float", "float4",
"float8", "flush", "follows", "for", "force", "foreign", "format", "found", "from", "full", "fulltext", "function", "general", "generated", "geometry", "geometrycollection", "get", "get_format", "global",
"grant", "grants", "group", "group_replication", "handler", "hash", "having", "help", "high_priority", "host", "hosts", "hour", "hour_microsecond", "hour_minute", "hour_second", "identified", "if", "ignore",
"ignore_server_ids", "import", "in", "index", "indexes", "infile", "initial_size", "inner", "inout", "insensitive", "insert", "insert_method", "install", "instance", "int", "int1", "int2", "int3",
"int4","int8", "integer", "interval", "into", "invoker", "io", "io_after_gtids", "io_before_gtids", "io_thread", "ipc", "is", "isolation", "issuer", "iterate", "join", "json", "key", "key_block_size", "keys", "kill", "language", "last",
"leading", "leave", "leaves", "left", "less", "level", "like", "limit", "linear", "lines", "linestring", "list", "load", "local", "localtime", "localtimestamp", "lock", "locks", "logfile", "logs", "long", "longblob", "longtext",
"loop", "low_priority", "master", "master_auto_position", "master_bind", "master_connect_retry", "master_delay", "master_heartbeat_period", "master_host", "master_log_file", "master_log_pos",
"master_password", "master_port", "master_retry_count", "master_server_id", "master_ssl", "master_ssl_ca", "master_ssl_capath", "master_ssl_cert", "master_ssl_cipher", "master_ssl_crl", "master_ssl_crlpath",
"master_ssl_key", "master_ssl_verify_server_cert", "master_tls_version", "master_user", "match", "max_connections_per_hour", "max_queries_per_hour", "max_rows", "max_size", "max_statement_time",
"max_updates_per_hour", "max_user_connections", "maxvalue", "medium", "mediumblob", "mediumint", "mediumtext", "memory", "merge", "message_text", "microsecond", "middleint", "migrate", "min_rows",
"minute", "minute_microsecond", "minute_second", "mod", "mode", "modifies", "modify", "month", "multilinestring", "multipoint", "multipolygon", "mutex", "mysql_errno", "name", "names", "national", "natural",
"nchar", "ndb", "ndbcluster", "never", "new", "next", "no", "no_wait", "no_write_to_binlog", "nodegroup", "nonblocking", "none", "not", "null", "number", "numeric", "nvarchar", "offset", "old_password", "on",
"one", "only", "open", "optimize", "optimizer_costs", "option", "optionally", "options", "or", "order", "out", "outer", "outfile", "owner", "pack_keys", "page", "parse_gcol_expr", "parser", "partial", "partition",
"partitioning", "partitions", "password", "phase", "plugin", "plugin_dir", "plugins", "point", "polygon", "port", "precedes", "precision", "prepare", "preserve", "prev", "primary", "privileges", "procedure", "processlist",
"profile", "profiles", "proxy", "purge", "quarter", "query", "quick", "range", "read", "read_only", "read_write", "reads", "real", "rebuild", "recover", "redo_buffer_size", "redofile", "redundant", "references", "regexp",
"relay", "relay_log_file", "relay_log_pos", "relay_thread", "relaylog", "release", "reload", "remove", "rename", "reorganize", "repair", "repeat", "repeatable", "replace", "replicate_do_db", "replicate_do_table",
"replicate_ignore_db", "replicate_ignore_table", "replicate_rewrite_db", "replicate_wild_do_table", "replicate_wild_ignore_table", "replication", "require", "reset", "resignal", "restore", "restrict", "resume", "return",
"returned_sqlstate", "returns", "reverse", "revoke", "right", "rlike", "rollback", "rollup", "rotate", "routine", "row", "row_count", "row_format", "rows", "rtree", "savepoint", "schedule", "schema", "schema_name",
"schemas", "second", "second_microsecond", "security", "select", "sensitive", "separator", "serial", "serializable", "server", "session", "set", "share", "show", "shutdown", "signal", "signed", "simple", "slave", "slow",
"smallint", "snapshot", "socket", "some", "soname", "sounds", "source", "spatial", "specific", "sql", "sql_after_gtids", "sql_after_mts_gaps", "sql_before_gtids", "sql_big_result", "sql_buffer_result", "sql_cache",
"sql_calc_found_rows", "sql_no_cache", "sql_small_result", "sql_thread", "sql_tsi_day", "sql_tsi_hour", "sql_tsi_minute", "sql_tsi_month", "sql_tsi_quarter", "sql_tsi_second", "sql_tsi_week", "sql_tsi_year",
"sqlexception", "sqlstate", "sqlwarning", "ssl", "stacked", "start", "starting", "starts", "stats_auto_recalc", "stats_persistent", "stats_sample_pages", "status", "stop", "storage", "stored", "straight_join", "string",
"subclass_origin", "subject", "subpartition", "subpartitions", "super", "suspend", "swaps", "switches", "table", "table_checksum", "table_name", "tables", "tablespace", "temporary", "temptable", "terminated", "text",
"than", "then", "time", "timestamp", "timestampadd", "timestampdiff", "tinyblob", "tinyint", "tinytext", "to", "trailing", "transaction", "trigger", "triggers", "true", "truncate", "type", "types", "uncommitted",
"undefined", "undo", "undo_buffer_size", "undofile", "unicode", "uninstall", "union", "unique", "unknown", "unlock", "unsigned", "until", "update", "upgrade", "usage", "use", "use_frm", "user", "user_resources",
"using", "utc_date", "utc_time", "utc_timestamp", "validation", "value", "values", "varbinary", "varchar", "varcharacter", "variables", "varying", "view", "virtual", "wait", "warnings", "week", "weight_string",
"when", "where", "while", "with", "without", "work", "wrapper", "write", "x509", "xa", "xid", "xml", "xor", "year", "year_month", "zerofill"