...
This is the super user so be careful!
Code Block |
---|
~>hostname fremont ~>/usr/local/mysql/bin/mysql -u platform -h repo.c5sxx7pot9i8.us-east-1.rds.amazonaws.com -p EnterpEnter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 256212 Server version: 5.5.8-log Source distribution Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. This software Oraclecomes with isABSOLUTELY aNO registeredWARRANTY. trademarkThis ofis Oraclefree Corporationsoftware, and/or its affiliates. Other names may be trademarks of their respective owners. you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | innodb | | mysql | | performance_schema | | repositorydb | +--------------------+ 5 rows in set (0.07 sec) mysql> use repositorydb; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A showDatabase changed mysql> show tables; +------------------------+ | Tables_in_repositorydb | +------------------------+ | GAEJDOANALYSISRESULT | | GAEJDOANNOTATIONS | | GAEJDODATASET | | GAEJDODATASETANALYSIS | | GAEJDODATEANNOTATION | | GAEJDODOUBLEANNOTATION | | GAEJDOINPUTDATALAYER | | GAEJDOLAYERLOCATION | | GAEJDOLAYERLOCATIONS | | GAEJDOLONGANNOTATION | | GAEJDOPROJECT | | GAEJDORESOURCEACCESS | | GAEJDOREVISION | | GAEJDOSCRIPT | | GAEJDOSTRINGANNOTATION | | GAEJDOUSER | | GAEJDOUSERGROUP | | NUCLEUS_TABLES | +------------------------+ 18 rows in set (0.08 sec) mysql> desc GAEJDODATASET; +---------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+--------------+------+-----+---------+----------------+ | ID | bigint(20) | NO | PRI | NULL | auto_increment | | ANNOTATIONS_ID_OID | bigint(20) | YES | MUL | NULL | | | CREATION_DATE | datetime | YES | | NULL | | | CREATOR | varchar(256) | YES | | NULL | | | DESCRIPTION | varchar(256) | YES | | NULL | | | NAME | varchar(256) | YES | | NULL | | | NEXT_VERSION_ID_OID | bigint(20) | YES | MUL | NULL | | | RELEASE_DATE | datetime | YES | | NULL | | | REVISION_ID_OID | bigint(20) | YES | MUL | NULL | | | STATUS | varchar(256) | YES | | NULL | | +---------------------+--------------+------+-----+---------+----------------+ 10 rows in set (0.07 sec) mysql> select count(*) from GAEJDODATASET ; +----------+ | count(*) | +----------+ | 114 | +----------+ 1 row in set (0.08 sec) mysql> quit |
Notes for the sake of posterity
...