Task: list existing databases, connect to one of the databases, then list existing tables and finally show the structure of one of the tables.
In Mysql:
show databases;
use database;
show tables;
describe table;
exit
In PostgreSQL:
\l
\c database
\dt
\d+ table
\q
No comments:
Post a Comment