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)

Should I trust AI

 Should I trust AI? So far no, sorry.  I tested for the moment (May, 2025) most advanced model for programming and ask very simple question:...

  • 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...