Fast guide to MySQL - part 2

Next part of subset of MySQL commands (for UNIX/Linux admins)

1. Display list of databases

SHOW DATABASES;

2. Display list of tables in current database

SHOW TABLES;

3. Display list of tables in noncurrent database

SHOW TABLES FROM database_name;
at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Compressed tar archive

There are some cases when you want to create compressed tar archive but you do not have enough disk space to keep original files and tar arc...

  • Sample firewall in AIX
    To build firewall under AIX is sample, but as each host based firewall should be done careful 1. Prerequisites To start firewall in AIX yo...
  • Compressed tar archive
    There are some cases when you want to create compressed tar archive but you do not have enough disk space to keep original files and tar arc...
  • Oracle ASM - yet another LVM (system configuration)
    4. Its time for some system administrator tasks. Oracle ASM need special mark of disks will work with 4.1. Because of some reason (i don...